Function to get app name using app id.

[Aditya_Chitale]

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/...

Regards,

Aditya

[HugoRomeira_PT · Accepted solution]

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