topic Re: Issues using GetFullPropertyTree for sheet object via JSON API in Integration, Extension & APIs

Issues using GetFullPropertyTree for sheet object via JSON API

johnmorgan — Sat, 16 Nov 2024 03:59:43 GMT

I am having some issues using GetFullPropertyTree through the JSON API. Does anyone have an example of getting this object for a sheet?

I am working on integrating my teams qlik sense applications into source control and our continuous integration pipeline. To start I am trying to write a python script that will download text versions of a given application. Right now I can authenticate, open an app, and pull the data load as a text file, the next step is to try to get the json representation of each sheet in the application. I am able to list and iterate the sheets by creating a session object in the app and calling GetLayout. From there I can GetObject on each of the sheets. However regardless of what I try I am unable to get anything other than method not found trying to call GetFullPropertyTree.

Any help would be appreciated.

Re: Issues using GetFullPropertyTree for sheet object via JSON API

iharsh220 — Fri, 29 Nov 2019 09:38:37 GMT

Hello,

if you need current sheet if for extension you can use

qlik.navigation.get current sheet id()

if you are using engine api then

step 1: go to Qlik Engine

step 2 : connect engine select your app

step 3: in DOC open GetObjects

step 4: pass this json

{
"handle": 1,
"method": "GetObjects",
"params": {
" qOptions": {
"qTypes": [
"sheet"
],
"qIncludeSessionObjects": false,
"qData": {}
}
}
}

step 4: you'll get list of sheet for that app you're selected..

Thanks regards

Harsh Gohil

Re: Issues using GetFullPropertyTree for sheet object via JSON API

johnmorgan — Mon, 02 Dec 2019 19:38:35 GMT

All of that is fine. Where I have an issue is when I call getFullPropertyType on the qId that comes back from the and handle from the getObject call.

Body of that call looks like:

{"handle": "GAvUq", "id": 9, "jsonrpc": "2.0", "method": "getFullPropertyTree", "params": [4], "py/object": "QlikObjects.RequestObject"}

My understanding is that this should return several sheet properties including a json version of the sheet.

That call is consistently failing with method not found.

Thanks!

Re: Issues using GetFullPropertyTree for sheet object via JSON API

iharsh220 — Tue, 03 Dec 2019 09:31:17 GMT

https://help.qlik.com/en-US/sense-developer/February2019/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/AppAPI/getFullPropertyTree-method.htm

check this url if it will help.

qlik.app.getFullPropertyTree(id) // pass your sheet object id here

i dont know this api is working or not but still try once 🙂

Re: Issues using GetFullPropertyTree for sheet object via JSON API

ErikWetterberg — Wed, 04 Dec 2019 09:14:40 GMT

This can be confusing..

In the JSON protocol methods start with a kapital letter, so GetFullPropertyTree. In the JavaScript wrapper its getFullPropertyTree.

Re: Issues using GetFullPropertyTree for sheet object via JSON API

johnmorgan — Tue, 03 Dec 2019 15:12:11 GMT

2 days of looking at this and I didn't realize that I had camel cased that method call even though I hadn't camel cased any of the others 🙂

This solved my issue. Thanks!