topic Re: Export List of Groups, Users, Roles in ArcGIS Online Developers Questions

Export List of Groups, Users, Roles

kapalczynski — Wed, 07 Dec 2022 16:33:58 GMT

I am looking for a python script that I can modify to export a csv file that shows all the groups, their users and their role. Any examples out there?

Re: Export List of Groups, Users, Roles

kapalczynski — Wed, 07 Dec 2022 16:53:25 GMT

Update deleted text

Re: Export List of Groups, Users, Roles

kapalczynski — Wed, 07 Dec 2022 16:52:28 GMT

I can do this and get a list of Groups (id, isFav, isInvitationOnly, owner) for a specific user using the GROUPS Object.

But how do I get a list of users and their roles from this Group Object?

esri_owned_groups = gis.groups.search('title:water', max_groups=maxResults) esri_group1 = esri_owned_groups[0] esri_group1.access print(esri_group1.groupid, esri_group1.isFav, esri_group1.isInvitationOnly) print(esri_group1.owner) time.localtime(esri_group1.created/1000)

Re: Export List of Groups, Users, Roles

kapalczynski — Wed, 07 Dec 2022 17:29:33 GMT

OK I can get a list of all the groups and a few parameters...

I think I have to now query the GROUP itself to now get the users and their role in the GROUP?

Not sure how to bridge this to get the users and roles in the group....

<Group title:"2011-2016 Dill" owner:useremail@test_VDOT>
5dc183991e97414retygdf1886474ea2
False
False
2011-2016 Dill
useremail@test_VDOT

esri_owned_groups = gis.groups.search(max_groups=1) counter = 0 for group in esri_owned_groups: groupInfo = esri_owned_groups[counter] print(groupInfo) print(groupInfo.groupid) print(groupInfo.isFav) print(groupInfo.isInvitationOnly) print(groupInfo.title) print(groupInfo.owner) counter +=1 print("There are " + str(counter) + " roles")

Re: Export List of Groups, Users, Roles

BlakeTerhune — Wed, 07 Dec 2022 17:46:28 GMT

Once you have the group object, I think you can use the user_list() method to get a dictionary listing users and owners for the group.

esri_owned_groups = gis.groups.search(max_groups=1) for group in esri_owned_groups: print(group) print(group.groupid) print(group.isFav) print(group.isInvitationOnly) print(group.title) print(group.owner) print(group.user_list())

Re: Export List of Groups, Users, Roles

kapalczynski — Wed, 07 Dec 2022 17:55:35 GMT

Thanks @BlakeTerry

Cheers

Re: Export List of Groups, Users, Roles

jcarlson — Wed, 07 Dec 2022 18:10:45 GMT

Shouldn't be too hard, though somewhat annoyingly, a group's get_members method only returns strings. Personally, I can't get user_list to return anything.

If we query the users separately, we can merge them in using pandas.

mport pandas as pd from arcgis import GIS gis = GIS('your url') # groups grps = gis.groups.search(max_groups=10000) grp_list = [] for g in grps: for u in g.get_members()['users']: grp_list.append({'group':g.title, 'user':u}) g_df = pd.DataFrame(grp_list) #users users = gis.users.search(max_users=10000) user_list = [] for u in users: user_list.append({'user':u.username, 'role':u.role}) u_df = pd.DataFrame(user_list) # output merged doc g_df.merge(u_df, on='user', how='left').to_csv('group_users.csv')

The resulting CSV will list every unique group/user combination, complete with their role.