0 ×

Salesforce SOQL

KNIME Salesforce Integration version 4.3.0.v202011241508 by KNIME AG, Zurich, Switzerland

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.

Best Friends (Incoming)

Best Friends (Outgoing)

Installation

To use this node in KNIME, install KNIME Salesforce Integration from the following update site:

KNIME 4.3

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

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.