I am trying to get the table with all my current filters and their values.
I have already gotten to the point of pulling all my users, and their corresponding filter selections, but getting the values of those filters is eluding me.
Does anyone have a sample script for pulling the nested fields / values tables from the filters data?
RestConnectionMasterTable:
SQL SELECT
"__KEY_data",
(SELECT
"id" ,
"name",
"description",
"enabled",
"appId",
"connectionId"
FROM "items" FK "__FK_items")
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "https://qlik-nprint.mycompany.cloud:4993/api/v1/filters", HTTPHEADER "cookie" "$(vCookie)",QUERY "Limit" "10000") );
NPrint_Filters:
NoConcatenate LOAD
*
RESIDENT RestConnectionMasterTable;
drop table RestConnectionMasterTable;