Salesforce query SOQL

This activity performs an operation based on the SOQL provided, which is a SQL-like language.

Table 1. Salesforce query SOQL action - Inputs
Parameters Description

Connection

A Salesforce connection.

SOQL

A query field.

For example, SELECT Id, Name, ProductCode, Family, and IsActive FROM Product2.

Refer to the Salesforce documentation for more details on the format of an SOQL query.

Table 2. Salesforce query SOQL action - Outputs
Parameters Description

Body

Returns a JSON response being returned by the execution of the operation.

StatusCode

Return the HTTP code based on the result. For example, 200 indicates success.

Success

Indicates whether the activity was completed successfully (value = True) or not (value = False).

Records

Array of retrieved records.