Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lylererger
Creator II
Creator II

Get Stream Security Rules with QRS API

Hi friends!

Is that possible to get security rules for some Qlik Sense Stream?

I created some custom security rules for one stream, and i need to access it from QRS API.

I need to get few access groups for that stream.

Looked for https://help.qlik.com/en-US/sense-developer/June2020/apis/repositoryserviceapi/

methods and have no found in "qrs/stream/full" section with my custom security rules attributes for stream.

I there is any way to found them ?

Thanks in advance!

Labels (2)
2 Replies
Yorick_Stevens
Partner - Contributor III
Partner - Contributor III

Hi @lylererger , did you find any solution in the meantime?

simonaubert
Partner - Specialist II
Partner - Specialist II

Hello,

You have to create a custom REST API connexion on System Rules. security rules

https://localhost:4242/qrs/systemrule/full/

 

 

LIB CONNECT TO 'REST_Custom_Monitor_SystemRule';

RestConnectorMasterTable:
SQL SELECT 
	"id",
	"createdDate",
	"modifiedDate",
	"modifiedByUserName",
	"category",
	"subcategory",
	"type",
	"name",
	"rule",
	"resourceFilter",
	"actions",
	"comment",
	"disabled",
	"ruleContext",
	"seedId",
	"version",
	"privileges",
	"schemaPath",
	"__KEY_root",
	(SELECT 
		"@Value",
		"__FK_tags"
	FROM "tags" FK "__FK_tags" ArrayValueAlias "@Value")
FROM JSON (wrap on) "root" PK "__KEY_root";

[tags]:
LOAD	[@Value],
[__FK_tags] AS [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_tags]);


[Qlik System Rule]:
LOAD	[id] as [Qlik System Rule Id],
	[createdDate] as [Qlik System Creation Date],
	[modifiedDate] as [Qlik System Rule Modification Date],
	[modifiedByUserName] as [Qlik System Rule Modified by UserName],
	[category] as [Qlik System Rule Category],
	[subcategory] as [Qlik System Subcategory],
	[type] as [Qlik System Rule Type],
	[name] as [Qlik System Rule Name],
	[rule] as [Qlik System Rule Rule],
	[resourceFilter] as [Qlik System Rule Resource Filter],
	[actions] as [Qlik System Rule Actions],
	[comment] as [Qlik System Rule Comment],
	[disabled] as [Qlik System Rule Disabled],
	[ruleContext] as [Qlik System Rule RuleContext],
	[seedId] as [Qlik System Rule Seed Id],
	[version] as [Qlik System Rule Version],
	[privileges] as [Qlik System Rule Privileges],
	[schemaPath] as [Qlik System Rule Schema Path]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);


DROP TABLE RestConnectorMasterTable;

 

Then you can filter on Category

simonaubert_0-1647701786227.png

 

 

And then on resource filter

simonaubert_1-1647701855708.png

 

 

Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision