Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
}
}
Hi,
have you solved?