Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ken_T
Specialist
Specialist

REST Connection - List of Columns

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?

0 Replies