topic Re: get appsheetid from all tenants using API in Data Movement & Streaming

get appsheetid from all tenants using API

tmraman — Wed, 19 Mar 2025 21:46:28 GMT

Hi All,

i want to get sheetsid from qlik cloud tenant, I have four tenants 2 of the tenant works in getting sheetid two tenants is giving error as

The issue could be with the qix engine methods, the requests are being blocked by qlik servers therefore giving a nginx 401 page.

Error fetching app IDs: <html>
<head><title>401 Authorization Required</title></head>
<body>
<center><h1>401 Authorization Required</h1></center>
<hr><center>nginx</center>
</body>
</html>

undefined:1
<?xml version="1.0"?>
^

SyntaxError: Unexpected token < in JSON at position 0
    at JSON.parse (<anonymous>)
at RPC.onMessage (\node\getappsheets\node_modules\enigma.js\enigma.js:1471:25)
    at callListener (\node\getappsheets\node_modules\ws\lib\event-target.js:290:14)
    at WebSocket.onMessage (\node\getappsheets\node_modules\ws\lib\event-target.js:209:9)
    at WebSocket.emit (node:events:527:28)
    at Receiver.receiverOnMessage (\node\getappsheets\node_modules\ws\lib\websocket.js:1220:20)
    at Receiver.emit (node:events:527:28)
    at Receiver.dataMessage (\node\getappsheets\node_modules\ws\lib\receiver.js:596:14)
    at Receiver.getData (\node\getappsheets\node_modules\ws\lib\receiver.js:496:10)
    at Receiver.startLoop (\node\getappsheets\node_modules\ws\lib\receiver.js:167:16)

Re: get appsheetid from all tenants using API

marksouzacosta — Sun, 01 Dec 2024 03:49:30 GMT

Hi @tmraman,

I think a better place for your question will be at Integration, Extension & APIs:
https://community.qlik.com/t5/Integration-Extension-APIs/bd-p/qlik-sense-integration-extension-api

In any case, which Qlik Sense are you using (on-prem, Cloud) and what is the authentication method on all four tenants?

Regards,

Mark Costa

Re: get appsheetid from all tenants using API

tmraman — Wed, 04 Dec 2024 12:55:17 GMT

Hi Mark,

Thanks for your response, Actually my issue is resolved. the issue was with Qlikview apps which doesn't have sheetid throws error and after filtering the qv apps I am able to get sheetid from all the tenants

Regards,

Muthuraman