topic Re: Get Stream Custom Property values from REST Connection in Management & Governance

Get Stream Custom Property values from REST Connection

ldrummond — Wed, 29 Jan 2025 16:21:29 GMT

Has anyone been able to retrieve all Streams and the associated Custom Property(ies) for those streams? I'm using this connection "monitor_apps_REST_app" but am only seeing the Custom Property data associated with an app.

I'm also able to get the Custom Property data for each User, with the user connection but iust not seeing where it's located for the Streams.

I need this to create a custom app for security review purposes.

Re: Get Stream Custom Property values from REST Connection

JandreKillianRIC — Tue, 04 Feb 2025 13:52:58 GMT

Hi @ldrummond

I don't see that this is actually exposed. However, If you go to the tenant /Qmc/Streams you can add the custom properties here and see "the list" of streams.

There is a Google Chrome extension that I mentioned in a YouTube video (Check it out if you want to)

https://youtu.be/IH6Ewx_JycA?si=vJ4R60Mpsxf4ju9L

The extension is Called Export Qlik Sense QMC tables as CSV that enables you to download the tables from QMC.

Regards Jandre

Re: Get Stream Custom Property values from REST Connection

AkashPohare_HB — Mon, 10 Mar 2025 15:00:12 GMT

Hello @ldrummond ,

By default there is rest connection called "monitor_apps_REST_stream" in the Qlik Sense. You can use it to fetch stream and its custom properties. If connection is not there, you can create a new rest connection to the QRS endpoint for streams.

URL: https://CentralNodeFQDN/qrs/stream/full

"value" column holds the values of the custom properties tagged at the stream level.

LIB CONNECT TO 'monitor_apps_REST_stream'; RestConnectorMasterTable: SQL SELECT "id" AS "id_u3", "createdDate" AS "createdDate_u0", "modifiedDate" AS "modifiedDate_u0", "modifiedByUserName" AS "modifiedByUserName_u0", "name" AS "name_u2", "privileges" AS "privileges_u2", "schemaPath" AS "schemaPath_u0", "__KEY_root", (SELECT "id" AS "id_u0", "createdDate", "modifiedDate", "modifiedByUserName", "value", "schemaPath", "__KEY_customProperties", "__FK_customProperties" FROM "customProperties" PK "__KEY_customProperties" FK "__FK_customProperties") FROM JSON (wrap on) "root" PK "__KEY_root"; [Streams-ADgroup-Mapping Temp]: LOAD UPPER([name_u2]) AS [StreamName], [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__KEY_root]); LEFT JOIN LOAD UPPER([value]) AS [AD-GroupName], [__FK_customProperties] AS [__KEY_root] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__FK_customProperties]);