REST Connection - List of Columns

Ken_T — Fri, 10 Dec 2021 19:39:46 GMT

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?

topic REST Connection - List of Columns in App Development