Hi, I’m trying to do a SOQL Salesforce Step and keeps returning this error
SyntaxErrorUnexpected token : in JSON at position 71
Without the WHERE clause it works fine. I also don’t have the full salesforce response that could be usefull.
SELECT PersonAssistantName FROM account WHERE Phone = ‘6666’ OR PersonOtherPhone = ‘666666’ LIMIT 1
Now I used the like conditional and works fine.
SELECT PersonAssistantName FROM account WHERE Phone like ‘6666’
No worries
Thanks for the update, @producto . Glad that worked! I believe the syntax error has to do with how we’re formatting the query string when encoding your query. We’re planning to improve a number of actions work in the near future, and Salesforce actions should be on that list, so we’ll see how we can make the error more clear moving forward.
