topic Re: Qlik Sense Rest connector - csv not valid in App Development

Qlik Sense Rest connector - csv not valid

Zedsdead — Tue, 26 Oct 2021 09:19:49 GMT

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.

Re: Qlik Sense Rest connector - csv not valid

letqi — Thu, 03 Nov 2022 04:16:43 GMT

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?

Re: Qlik Sense Rest connector - csv not valid

SunilChauhan — Thu, 03 Nov 2022 06:43:15 GMT

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

Re: Qlik Sense Rest connector - csv not valid

Jord23Henk — Tue, 18 Apr 2023 14:56:19 GMT

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

Re: Qlik Sense Rest connector - csv not valid

this — Mon, 10 Jul 2023 08:43:25 GMT

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

Re: Qlik Sense Rest connector - csv not valid

Chirantha — Mon, 10 Jul 2023 09:07:44 GMT

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.

Re: Qlik Sense Rest connector - csv not valid

this — Tue, 11 Jul 2023 12:13:01 GMT

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