topic Re: API admin methods limit of 200 in Developer

API admin methods limit of 200

Dragon496 — Tue, 18 Jan 2022 15:24:16 GMT

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

Re: API admin methods limit of 200

Anonymous — Fri, 21 Jan 2022 05:37:30 GMT

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

Re: API admin methods limit of 200

Dragon496 — Mon, 24 Jan 2022 08:18:23 GMT

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

Re: API admin methods limit of 200

Anonymous — Mon, 31 Jan 2022 09:01:06 GMT

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

Re: API admin methods limit of 200

jaakkow — Wed, 03 Aug 2022 04:14:05 GMT

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.

Re: API admin methods limit of 200

Dragon496 — Wed, 03 Aug 2022 07:38:28 GMT

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

Re: API admin methods limit of 200

JzzyJ — Mon, 21 Oct 2024 12:53:43 GMT

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.