SalesforceQuery Activity

This activity executes the specified SOQL SELECT statement. It executes a query against the specified object for the specified connection and returns the data that matches the specified criteria in the query.

Settings

On the Settings tab, provide the following information to identify which Salesforce.com connection to use and the type of object to query.

Field Description
Connection Name Salesforce.com connection name. If you have created multiple Salesforce.com connections, select the one you want to use for this flow.
Object Name Salesforce.com business object name. Select the object you want this activity to use for this activity from the list for this field.

Input

Note: Entering or mapping a value for the ID field on this tab is mandatory. For more information, see Salesforce documentation.
Enter the Salesforce.com query, you want to send to Salesforce using SOQL (Salesforce Object Query Language). You have the option to either enter the input manually or map the input to the output from a preceding activity provided that the preceding activity has an output. The input tree displayed for this activity depends on the object that you selected on the Settings tab.

Output

The schema for the output of this activity is displayed in a tree format on this tab. The schema varies according to the object that you selected on the Settings tab. The elements that you see in the schema can be mapped as input to the activities that follow this activity in the flow.

Loop

If you would like this activity to iterate multiple times within the flow, enter an expression that evaluates the iteration details. Select a type of iteration from the Type menu. The default type is None, which means the activity does not iterate. Refer to the "Using the Loop Feature in an Activity" topic in TIBCO Flogo® Enterprise User Guide.TIBCO Cloud™ Integration documentation.