Function to get app name using app id.

Aditya_Chitale — Wed, 04 May 2022 09:55:07 GMT

Hello,

Is there any way to get app name using respective app id ? I have used DocumentTitle() and DocumentName() but it returns only the app name/id in which the function is used.

I want to get external app name as I am trying to use it a mail subject for task failure alert.

Community link referred for alerting:

https://community.qlik.com/t5/Qlik-Sense-Documents/Email-Alert-for-Qlik-Sense-task-failed-Very-easy/ta-p/1724157

Regards,

Aditya

Re: Function to get app name using app id.

HugoRomeira_PT — Thu, 12 May 2022 11:03:31 GMT

Hi Aditya,

I propose you use the Qlik Connector :monitor_apps_REST_app to get the app ID and name, and than create a mapping table and apply the map.

See script bellow. Hope it helps:

LIB CONNECT TO 'monitor_apps_REST_app';

RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u4",
"createdDate" AS "createdDate_u0",
"modifiedDate" AS "modifiedDate_u0",
"modifiedByUserName" AS "modifiedByUserName_u0",
"name" AS "name_u3",
"publishTime",
"published",
"description",
"fileSize",
"lastReloadTime",
"availabilityStatus",
"__KEY_root",
(SELECT
"userId",
"userDirectory",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"name" AS "name_u2",
"__FK_stream"
FROM "stream" FK "__FK_stream")
FROM JSON (wrap on) "root" PK "__KEY_root";

MapApp:
Mapping LOAD
[id_u4] AS ObjectId,
[name_u3] AS [App Name QRS]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);

DROP TABLE RestConnectorMasterTable;

Best regards

Hugo Romeira

topic Re: Function to get app name using app id. in App Development

Function to get app name using app id.

Re: Function to get app name using app id.