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

Icon
Salesforce Authentication Object

Output Ports

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

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.