RAW SQL Step Throwing Error?
in Flows
Greetings,
I'm using a RAW SQL step to fetch accounts based upon certain criteria. However, when I began testing, I was running into an error as soon as I add any sort of "WHERE" clause. The error is something like "Error message: Invalid column name". I'm trying to connect to an SQL DB. Am I doing something wrong? Here's what test query looks like:
Comments
-
Hello!
That error message is most likely indicative of a syntax error. You'll want to be sure you use single quotes around variables (even those passed-in from the flow) when making a SQL query. Your query should run if you were to type this:
SELECT * FROM entity_account
WHERE account_id = 'your variable'
Hope this helps!
-Gregory
