Workato · SQL Collection by Workato

No such column error

Short answer

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

Workato error
No such column error

02Likely 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

  1. Open the Query lists step and find the column the error refers to.
  2. Replace the label name with the column's API name in the query.
  3. Make sure the SQL adheres to the SQLite version 3.42.0 standards.
  4. 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

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.