.png)

Creator II
2020-08-13
03:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
1,785 Views
2 Replies

Partner - Contributor III
2021-08-24
04:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @lylererger , did you find any solution in the meantime?
1,628 Views

Partner - Specialist II
2022-03-19
10:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
And then on resource filter
Best regards,
Simon
Bi Consultant (Dataviz & Dataprep) @ Business & Decision
1,483 Views
