Workato · SQL Collection by Workato
No such column error
No such column error in the Query lists action of SQL Collection by Workato means the query names a column that the list does not have. Use the column's API name in the query, not its label name.
VerifiedLast verified
01Error text
No such column error02Likely causes
- The query uses a column's label name where the API name is required.
- SQL Collection by Workato uses SQLite, so the query must follow SQLite syntax.
03How to fix it
- Open the Query lists step and find the column the error refers to.
- Replace the label name with the column's API name in the query.
- Make sure the SQL adheres to the SQLite version 3.42.0 standards.
- Test the recipe again.
iNotes
The same documentation page lists Incomplete output for the Query lists action. Its fix is to update and sequence the output list schema correctly.
04Official documentation
→Related errors
- UndefinedColumn - Column does not existUndefinedColumn - Column does not exist means the database cannot find a column named in the step's SQL. It often happens after a column in the underlying table was renamed, so check the names and refresh the recipe's schema.
- CSV parsing errorThe Workato error type err.data_format.csv_parsing_error means CSV content could not be parsed because of a malformed structure or an invalid delimiter. Check the file for stray delimiters, such as commas inside values, and correct the source.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer