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
| Input | Type | Description |
|---|---|---|
| run | Event | Triggers this operation. |
| soql | Text | Required SOQL query. Use Salesforce object and field API names. This is SOQL, not general-purpose SQL. |
Properties
| Setting | Type | Description |
|---|---|---|
| connection | Connection | Select an authenticated Salesforce connection from this project. The connected account’s object and field permissions apply. |
Outputs
| Output | Type | Description |
|---|---|---|
| records | Data | Query response object containing records, totalSize and done, and sometimes nextRecordsUrl. Failures contain error. The output itself is not the record array. |
| done | Event | Fires 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.