Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nsm1234567
Contributor

Use Qlikview REST API to fetch Nprinting user filters

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

  }

}

1 Reply
Partner
Partner

Re: Use Qlikview REST API to fetch Nprinting user filters

Hi,

have you solved?