Skip to main content

Salesforce:Query

Controlled node

Overview​

Retrieve Salesforce records with a SOQL query.

Run a SOQL query against the connected Salesforce organisation. Use it to select records and the fields your workflow needs.

Inputs​

InputTypeDescription
runEventTriggers this operation.
soqlTextRequired SOQL query. Use Salesforce object and field API names. This is SOQL, not general-purpose SQL.

Properties​

SettingTypeDescription
connectionConnectionSelect an authenticated Salesforce connection from this project. The connected account’s object and field permissions apply.

Outputs​

OutputTypeDescription
recordsDataQuery response object containing records, totalSize and done, and sometimes nextRecordsUrl. Failures contain error. The output itself is not the record array.
doneEventFires when the node returns, including when it returns an error result. Check the data output before continuing.

Result limits​

This node makes one query request and does not follow nextRecordsUrl. If the response’s done is false, more records exist than were returned. Narrow your query or split the work into smaller queries; the editor has no continuation input for this node.

The response’s Boolean done field is separate from the node’s done event. Select only the fields you need and use a suitable WHERE clause or LIMIT.

Example​

Select the connection and set soql to:

SELECT Id, Name, Industry FROM Account WHERE Industry = 'Technology' LIMIT 100

Trigger run. On done, inspect the response and use Get Value with path records to extract its array. Pass that array to For Each → object. Returned record field names retain their Salesforce casing, for example Id and Name.

Project connections