Solved: get appsheetid from all tenants using API - Qlik Community

tmraman · ‎2024-11-29

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)

tmraman · ‎2024-12-04

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

View solution in original post

marksouzacosta · ‎2024-11-30

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

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

tmraman · ‎2024-12-04

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

get appsheetid from all tenants using API

Cloud Applications Connectivity

New to Qlik Cloud Data Integration

Qlik Cloud Data Integration