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

Views

This node has no views

Workflows

• 00_xplan sf dbconv-insert via xport-AccountKNIME Hub
• 01_xplan sf dbconv-insert via csv-AddressKNIME Hub
• 01_xplan sf dbconv-insert via xport-AddressKNIME Hub
• 30_xplan sf dbconv_opex_service_historyKNIME Hub
• 31_xplan sf dbconv_opex_consent_tableKNIME Hub
• existing_records_w_docnotesKNIME Hub
• revenue_adviser_matchingKNIME Hub
• revenue_create_policy_recordsKNIME Hub
• soql_managerKNIME Hub
• soql_sql_connect_testKNIME Hub

Links

• No links available

Developers