The SalesForce Input step provides you with the ability to read data directly from SalesForce using the SalesForce Web Service. The following sections describe each of the available features for configuring the SalesForce Input step.
The settings tab is where you configure the SalesForce WebService URL, login credentials, module to query from and query conditions:
SalesForce Webservice URL
This is the URL to the SalesForce Webservice.
Username for authenticating to Salesforce (i.e. email@example.com)
Password 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.
Select the module you wish to retrieve data from. Note: This list will be populated upon successfully authenticating to Salesforce using the Test Connection button.
Enter any query filters you wish to apply. For example, 'fieldname=myvalue AND fieldname2=myvalue2...'
The content tab allows you to optionally include additional descriptive fields in the result set
Include URL in Output?
Enable to add a field to the output containing the URL used to retrieve the data.
Include Module in output?
Enable to add a field to the output containing the module from which the data was retrieved.
Include SQL in output?
Enable to add a field to the output containing the SQL used to generate the result set.
Include timestamp in output?
Enable to add a field to the output containing the timestamp for when the record was retrieved.
Include Rownum in output?
Enable to add a field to the output containing a row number for each record retrieved.
Configure the timeout interval in milliseconds before the step times out.
Configure the maximum number of records to retrieve. Note: Setting this to '0' means there will be no limit placed on the number of records that can be retrieved.
The fields tab displays the fields that will be read from the SalesForce object (Module chosen on the Settings tab). You will need to go to the Fields tab and press the "Get Fields" button to populate the fields returned before being able to preview the rows returned.