Skip to main content
Integration
Search
Search DataFlow Support Help and Support.

This article applies to:

  • Product: ONESOURCE DataFlow
  • Subject: Integration

DataFlow Classic methods

DataFlow Classic methods, called DCDF methods, are provided to ease the transition from DataFlow Classic to DataFlow.

DCDFGetID

Extraction
In Request
No
Yes
Retrieved the request id for a request in DataFlow Classic matching the parameters provided. When more than one request is found, an error is returned.
Syntax
Extraction
In Request
Not Available
= DCDFGetID (Entity ID, Entity Name, Excel Template Name, Template, Tax Type, Year, Period, Status, Codes, Jurisdiction, Scenario, Client Name, Client Number)

DCDFGetList

Extraction
In Request
No
Yes
Retrieves a list of requests, which match the criteria and places the list in the output range.
Output Range is required, all others are optional, but as many as possible should be provided to keep the resulting list as small as possible.
Syntax
Extraction
In Request
Not Available
DCDFGetList (Output Range, Entity ID, Entity Name, Template Name, Tax Type, Year, Period, Status, Codes, Scenario, Jurisdiction, Client Name, Client Number, Use Client Manager fields)

DCDFGetBlock

Extraction
In Request
No
Yes
Retrieves the values of a [basename].block range from a request.
Syntax
Extraction
In Request
Not Available
DCDFGetList (Output Range, Entity ID, Entity Name, Template Name, Tax Type, Year, Period, Status, Codes, Scenario, Jurisdiction, Client Name, Client Number, Use Client Manager fields)

DCDFGetTable

Extraction
In Request
No
Yes
Retrieves the DFTable from the provided requestid.
Syntax
Extraction
In Request
Not Available
DCDFGetTable (RequestID list range, Output range, Tablename, Column, Column value)

DCDFGetValues

Extraction
In Request
No
Yes
Retrieves the values from the DataFlow Classic request for the given names.
Syntax
Extraction
In Request
Not Available
DCDFGetValues (Request id, Tag Range, Output range, ignore invalid)

DCDFGetValuesEx

Extraction
In Request
No
Yes
Retrieves the values from the DataFlow Classic request for the given names.
Syntax
Extraction
In Request
Not Available
DCDFGetValues (Request id, Tag Range, Output range, ignore invalid)

DCDFLoadRange

Extraction
In Request
No
Yes
Syntax
Extraction
In Request
Not Available
DCDFLoadRange (Request Id, Input range)

DCDFLoadWildcard

Extraction
In Request
No
Yes
Syntax
Extraction
In Request
Not Available
DCDFLoadWildCard (Request id, Input Range, Output Range)

Utility methods

Utility Methods are designed to provide functionality to replace or assist in request behaviors or other purposes.

RefersToSheetName

Extraction
In Request
No
Yes
Replaces the CELL() method of Excel to retrieve the name of a sheet for the passed range reference.
Syntax
Extraction
In Request
Not Available
=DCRefersToSheetName(Range)