Use Qlikview REST API to fetch Nprinting user filters

nsm1234567 — Fri, 10 Aug 2018 14:03:52 GMT

Hi there,

I'm working on a Qlikview app whose purpose is to extract a list of Users, Filters and Groups from Nprinting. I had no problem fetching the user list, but I've run into issues when fetching the filters.

I had hoped that I could fetch the user filters using something like the below and then looping through the users:

RestUserMasterTable:

SQL SELECT

(SELECT

"guid"

FROM "items" FK "__FK_items")

FROM JSON (wrap off) "data" PK "__KEY_data"

WITH CONNECTION( URL "$(vServerURL)/api/v1/users/$(vCurrentUser)/filters", HTTPHEADER "cookie" "$(vCookie)" );

However, it appears as though the JSON returned by this request looks like the below, and I can't figure out how to access the guid that's returned using the Qlikview REST API. Does anyone have any experience fetching JSON that's returned like this?

{

"data": {

"items": [

"001af4af-19f8-453b-bee1-88a4202bcc53"

"totalItems": 1,

"offset": 0,

"limit": 2147483647

}

Re: Use Qlikview REST API to fetch Nprinting user filters

pillanicola — Tue, 05 Mar 2019 14:42:11 GMT

Hi,

have you solved?

topic Re: Use Qlikview REST API to fetch Nprinting user filters in QlikView

Use Qlikview REST API to fetch Nprinting user filters

Re: Use Qlikview REST API to fetch Nprinting user filters