Load Data Activity - Continued
About this task
- The optional field is PartNumber.
- If no value is specified, the connector checks if the DataFile has more than 10,000 rows. If the ' DataFile ' has more than 10,000 rows, the connector would internally split the data in to chunks of 10,000 and upload the data to Salesforce Analytics with PartNumber starting at 1.
- If value is specified, the connector would not do any splitting and just upload the data to Salesforce Analytics with the specified ' PartNumber'.
- ' 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'.
- Refer the topic Example 1: How to Configure the Write XML Activity for XML Data to see how the 'Write XML' activity should be configured to serialize the XML data in the orchestration
Note: If the ‘success’ field has the value ‘true’, the operation is successful. If ‘false’, it has
failed.
PartNumber |
DataFormat |
Connector Behavior |
---|---|---|
Specified |
XML |
The connector will convert DataFile into CSV, but will not split the CSV. Special characters like comma, double quotes, new line will be escaped during conversion. It will upload the CSV to Salesforce Analytics |
Specified |
CSV |
The connector will not do any conversion or splitting. It will upload the CSV as-is to Salesforce Analytics. It is responsibility of integration developer to escape the special characters in the CSV as specified in the Salesforce Analytics documentation |
Not Specified |
XML | The connector will try to convert DataFile into CSV and also, split the CSV into chunks of 10,000 rows. Special characters like comma, double quotes, new line will be escaped during conversion. It will upload the data chunks to Salesforce Analytics with PartNumber starting with 1 |
Not Specified | CSV | The connector will not do any conversion, but will split the DataFile into chunks of 10,000 rows and upload the chunks to Salesforce Analytics with PartNumber starting with 1. Please note that the connector uses newline character as the line separator for splitting the CSV. To use this configuration, the CSV data should not contain any newline character as part of field value. It is responsibility of integration developer to escape the special characters in the CSV as specified in the Salesforce Analytics documentation |