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.
Also retrieve deleted and archived records: When selected, the node will use Salesforce's queryAll endpoint to include deleted and archived records in the results.

Input Ports

: Salesforce Authentication Object

Output Ports

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

Views

This node has no views

Workflows

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.

Installation

To use this node in KNIME, install the extension KNIME Salesforce Integration from the below update site following our NodePit Product and Node Installation Guide:

v5.9

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.9.0.v202511130856

On NodePit since: 2025-12-11

Last update: 2026-01-19

KNIME versions: Since v4.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!