Salesforce Simple Query

Read fields from a Salesforce object. In the configuration dialog select the object type (i.e. a table in Salesforce such Account) and the corresponding object fields (columns, such as Account Name); the data is returned in a KNIME table at the output. An optional WHERE and LIMIT statement can be specified to narrow the search result.

Options

Names based on

Determines whether the column names in the output table are derived from the Salesforce field names or labels. Labels are human readable and also used in the Salesforce user interface, e.g. AI Record Insight ID. Field names are names used in the API, e.g. AiRecordInsightId. Most standard fields use the same name as the label. Custom fields will have the '_ _c' suffix. The option also controls how fields and objects are displayed in the configuration dialog.

Salesforce Object

The objects as available in Salesforce. The list is queried when the dialog is opened. The list only contains objects, which are queryable (a property set in Salesforce).

Selected Fields

The fields defined for the selected object. Move the fields that should be retrieved into the 'Include' list. The field's type is mapped to a native KNIME type (string, int, double, boolean, date & time, ...), whereby some types may not be supported (for instance Salesforce's anyType). Fields with such unsupported type are hidden in the configuration dialog.

WHERE clause

An optional WHERE clause to filter the result set. Examples are

Name LIKE 'A%' 
CreatedDate > 2011-04-26T10:00:00-08:00
CALENDAR_YEAR(CreatedDate) = 2011

(find some examples in the Salesforce online documentation).

LIMIT result set

An optional integer to constraint the result set to a maximum number as specified.

Input Ports

: Salesforce Authentication Object

Output Ports

: A table containing the selected fields. Column names are derived from the field labels.

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.4

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

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.4.0.v202411201423

On NodePit since: 2024-12-06

Last update: 2024-12-17

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!