Qlik Sense Rest connector - csv not valid

[Zedsdead]

Hi,

Error while loading from csv via a rest connector (confluence):

"CSV is not valid: columns number of row 26 is different from previous rows (1 and 2). row: var contextPath = '';"

Can't attach a csv, so uploaded a similar xls here.

Can't get what's happening here, need help.

[letqi]

hi i am also facing the same exact error: CSV is not valid: column number of row 335874 is different from previous rows (15 and 1) row

Do you have any idea or manage to solve this error?

[SunilChauhan]

what is need of loading csv using rest connector , is it on sharepoint 

if it is on local, you Can load Directly using folder option

[Jord23Henk]

is it solved? you have any idea what to do in this case?

[this]

In our case, the Preview works but the loading the script throws the invalid csv error.

[Chirantha · Accepted solution]

Hey,

The error message you provided suggests that the CSV file is not valid because the number of columns in row 26 is different from the number of columns in the previous rows.

Please see if the following can help resolve this issue:
 

• Check the CSV file to make sure that it is formatted correctly. Each row should have the same number of columns, separated by a consistent delimiter (e.g., comma, semicolon, etc.). Make sure that there are no extra or missing delimiters in any of the rows.
• If the CSV file is being generated by an external system or application, make sure that it is configured to generate valid CSV files with consistent column counts and delimiters.
• If you’re using a custom script to parse the CSV data in Qlik Sense, make sure that it is correctly handling rows with different column counts. You may need to add additional logic to handle these cases.

[this · Accepted solution]

Hi Chirantha

Many thanks for your suggestions. We discovered that the repsonse of the call was a .txt file.
After altering the call the error message was gone.

The highlighted call doesn't throw an error.

Many thanks again, really appreciate the support here.

Matthias