Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using the QLIK Rest API connector to retrieve "Space" information. It does not return my "Personal" space as a space. Is there a way to get it to return my personal space. I am trying to create a table of apps and another of spaces. Apps in my personal space have null fields for all space fields since my "Personal" space is not returned from the API.
What is the API endpoint that you are using?
Thank you !
/api/v1/spaces
LIB CONNECT TO 'REST_spaces';
RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"id",
"type",
"ownerId",
"tenantId",
"name",
"description",
"createdAt",
"createdBy",
"updatedAt",
"__KEY_data",
"__FK_data",
(SELECT
"__KEY_meta",
"__FK_meta",
(SELECT
"@Value",
"__FK_actions"
FROM "actions" FK "__FK_actions" ArrayValueAlias "@Value"),
(SELECT
"@Value" AS "@Value_u0",
"__FK_roles"
FROM "roles" FK "__FK_roles" ArrayValueAlias "@Value_u0"),
(SELECT
"@Value" AS "@Value_u1",
"__FK_assignableRoles"
FROM "assignableRoles" FK "__FK_assignableRoles" ArrayValueAlias "@Value_u1")
FROM "meta" PK "__KEY_meta" FK "__FK_meta"),
(SELECT
"__KEY_links",
"__FK_links",
(SELECT
"href",
"__FK_self"
FROM "self" FK "__FK_self"),
(SELECT
"href" AS "href_u0",
"__FK_assignments"
FROM "assignments" FK "__FK_assignments")
FROM "links" PK "__KEY_links" FK "__FK_links")
FROM "data" PK "__KEY_data" FK "__FK_data"),
(SELECT
"count",
"__FK_meta_u0"
FROM "meta" FK "__FK_meta_u0"),
(SELECT
"__KEY_links_u0",
"__FK_links_u0",
(SELECT
"href" AS "href_u1",
"__FK_self_u0"
FROM "self" FK "__FK_self_u0"),
(SELECT
"href" AS "href_u2",
"__FK_next"
FROM "next" FK "__FK_next")
FROM "links" PK "__KEY_links_u0" FK "__FK_links_u0")
FROM JSON (wrap on) "root" PK "__KEY_root";