Workato · Parsers

CSV parsing error

Short answer

The 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.

VerifiedLast verified

01Error text

Workato error
err.data_format.csv_parsing_error

02Likely causes

  • The CSV content has a malformed structure or an invalid delimiter.
  • The data contains prohibited strings or delimiters, such as commas inside CSV values.

03How to fix it

  1. Open the failed job and get the CSV content that was passed to the parser step.
  2. Validate the source data, and look for values that contain the delimiter.
  3. Correct the source so it avoids prohibited strings and delimiters, and confirm the step uses the delimiter the file really has.
  4. Use the error_type_id to target this failure in a Monitor actions for error block, so the recipe can handle it without parsing the error message.

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.