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
err.data_format.csv_parsing_error02Likely 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
- Open the failed job and get the CSV content that was passed to the parser step.
- Validate the source data, and look for values that contain the delimiter.
- Correct the source so it avoids prohibited strings and delimiters, and confirm the step uses the delimiter the file really has.
- Use the
error_type_idto target this failure in a Monitor actions for error block, so the recipe can handle it without parsing the error message.
04Official documentation
→Related errors
- JSON parsing errorThe Workato error type err.data_format.json_parsing_error means a JSON payload could not be parsed because of an invalid format or an unescaped character. Validate the source data and fix the document before it reaches the parser step.
- XML parsing errorThe Workato error type err.data_format.xml_parsing_error means an XML payload could not be parsed because of an invalid tag or a schema mismatch. Escape special characters in the XML and make sure the document matches the sample the step was set up with.
- No such column errorNo 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.
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