topic Re: Json commands from engine api explorer does not return list of sheets in Integration, Extension & APIs

Json commands from engine api explorer does not return list of sheets

bekahbeets — Sat, 30 Sep 2017 00:49:53 GMT

So I can connect to the qlik server via javascript fine.. i get the engine and select an app via the code generated by the engine api explorer fine. When i get the code from the engine api explorer to list the sheets and pop it into the javascript, I get a list of the apps, not the sheets...

this:

[

{

"name": "SHEETLIST",

"method": "CreateSessionObject",

"handle": "${dochandle}",

"params": [

{

"qInfo": {

"qType": "SheetList"

"qAppObjectListDef": {

"qType": "sheet",

"qData": {

"title": "/qMetaDef/title",

"description": "/qMetaDef/description",

"thumbnail": "/thumbnail",

"cells": "/cells",

"rank": "/rank",

"columns": "/columns",

"rows": "/rows"

}

]

{

"method": "GetLayout",

"handle": "${SHEETLIST.result.qReturn.qHandle}",

"params": []

}

]

Does not give a list of sheets - it gives the list of apps/docs. In the Engine API explorer it does, but not in javascript.

Re: Json commands from engine api explorer does not return list of sheets

Aiham_Azmeh — Sat, 30 Sep 2017 07:29:00 GMT

Hi bekahbeets2003‌,

I am not entirely sure I understand your issue. Creating a sessionObject like with the Engine API explorer's macro, after `getLayout` should result in an object similar to this below example:

{

"jsonrpc": "2.0",

"id": 4,

"result": {

"qLayout": {

"qInfo": {

"qId": "317c3d47-7b0e-47ab-8cdb-2a247c7d4e2e",

"qType": "SheetList"

"qSelectionInfo": {},

"qAppObjectList": {

"qItems": [{

"qInfo": {

"qId": "kHgmg",

"qType": "sheet"

"qMeta": {...}

"qAppObjectList" will contain a "qItems" array with "sheet" objects ("qType": "sheet")

Can you share you JS snippet? Are you getting the layout of the app instead of the newly created sessionObject?

Re: Json commands from engine api explorer does not return list of sheets

bekahbeets — Mon, 02 Oct 2017 17:54:58 GMT

In the engine api explorer, it returns that, but when i put the request code (generated in engine api explorer List Sheets macro) into javascript on my aspx page, it gives the docs/apps, not the sheet list.

Re: Json commands from engine api explorer does not return list of sheets

Aiham_Azmeh — Tue, 03 Oct 2017 06:01:00 GMT

Alright, then my guess will be about right,

Tthe first call have "handle": "${dochandle}" while the second should be "handle": ${SHEETLIST.result.qReturn.qHandle}"

1- createSessionObject -- use the Doc handle

2- getLayout -- use the returned sessionObject handle (you are probably getting the app layout instead of the newly sessionObject layout)

I hope this helps

Re: Json commands from engine api explorer does not return list of sheets

bekahbeets — Tue, 03 Oct 2017 15:08:44 GMT

I'm a bit confused because in the code i listed above, the createSessionObject uses the dochandle and the getlayout uses the qhandle like you just said it should and it does not return sheets.

Re: Json commands from engine api explorer does not return list of sheets

Aiham_Azmeh — Tue, 03 Oct 2017 15:50:42 GMT

From the printscreen, you can see that the "createSessionObject" call uses qHandle 1, the returned GenericObject has qHandle 2 => the one you should use when calling getLayout

Re: Json commands from engine api explorer does not return list of sheets

bekahbeets — Tue, 03 Oct 2017 16:18:35 GMT

Does. Not. Work. And you're supposed to embed the request code that is on the top right in the engine explorer. The bottom is what is auto generated.

Re: Json commands from engine api explorer does not return list of sheets

Aiham_Azmeh — Wed, 04 Oct 2017 05:47:41 GMT

Maybe sharing your javascript codesnippet will help me trying to help you

Re: Json commands from engine api explorer does not return list of sheets

bekahbeets — Wed, 04 Oct 2017 09:58:36 GMT

My javascript is exactly what is above. i didn't change it. i copied and pasted. its just a bug in qlik when you send the json over.

Re: Json commands from engine api explorer does not return list of sheets

Aiham_Azmeh — Thu, 05 Oct 2017 06:04:37 GMT

The json struct is an array of 2 calls to the engine that should be translated in javascript to something like this:

app.createSessionObject(/*here the code is using qHandle 1*/).then(function(responseFromEngine){
     var handle = responseFromEngine.qHandle;
     app.getSessionObjectLayout(/*code should use the handle from the engine response*/).then(function(sheetList){
          console.log(sheetList)
     })
})

In Engine API explorer we are magically modifying the code so it replaces ${SHEETLIST.result.qReturn.qHandle} with the handle from the first engine call. My guess is that your code is reusing the same handle for the app, so in conclusion you are making a GetLayout on the App and not on the newly created SessionObject.

I really hope this helps,

Re: Json commands from engine api explorer does not return list of sheets

bekahbeets — Thu, 05 Oct 2017 14:32:15 GMT

what is the code to make 'app'?

note: i am using straight javascript, not node or angular.