Get Stream Security Rules with QRS API

lylererger — Tue, 28 Dec 2021 20:13:17 GMT

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!

Re: Get Stream Security Rules with QRS API

Yorick_Stevens — Tue, 24 Aug 2021 08:36:10 GMT

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

Re: Get Stream Security Rules with QRS API

simonaubert — Sat, 19 Mar 2022 14:58:06 GMT

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

topic Re: Get Stream Security Rules with QRS API in Connectivity & Data Prep

Get Stream Security Rules with QRS API

Re: Get Stream Security Rules with QRS API

Re: Get Stream Security Rules with QRS API