Load Data Activity
This activity loads the file data to the dataset. The data can be passed in bulk or split
in accordance with the Salesforce API limitation, where each chunk must contain less than 10,000
rows
Procedure
Salesforce Analytics API Limits:
The number of rows in a single data load, cannot be more than 10,000. If the ' DataFile ' of the 'Load Data' Activity has more than 10,000 rows and no ' PartNumber ' is specified, the connector will take care of splitting it into chunks of 10,000 rows and then invoke the Salesforce Analytics API with PartNumber starting at 1
A few other limits are listed below. It is the responsibility of the integration developer to ensure that the data adheres to the latest limits specified by the Salesforce Analytics documentation
- Maximum file size per external data upload
- Maximum number of characters in a field
- Maximum number of fields in a record
- Data or data chunks are less than 10-MB
- ' InsightsExternalDataId ': Specify the Id value of the dataset received from Create Dataset activity
- ' DataFile ': Map the file data encoded using the Base64 Encode function. File data can be in CSV or XML format
- ' DataFormat ': Specify if the ' DataFile ' is in XML or CSV format. ('XML' or 'CSV' are the accepted values). This field is used internally by the connector to understand the format of ' DataFile '
Result:
If the ' DataFormat ' is XML, the connector would try to convert the ' DataFile ' from XML to CSV.
If the ' DataFormat ' is 'CSV', no conversion will happen.
