View Jitterbit Developer Portal
Introduction
This page covers Jitterbit variables that are available for Salesforce (SFDC), organized by informational variables that you get (read), and settings variables that you set (write):
Informational
jitterbit.sfdc.failure_record_countjitterbit.sfdc.query.record_countjitterbit.sfdc.success_record_count
Settings
Informational
jitterbit.sfdc.failure_record_count
| Variable | jitterbit.sfdc.failure_record_count |
|---|---|
Data Type | Integer |
| Description | Returns the number of failure records from a Salesforce upsert, insert, update, or delete operation. For example, this variable may be used within a script to apply the logic that if failure record count is not equal to zero, then <trans> If($jitterbit.sfdc.failure_record_count != 0, RaiseError(“All record updates were not successful. Please review logs.”) ) </trans> |
jitterbit.sfdc.query.record_count
| Variable | jitterbit.sfdc.query.record_count |
|---|---|
Data Type | Integer |
| Description | Returns the number of records returned by a Salesforce query operation. For example, this variable may be used within a script to record the number of queried records in the operation log: <trans> WriteToOperationLog(There were $jitterbit.sfdc.query.record_count records queried.) </trans> |
jitterbit.sfdc.success_record_count
| Variable | jitterbit.sfdc.success_record_count |
|---|---|
Data Type | Integer |
| Description | Returns the number of success records from a Salesforce upsert, insert, update, or delete operation. For example, this variable may be used within a script to record the number of records successfully upserted, inserted, updated, or deleted within the operation log: <trans> WriteToOperationLog(There were $jitterbit.sfdc.success_record_count records successfully processed.) </trans> |
Settings
jitterbit.sfdc.auto_fieldsToNull
| Variable | jitterbit.sfdc.auto_fieldsToNull |
|---|---|
Data Type | Boolean |
| Default | true |
| Description | If set to true, fieldsToNull elements for Salesforce web service calls will be automatically inserted when NULL or an empty string is mapped to a field. The default is true for backwards compatibility with previous versions where this was a manual process. This flag should be set to true if you plan to map null or empty fields and expect those to be set to null in Salesforce. |
jitterbit.sfdc.dbsource.sfheader
| Variable | jitterbit.sfdc.dbsource.sfheader |
|---|---|
Data Type | Boolean |
| Default | false |
| Description | Applies to Salesforce update and Salesforce upsert operations. If set to true, allows you to capture the header string from a database source and write the string at the beginning of success and/or failure files. For more information, see Salesforce. |
Overview
Content Tools
Last updated:
Oct 14, 2021
