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?
