topic Re: How to get user group information in sas in Developers

How to get user group information in sas

KatiyarShubham — Mon, 28 Sep 2020 05:57:09 GMT

Hi All,

I am looking for sas viya rest api to retrieve user group information of a particular user.

Thanks in advance!

Re: How to get user group information in sas

AllanBowe — Mon, 28 Sep 2020 07:29:02 GMT

Hi Katiyar,

The endpoint you need is this one:

&base_uri/identities/users/&user/memberships?limit=100

If you're looking to do this in SAS, there is already a macro in the @sasjs/core library - mv_getusergroups.sas

Example usage:

/* compile macros */
filename mc url "https://raw.githubusercontent.com/sasjs/core/main/all.sas";
%inc mc;
/* extract groups for a particular user */
%mv_getusergroups(&sysuserid,outds=users)

Re: How to get user group information in sas

joeFurbee — Mon, 28 Sep 2020 11:40:57 GMT

Hi @KatiyarShubham,

I wanted to follow up @AllanBowe's response with the following disclaimer:

The identities API is not publicly available. PLEASE UNDERSTAND: as the API is not public there is a higher risk of breaking changes without warning. Since the REST API is currently not supported, SAS Technical Support will not provide any support if you have any additional questions about the usage of the REST API identities. The API may become public/documented/supported in the future, but until then, will need to be used with this understanding.

You may also want to look at the SAS Viya CLI. There are multiple commands supporting identities along with examples. The pyviyatools GitHub repository supports the CLI from a Python perspective.

Thanks,

Joe

Re: How to get user group information in sas

alancox — Mon, 28 Sep 2020 15:04:10 GMT

@joeFurbee it's an interesting shift in what is & isn't officially documented & therefore supported when it comes to the Viya APIs. The admin CLI provides scope to see what's happening under the covers when using the "--verbose" option where you'll see the identities API calls doing their stuff using the examples you link to, compared to what can be seen directly in the python scripts such as listgroupsandmembers.py

Both certainly provided the starting point for creating customized processes.