When using a REST connection, after it is created and tested and working -
the script looks a little like this:
LIB CONNECT TO 'MyRESTConnection';
RestConnectorMasterTable:
SQL SELECT
"Column 1",
"Column 2"
FROM CSV (header on, delimiter ";", quote """") "CSV_source"
;
[CSV_source]:
LOAD
[Column 1],
[Column 2]
RESIDENT RestConnectorMasterTable
;
DROP TABLE RestConnectorMasterTable;
In a regular Qlik load, * can be used in place of the list of specific column names.
In my REST connections, I am unable to find any syntax that allows * to be used.
Can * be used in the script for a REST connection?
if so, what is the syntax to get this to work?