Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tm_burgers
Creator III
Creator III

Using NPrinting API in QlikSense - GET Filters

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;
0 Replies