Salesforce Connector Load Script Where

macalmon — Tue, 28 Dec 2021 20:31:37 GMT

Hello, I am trying to use SFDC connector to load records from an object. I connect fine, but I am trying to filter by a field. LOAD and SELECT work fine and data loads, however when I try to use the WHERE to filter it does not register as a correct syntax.

If I attempt to do the same concept but the data comes from a spreadsheet, the WHERE registers.

Do anyone have any ideas?

Thank you,

Re: Salesforce Connector Load Script Where

gavinlaird — Sat, 30 Nov 2019 00:01:39 GMT

WHERE does work with the SFDC connector, but only for non-formula Salesforce fields. Could you please check to see if the field you are trying to filter on is a formula field?

topic Re: Salesforce Connector Load Script Where in Connectivity & Data Prep

Salesforce Connector Load Script Where

Re: Salesforce Connector Load Script Where