Skip to content
  • Register

    • 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:

    image.png


    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

    Sign In or Register to comment.

    Howdy, Stranger!

    It looks like you're new here. If you want to get involved, click one of these buttons!

    Sign In Register

    Quick Links

    Categories