Get Stream Custom Property values from REST Connection

[ldrummond]

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. 

[JandreKillianRIC]

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

[AkashPohare_HB]

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]);