https://community.qlik.com/t5/Connectivity-Data-Prep/Using-NPrinting-API-in-QlikSense-GET-Filters/m-p/1777202#M5721 <P>I am trying to get the table with all my current filters and their values.&nbsp;</P><P>&nbsp;</P><P>I have already gotten to the point of pulling all my users, and their corresponding filter selections, but getting the&nbsp;<STRONG>values</STRONG>&nbsp;of those filters is eluding me.&nbsp;</P><P>&nbsp;</P><P>Does anyone have a sample script for pulling the nested fields / values tables from the filters data?</P><LI-CODE lang="markup">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;</LI-CODE> Mon, 25 Jan 2021 15:57:28 GMT tm_burgers 2021-01-25T15:57:28Z https://community.qlik.com/t5/Connectivity-Data-Prep/Using-NPrinting-API-in-QlikSense-GET-Filters/m-p/1777202#M5721 <P>I am trying to get the table with all my current filters and their values.&nbsp;</P><P>&nbsp;</P><P>I have already gotten to the point of pulling all my users, and their corresponding filter selections, but getting the&nbsp;<STRONG>values</STRONG>&nbsp;of those filters is eluding me.&nbsp;</P><P>&nbsp;</P><P>Does anyone have a sample script for pulling the nested fields / values tables from the filters data?</P><LI-CODE lang="markup">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;</LI-CODE> Mon, 25 Jan 2021 15:57:28 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Using-NPrinting-API-in-QlikSense-GET-Filters/m-p/1777202#M5721 tm_burgers 2021-01-25T15:57:28Z