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