cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How can I user power query to get data from sap Cloud Identity Service (IAS)?

egas_tt61
Newcomer
0 Likes
141

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?

 

Accepted Solutions (0)

Answers (0)