0 ×

Salesforce Simple Query

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

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

Icon
Salesforce Authentication Object

Output Ports

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

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.