topic Re: Getting SQL error in recipe in Workato Pros Discussion Board

Getting SQL error in recipe

ajitkumar_a — Tue, 17 Jun 2025 20:18:33 GMT

Re: Getting SQL error in recipe

ajitkumar_a — Tue, 17 Jun 2025 20:20:24 GMT

Re: Getting SQL error in recipe

1dheeraj2 — Wed, 18 Jun 2025 01:57:42 GMT

comma after now

Re: Getting SQL error in recipe

1dheeraj2 — Wed, 18 Jun 2025 01:59:38 GMT

where clause date step 7 equals today date , check the this part

Re: Getting SQL error in recipe

Bhagya_pola — Wed, 18 Jun 2025 05:17:10 GMT

Hi @ajitkumar_a ,
The query is not syntactically correct
it should be like this
SELECT Customer Name,
SUM(Usage Amount) AS Total_usage_now,
SUM(Usage Cost) AS Total_usage_cost
FROM sheet1
GROUP BY Customer Name

and the main thing is write the SQL query in Text mode then it should be working fine.

Re: Getting SQL error in recipe

manojksurisetty — Mon, 30 Jun 2025 13:26:04 GMT

Try using Text mode when writing your code, or if you're using Formula mode, make sure to wrap any text values in single (') or double (") quotes and use the + operator to concatenate.

Example for Formula mode:
"Select " + <columnname datapill> + " from " + <tablename datapill>;

This ensures that static strings and datapills are combined correctly in the expression.