Preparing Data for the Force.com Bulk API connector

The Force.com Bulk API connector supports both XML and CSV input data. Following are the details to prepare data for these formats.

Preparing data for XML input

If you are using the XML data as input to the Force.com Bulk API connector, you can either create an XML schema, which can be mapped to the Force.com Bulk API activity or directly map from the previous activity's result to Force.com Bulk API activities.

Preparing data for CSV input

Force.com Bulk API connector supports CSV input data from connector version 2.2. If you have the CSV data, you can directly map the CSV content to Force.com Bulk API activities. To do so, Force.com Bulk API connector activities expose two new fields, object and data, in the Map Inputs section. You must map the CSV content to data field and provide the selected object name in the object field.

Following is the sample for the CSV data, for Account object.
Name,BillingStreet,BillingCity,BillingState,BillingCountry
XYZ,vvnagara,Bangalore,KA,India
Note:
  1. In the CSV data, the first line must contain comma separated field names of the selected object, and from the second line, the actual data must be populated.
  2. The order of the data fields must match that of the header field names.



Feedback | Notices


Timestamp icon Last updated: Wednesday, 15 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/SFDCBulkAPI_preparing_data.html