monitor_apps_REST_app

jpjust — Tue, 01 Feb 2022 21:00:01 GMT

ALL,

I have an script like below from one of the monitoring app.

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"),
(SELECT
"id" AS "id_u7",
"@Value" AS "@Value_u0",
"name" AS "name_tag",
"__FK_tags"
FROM "tags" FK "__FK_tags" ArrayValueAlias "@Value_u0")
FROM JSON (wrap on) "root" PK "__KEY_root";

I am looking for create a table that has the appname and the tag associated to the app

App name from the above script is name_u3 and tag name would be name_tag

The issue is if I pull the name_u3 and name_tag, I don't see tag associated to app, though I have most of the app's has tags.

Should I do an resident on the RestConnectorMasterTable and write script?

Can some one please advice?

Thanks

topic monitor_apps_REST_app in App Development

monitor_apps_REST_app