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,