API admin methods limit of 200

[Dragon496]

We have developed a solution where we download admin/usage data on a daily basis, import this into SQL Server. We have also developed a report based on this data.

Recently, I have been trying to add user information to work spaces, reports, datasets et cetera. The 1st 2 went well (just now anyway). Each power shell script, loads say the reports, loops through these and calls the admin API method to retrieve the users for each report.

It was only when I tried to do the datasets, that we started hitting the 200/hour limit.

Now when extracting workspaces, you can add the parameters "expand =users" to give us the users information. However, this parameter does not work for reports, datasets et cetera.

Is there any other way to retrieve report users, app users et cetera?

Thanks

[jaakkow]

I have a similar problem.

I don´t know if this will create more problems than it solves but I just added a

"Start-Sleep -seconds 36" to the end of my foreach powershell loop.

This way I´ll slow down the script and hopefully make sure that I don´t go over the limit. The run will take a long time for sure, but if that is not a problem then this might work.

EDIT: I just realized that I could go a lot faster that 36 seconds, I´think I´ll do 20 seconds just to be on the safe side.

[Dragon496]

Hello

We discovered, on the Internet, a solution which uses the scanner API (https://github.com/RuiRomano/pbimonitor).

The report uses json files as the data source. I am trying to change that, so that we persist the data in a SQL database.

Thanks

[v-yiruan-msft]

Hi @Dragon496 ,

Please check whether the following REST APIs are what you want.

1. Get app users

Admin - Apps GetAppUsersAsAdmin

2. Get report users

Admin - Reports GetReportUsersAsAdmin

Best Regards

[Dragon496]

No, this does not help me. These methods have a limit of 200 calls per hour, which was the issue detailed in my original message

[v-yiruan-msft]

Hi @Dragon496 ，

Based on my research, I didn't find any other APIs or other better ways to export user information without any limitations.

Best Regards