Icon

Extract Data from Salesforce

Use of the Salesforce Data Extracter NodeThe output of the Salesfroce Data Extracter Node is a JSON object presented as a string. Therefore, it is necessary to convert this stringinto a JSON object. Once converted, you can extract the required information regarding the schema used in your Salesforce instance.Finally, you need to ungroup the array results into individual attributes to view them in a tabular format.What you need to know is that I just use SOQL to extract speicific Attribute of the Contract Objec in Salesfirce such Name and Email, if youlet the input field of SOQL emtpy you will get all availabe attributes of that object Node 12Node 14Node 15Node 82Node 83 String to JSON Ungroup Table View SalesforceData Extracter JSON Path Use of the Salesforce Data Extracter NodeThe output of the Salesfroce Data Extracter Node is a JSON object presented as a string. Therefore, it is necessary to convert this stringinto a JSON object. Once converted, you can extract the required information regarding the schema used in your Salesforce instance.Finally, you need to ungroup the array results into individual attributes to view them in a tabular format.What you need to know is that I just use SOQL to extract speicific Attribute of the Contract Objec in Salesfirce such Name and Email, if youlet the input field of SOQL emtpy you will get all availabe attributes of that object Node 12Node 14Node 15Node 82Node 83 String to JSON Ungroup Table View SalesforceData Extracter JSON Path

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Mohamad-Naser.Alnake
Created at: 2024-08-05
On NodePit since: 2024-08-07
Last update: 2024-11-21
Created with KNIME version: v5.3.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!