I recently got the KNIME Salesforce Integration and am wondering if its possible to connect directly to custom reports that have been made in Salesforce? If so, how would I go about doing this? Can I do in within the Salesforce SOQL tool?
According to the Salesforce forum, you cannot use SOQL to query custom reports.
The easiest way to do it is via API. You would need to extract the connection information using the Salesforce Authentication extractor. With this information, you can then make authenticated API call for salesforce within KNIME.
You might find useful this link with Salesforce documentation of endpoints related to reports. There you can see which endpoints you can access and what kind of information they output.
Let me know if this helps.
This would be extremely useful to have out-of-the-box. I can use the API, but I cant use Workbench to find the name of the report I need, due to “security reasons”.