2 weeks ago
Hello experts!
I am trying to use to Excel and Power Query to create a refreshable Excel sheet to export the full list of users from IAS.
Thus far I have been able to use the "From Web" get data option in Excel pointing to our IAS Tenant (https://my.accounts.ondemand.com/scim/Users).
Power Query is able to connect where it downloads a file and processes is as JSON. However, instead of the users' data, I get a summary. Does anyone have some experience with this that can help?
Request clarification before answering.
| User | Count |
|---|---|
| 11 | |
| 6 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.