Salesforce Input

    You can also use the following transforms for various ways to modify your Salesforce database:

    • Salesforce Insert: Inserts records directly into your Salesforce database

    • : Updates records directly into your Salesforce database.

    • Salesforce Delete: Deletes records directly from your Salesforce database.

    Enter the following information in the transform name field:

    • Transform name: Specifies the unique name of the Salesforce Input transform on the canvas. You can customize the name or leave it as the default.

    Enter the connection information in the following transform options:

    In this panel, you can set the module to query from as well as the query conditions.

    OptionDescription

    Specify query

    Select this check box to manually execute a query based on your own SOQL statements.

    Module

    Select the module (table) from which you want to retrieve data.

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

    Query Condition

    Enter any query filters you want to apply. Variables are allowed. For example, ‘fieldname=myvalue AND fieldname2=myvalue2’.

    The content tab allows you to optionally include additional descriptive fields in the result set.

    Use these options to further refine the data returned from the queries specified in the Settings tab. For example, you may want to only query deleted records within a specified date range. The Advanced panel includes the following fields:

    OptionDescription

    Select which records you want to retrieve to further define your pool of data. You can select All, Updated, or Deleted.

    Query all records

    Select the check box to query all the records you are retrieving. Clear the check box to use the date fields (below) to define a range of records to query.

    Start date

    Specify the starting date for retrieving the records in the date range. The format is ‘yyyy-MM-dd HH:mm:ss’.

    End date

    Specify the end date for retrieving the records in the date range. The format is ‘yyyy-MM-dd HH:mm:ss’.

    This panel includes the following fields:

    OptionDescription

    Include URL in output? & URL fieldname

    Select this check box, then enter the URL used to retrieve the data.

    Include Module in output? & Module fieldname

    Select this check box, then enter the name of the module from which the data was retrieved.

    Include SQL in output? & SQL fieldname

    Select this check box, then enter the SQL used to generate the result set.

    Include timestamp in output? & Timestamp fieldname

    Select this check box, then enter the timestamp for when the record was retrieved.

    Include Rownum in output? & Rownum fieldname

    Select this check box, then enter the row number for each record retrieved.

    Include deletion date in output? & Deletion date fieldname

    Select this check box, then enter the deletion date for when the record was removed.

    Enter information for the remaining fields on the Content tab.

    OptionDescription

    Time out

    Specify the timeout interval in milliseconds before the transform times out.

    Use compression

    Select to compress (.gzip) the data when connecting between Hop and Salesforce.

    Limit

    Specify the maximum number of records to retrieve.

    When you set the limit to ‘0’, there is no limit on the number of records that can be retrieved.

    The following are the properties display in the Fields tab: