Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?