Skip to main content

Salesforce Insert

Description

SalesForce Insert is a step in the Output Plugin for Process Studio Workflows. The SalesForce Insert step inserts data directly into SalesForce using the SalesForce Web Service.

Configurations

No.Field NameDescription
Connection
1SalesForce Webservice URLThis is the URL to the SalesForce Webservice.

Note: This URL is dependent on the API version you are using.

2UsernameUsername for authenticating to Salesforce (i.e. myname@ automationedge.com).
3PasswordPassword for authenticating to Salesforce. Enter your password followed by your security token. If you password is 'PASSWORD' and your secuirty token is 'TOKEN', enter 'PASSWORDTOKEN' in this field.
Settings:
1Time outConfigure the timeout interval in milliseconds before the step times out.
2Use compressionEnable checkbox to use compression.
3Rollback all changes onEnable this checkbox to ensure complete success or to rollback all changes.
4Batch sizeThis is the number of rows to commit as a batch.
5ModuleSelect the module you wish to delete data from.

Note: This list will be populated upon successfully authenticating to Salesforce using the Test Connection button.

Output Fields:
1Salesforce id fieldnameThis is the ID of the fieldname inserted.
Fields:
1Dynamic Fields as JSON formatEnable checkbox to accept field names as JSON input. In the JSON text you can have dynamic fields to insert rather than static fields as provided in the table provided.
2JSONAbout JSON text:

If ‘Accept Fields as JSON’ checkbox is enabled this field is activated. Choose a field containing the JSON text. JSON text should contain key-value pairs enclosed by double quotes (“) enclosure. Provide all the required or mandatory fields as well as other fields to be inserted as keys in the JSON.

Note: The JSON could be from any input step such as Generate rows, Text File input, Excel Input Et al. JSON text can only be accepted from input fields from previous steps and not as files directly. JSON text can also be specified by a parameter already defined.

Sample JSON key value pairs:

[ { "displayName": "Service", "value": "HR Service Desk" }, { "displayName": "Title", "value": "Test_KA10" } ]
Table:Tabular selection of fields to be inserted.
1Module fieldModule field in Salesforce.
2Stream fieldField from stream.
3Use External id?(Y/N).