How do I run a SQL view to show all the users in each user group?

[hernandezmachava]

Hi @Matthew_Boddie,

Using https://play.dhis2.org/2.34.4/api/userGroups?&fields=name,users[displayName,userCredentials[username]]&paging=false, I have the following xml file

But I am unable to download this xml file in dhis 2 so that I can import it into excel.

Thanks