Salesforce SOQL

Perform a Salesforce Object Query. The dialog uses the incoming authentication information to query the objects and fields of the data in Salesforce and allows the user to write a SOQL.

Options

Salesforce Objects
The objects as available in Salesforce. The list is queried when the dialog is opened.
Object fields
The fields defined for the selected object. Double-click the field to insert it into the SOQL Editor.
Flow Variables
Flow variables defined at the input. Double-click to insert a placeholder into the SOQL Editor.
SOQL
The Salesforce Object Query to be run during node execution.
Output Representation
Specifies how the result set is represented. As of now only JSON output is supported (which can be easily parsed using the JSON Path node). Raw JSON returns the result of the Salesforce API call as-is, whereby different rows in the output represent different 'chunks' of the data.
Records JSON will parse the records array from the result set and split it into different rows (potentially doing multiple requests to the Salesforce API to retrieve all data). For any query using count() this array will be empty so set the respective checkbox to only read out the totalLimit value.

Input Ports

Icon
Salesforce Authentication Object

Output Ports

Icon
Result set in a JSON column, to be further processed using one of the JSON processing nodes.

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.