Bulk Updating Rows


Bulk Updating Rows


UPDATE calls SF_TableLoader, which

  • reads each row of the Input table
  • maps the columns to the fields of the Salesforce object
  • attempts to update an object in Salesforce using the ID column of the input table

The Input table should only contain columns for those fields that you want to update. If the data in a column is an empty string or NULL, SF_TableLoader updates that field on Salesforce.com to be NULL. You can modify this behavior by using the following value for the operation:

Update:IgnoreNulls

The IgnoreNulls option tells SF_TableLoader to ignore null values in columns. This option can only be used with the SOAP API of Salesforce, so if you use it, you should also explicity include the soap option since IgnoreNulls does not work with the BulkAPI of Salesforce. For example:

EXEC SF_TableLoader 'Update:IgnoreNulls,soap','Salesforce','Account_Upd'

However, empty string values still set the field on Salesforce.com to NULL. For each row in the Input table that failed to update, the Error column in the Result table contains an error message for the failure.