Salesforce Query All
The Salesforce Query All activity performs the specified SOQL SELECT statement. It executes a query against the specified object and returns the data that matches the specified criteria.
In the General tab, you can establish a connection to the Salesforce.com server.
The following table lists the configurations in the General tab of the Salesforce Query All activity:
In the Description tab, you can enter a short description for the Salesforce Query All activity.
In the Input tab, you can specify input values for the Salesforce Query All activity.
The following table lists the input elements in the Input tab of the Salesforce Query All activity:
|Input Items||Data Type||Description|
|connectionInfo (All fields in this section are optional.)|
|serverUrl||String||The web address of the endpoint that is used by this operation.|
|sessionId||String||The unique ID associated with this session.|
|externalSessionIdUsed||Boolean||Specifies whether an external session ID is used (true) or not (false).
If the value is set to true, an external session ID is filled in the sessionId field.
In this case, when the session has to be refreshed, the refreshed operation cannot be performed, and an exception is thrown.
|query (All fields in this section are optional.)|
|batchSize||Integer||When processing large amounts of data, the activity internally invokes several SOAP calls. This field is used to set the batch size for the number of records returned through an SOAP call.
The value must be set between 200 and 2000. The default value is 500.
If the input value equals -1, it is set to the default value. If the input value is greater than 2000, it is set to 2000. If the input value is less than 200 (except -1), it is set to 200.
|queryMain||Each queryMain includes the following element:|
|fields||This field is visible when you define a prepared parameter on the General tab. You can pass the prepared parameters values under the parameters.|
|query_Optional (All fields in this section are optional.)|
|_configData||Each _configData includes the following element:|
headers includes the following elements:
SubsetSetting includes the following elements:
In the Output tab, you can find the output value.
The following table lists the output elements in the Output tab of the Salesforce Query All activity:
|Output Item||Data Type||Description|
|result||done||Boolean||Indicates whether additional rows are to be retrieved from the query results (false) using another query activity, or not (true). Your client application can use this value as a loop condition when iterating through the query results.|
|queryLocator||String||Used in subsequent query activities for retrieving sets of objects from the query results, if applicable.|
|records||Complex||An array of sObjects representing individual objects of the specified object and containing data defined in the
fieldlist specified in the
These sObjects can be converted to the specified type defined in the metadata schema, for example, the Salesforce_Metadata, retrieved from the Salesforce.com server.
|size||Integer||Total number of rows retrieved in the query. Your client application can use this value to determine whether the query retrieved any rows (size > 0) or not (size = 0).|
|lastSubset||Boolean||Indicates whether the current output is the last subset (true) or not (false).|
In the Fault tab, you can find the error code and error message of the Salesforce Query All activity. See TIBCO ActiveMatrix BusinessWorks Error Code for more information about error codes and corrective actions to take.
|SalesforceExecuteSOAPMethodException||An error occurred when calling an SOAP method.
For example, wrong values are set in the Input fields or the Salesforce session has timed out.
|SalesforceLoginException||An error occurred when logging in to the Salesforce.com server.|
|SalesforceConnectionNotFoundException||An error occurred when the external session ID is not used or the Salesforce connection is not configured correctly.|