Forum Discussion
API admin methods limit of 200
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
6 Replies
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
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.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
To my surprise, the limit of 200 per hour for GetAppUsersAsAdmin, is not blocking my API calls. I ran the call for 380 apps 5 times in a row and it returned all users without an error. Strange but nice.
