Salesforce Input
Description
Salesforce Input is a step in the Input Plugin for Process Studio Workflows. The SalesForce Input step reads data directly from SalesForce using the SalesForce Web Service. The following sections describe each of the available features for configuring the SalesForce Input step.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of this step in the workflow workspace. |
| 2 | SalesForce Webservice URL | Specify the URL to the SalesForce Webservice. **Note:**This URL is dependent on the API version you are using. |
| 3 | Username | Specify Username for authenticating to Salesforce (i.e. myname@automationedge.com) |
| 4 | Password | Specify Password for authenticating to Salesforce. Enter your password followed by your security token. If your password is 'PASSWORD' and your security token is 'TOKEN', enter 'PASSWORDTOKEN' in this field. |
| 5 | Module | 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. |
| 6 | Query Condition | Enter any query filters you wish to apply. For example, 'fieldname=myvalue AND fieldname2=myvalue2...' Note that you do NOT need to include WHERE in your condition statement and variables are supported for this field. |
| Content Tab | ||
| 1 | Include URL in Output? | Enable to add a field to the output containing the URL used to retrieve the data. |
| 2 | Include Module in output? | Enable to add a field to the output containing the module from which the data was retrieved. |
| 3 | Include SQL in output? | Enable to add a field to the output containing the SQL used to generate the result set. |
| 4 | Include timestamp in output? | Enable to add a field to the output containing the timestamp for when the record was retrieved. |
| 5 | Include Rownum in output? | Enable to add a field to the output containing a row number for each record retrieved. |
| 6 | Time out | Configure the timeout interval in milliseconds before the step times out. |
| 7 | Limit | 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. |
| Fields Tab: | ||
| 1 | Name | Specify the field name for Name. |
| 2 | Field | Specify the field name for field in the Salesforce table. |
| 3 | IsIdLookup? | Enable checkbox if it Is it a lookup Id column in Salesforce. |
| 4 | Type | Specify the field name for data type to convert to. |
| 5 | Format | Specify the field name for the format or conversion mask to use in the data type conversion. |
| 6 | Length | Specify the field name for the length of the output data type. |
| 7 | Precision | Specify the field name for the precision of the output data type. |
| 8 | Currency | Specify the field name for the currency symbol to use during data type conversion. |
| 9 | Decimal | Specify the field name for the numeric decimal symbol to use during data type conversion. |
| 10 | Group | Specify the field name for the numeric grouping symbol to use during data type conversion. |
| 11 | Trim type | Specify the field name for the type of trimming to use during data type conversion. |
| 12 | Repeat | Repeat the column value of the previous row if the column value is empty (null). |