topic Re: QlikSense RestAPI: Get Sheet Info for App in Integration, Extension & APIs

QlikSense RestAPI: Get Sheet Info for App

JustinDallas — Fri, 13 Aug 2021 18:39:00 GMT

Hello Folks,

Because my server throws a weird error 8 out of 10 times I call "location.GetAppIdentifiers()", I'd like to switch to using the REST APIs since those have never failed me.

Does anyone know how to retrieve the sheet information given an appId using rest? I'm looking to retrieve the Title, the Sheet Path/Id. I assume this would be found using Engine and not Repository endpoints, but I'm having trouble find a service that returns this data.

My server is Nov 2019 Patch 3 if that makes a difference.

Any help is greatly appreciated.

Re: QlikSense RestAPI: Get Sheet Info for App

Levi_Turner — Sun, 17 May 2020 18:04:24 GMT

My default would be to call GET /qrs/app/object/full?filter=(objectType = 'sheet') but I am receiving The comparison expression contains an unsupported operator: objectType = 'sheet' as a response. I'm pinging some folks about that response.

The following is working fine for me:

POST /qrs/App/Object/table?filter=((objectType eq 'sheet')) Body: { "entity": "App.Object", "columns": [ { "name": "id", "columnType": "Property", "definition": "id" }, { "name": "description", "columnType": "Property", "definition": "description" }, { "name": "name", "columnType": "Property", "definition": "name" }, { "name": "objectType", "columnType": "Property", "definition": "objectType" }, { "name": "owner", "columnType": "Property", "definition": "owner" }, { "name": "approved", "columnType": "Property", "definition": "approved" }, { "name": "published", "columnType": "Property", "definition": "published" }, { "name": "modifiedDate", "columnType": "Property", "definition": "modifiedDate" }, { "name": "app.name", "columnType": "Property", "definition": "app.name" }, { "name": "app.stream.name", "columnType": "Property", "definition": "app.stream.name" } ] }

Re: QlikSense RestAPI: Get Sheet Info for App

Øystein_Kolsrud — Mon, 18 May 2020 06:22:38 GMT

I think the problem in the first call is simply that you used '=' instead of 'eq' in the filter. This works for me:

GET /qrs/app/object/full?filter=(objectType eq 'sheet')

Re: QlikSense RestAPI: Get Sheet Info for App

Levi_Turner — Mon, 18 May 2020 10:53:23 GMT

Yep, @Øystein_Kolsrud . That's what I get for working on Sunday!