Good afternoon,
I am using the salesforce extension with the three nodes below but I find unconvenient for two reasons: 1. if I retrieve the report via rest API, it returns a JSON and when converted the table rows becomes column and it takes too much to load, 2. if I use the node Salesforce simple query I need to download all the different tables and rebuild the repor through multiple join.
Question, why not developing a node (in line with competitor Alteryx) that allows to select and download a specific report?
You can propose new ideas for the devs to review under the âFeedback & Ideasâ category. I think that would be a great suggestion for the devs to look over!
Although if you wanted to, you could probably use a GET request and ping the API directly to get the report you want specifically. There is more info on the API below:
Hi Thor,
actually I was able to develop the connector myself using pyhton.
I have followed the guidelines of Salesforce in order to extract report with pyhton, connecting to the Salesforce API. Even with no prior python experience, it was quite easy to develop the code.
Once done, than I have integrated it in Knime using the Python node.
Now it is possible and superfast for me to download any salesforce report already in table format.
In order to create the connector, you need to have SFDC 1.username,2.password and 3. token (necessary to connect to the API).
I have first encrypted the credentials (see attached sample to use, sample_code_credentials). You execute this in python only once or when you change your password.
Briefly, you execute attached script âsample_code_credentialsâ and an encrypted credential file is created.
Be sure to insert your credentials in the code: "
Final step is to insert the python script, inside the Knime node, to retrieve the report (see sample_code_salesforce_report).
Please be sure to indicate the directory in which you have saved the credentials file.
Insert your SFDC domain in the string (see in yellow below).
You can insert in the code multiple Salesforce report and choose then which one to retrieve (see yellow part).