Retrieving Data From Salesforce

Retrieving data from a synonym from Salesforce is a lot like using any other data source, but there are a few things you should be aware of. The synonyms created for Salesforce services are all hierarchies with INPUT and OUTPUT segments, where the INPUT segments are parameters you pass to the procedure and the OUTPUT segments are the answer set you get back. To retrieve data, you must ensure that the synonym selected is for an SFDC service that returns an answer set.

To retrieve data from Salesforce:

  1. Pass at least one input parameter to the procedure. To do this, use a WHERE condition on one of the FIELD columns in the INPUT segment. For example, you could restrict rows retrieved to active rows with a filter on INPUT.ISDELETED, as shown in the following image.

    WHERE Filter Calculator

    Note: Only equality relationships can be used and you can only specify one value for each input parameter.

  2. Select columns from the OUTPUT segment for your output, as shown in the following image.

    Column Selection

  3. In the Column Selection window, click the button to test the SQL statement, as shown in the following image.

    Test SQL Statement

  4. In the workspace, right-click the SQL object and select Add Target and then New.
  5. Add a new target in the Salesforce directory called accounts.
  6. Click the Run button and select Submit to run the flow, as shown in the following image.

    Run Flow

Setting the Batch Size: By default, Salesforce limits the number of rows returned at one time to 1000. This limit can be changed with a WHERE condition on the input field BATCHSIZE, as shown in the following image.

Batchsize example


WebFOCUS