Retrieve file with QVrestconnector from AFAS

curiousfellow — Fri, 26 Nov 2021 09:05:03 GMT

I want to display a file retrieved with AFAS fileconnector

The file connector works, but when I want to load the csv information I probably use the wrong syntax.

Script =

RestConnectorMasterTable:
SQL SELECT
"col_1"

FROM CSV (header off, delimiter ",", quote """") "CSV_source";

When running I get this message :

CSV is not valid: columns number of row 2 is different from previous rows (1 and 2).
row: "filedata": "JVBERi0xLjYNJeLjz9....."

I think the cause of the problem are the double quotemarks in "filedata"

The information I need is the string starting with "JVBE..... which is a Base64 string

I tried several options for delimiters and quote

sql preview

topic Retrieve file with QVrestconnector from AFAS in QlikView