Edit on GitHub
Error: Unexpected Character / Unexpected Separatorlink
Issuelink
A sync is failing with one of the following error messages:
Error Unexpected character ('X' (code 72)): Expected separator ('""' (code 34)) or end-of-line at line: ?, column: ?.
{
...
""data"":{
""status"":""FAILURE\_WITH\_TASK"",
""reason"":""com.fasterxml.jackson.dataformat.csv.CsvMappingException: Too many entries: expected at most 1 (value \#1 (? chars) \\""???\\"")\\n at \[Source: (BufferedReader); line: ?, column: ???\]"",
""taskType"":""poorly\_formatted\_file""
},
...
}
Environmentlink
File connectors
Resolutionlink
To fix the error, follow the steps below:
- Verify in the source document that double quotes are correctly escaped as specified in the RFC 4180 standard.
- In the connector's Setup tab, click Edit connection details.
- Set the Enable Advanced Options toggle to ON.
- Specify a Delimiter in the connector settings.
- (If needed) Specify an Escape Character.
Causelink
The file appears correctly formatted and is ingested or parsed correctly by other tools or software. Different tools use different rules and libraries to parse CSV. The tool used at Fivetran ingests CSV files that follow the RFC 4180 standard.
A common error, in this case, is having double quotes inside a field that also contains other characters, such as a JSON string.