topic Re: Get the SheetID by name in App Development

Get the SheetID by name

bean — Thu, 28 May 2026 12:06:42 GMT

Hi there,

We want to hyperlink to another sheet. Since SheetIDs change from app instance to instance, I'm looking for a function to retrieve a particular sheet's ID in an expression or during load (and put result in a variable).

The URL to an sheet looks like

https://<Server name>/sense/app/<App ID>/sheet/<Sheet ID>/state/analysis

and using an expression I can resolve most parts dynamically. But not yet the sheet ID being here YMSKeu

='https://' & GetSysAttr('tenantUrlAlias') & '/sense/app/' & DocumentName() & '/sheet/YMSKeu/state/analysis'

Any idea how to find the right sheet ID e.g. from it's name? ObjectId() or GetActiveSheetId() do not help since I'm looking for another sheet than the function is running in.

Thanx so much

Re: Get the SheetID by name

Or — Thu, 28 May 2026 13:52:49 GMT

You should be able to use the Qlik API to get the list of sheets from the app:

GET https://<YourServer>/qrs/app/object?filter=app.id eq <AppID> and objectType eq 'sheet'

see e.g. https://community.qlik.com/t5/Integration-Extension-APIs/QlikSense-RestAPI-Get-Sheet-Info-for-App/td-p/1702886

DocumentName() will get you the ID of the current app to pass along to the API, though note that using this in script will use the ID of the app where it was last reloaded so it is important that the reload happens on the published app rather than a manual reload in someone's work and then publish.

Re: Get the SheetID by name

Chanty4u — Sat, 30 May 2026 17:34:15 GMT

May be try this

GetActiveSheetId()

ObjectId()

SheetTitle()

Re: Get the SheetID by name

bean — Mon, 01 Jun 2026 10:40:42 GMT

Thanks for the idea using the API.
From GET https://<YourServer>/api/v1/apps/{appID} I get meaningful results, so my API key seems be working.
But using /qrs/about or other basic qrs calls there are no responses. I'm setting the parameter Xrfkey and header x-Qlik-Xrfkey.
I fear that this works only for Sense Windows and not for the Qlik Sense Cloud ..

Re: Get the SheetID by name

Or — Mon, 01 Jun 2026 11:10:29 GMT

I had assumed you are using Enterprise, since your link structure included <Server name>, but looking at it again I see your second link had tenant ID. Are you using a mixed environment with both Cloud and Client-managed? They do tend to have different offerings in this regard, so you may need to script through testing which one you're on first and then use the relevant API.

For cloud, have a look at this for the API you presumably need. It's fairly straightforward, luckily:

https://qlik.dev/toolkits/qlik-api/examples/app-sheet-list/

Re: Get the SheetID by name

bean — Mon, 01 Jun 2026 15:12:23 GMT

I'm completely in the cloud, no enterprise setup.

With node.js I'm completely lost - finally I need the information about the sheet's ID in the load script. Using node.js from outside Qlik is clear and that works. But how to access the API (which one?) from a load script remains open.