I’m trying to figure out if I can loop through a list of Salesforce objects and get all fields available with the Salesforce Simple Query or Salesforce SOQL nodes (without manually setting up each object by hand). And hopefully without the use of a GET node.
According to Salesforce Dev documentation, you should be able to use FIELD(ALL) in the SOQL query, however this does not seem to be supported with the API version used in KNIME Salesforce Integration.
Then I was looking for a way to send a ‘describe’ query for each Salesforce object, to get a list of available fields (and then use it into a variable to customise the SOQL automatically). However I can’t find a way to do this via SOQL. Did I miss something?
Thanks in advance for any advice!