topic Re: Atera API import limitation in Developer

Atera API import limitation

JudgElf — Thu, 30 Jun 2022 10:55:43 GMT

Hello,

when I import the data from Atera API to PowerBI there is a 50 items limitation on Atera side.

The imported table is contains the next/previous page link fields, like: https://app.atera.com/api/v3/tickets?page=2&itemsInPage=50

Do you have any idea how can I import all pages in to one table?

Many thanks!

Zoltan

Re: Atera API import limitation

Anonymous — Mon, 04 Jul 2022 08:01:15 GMT

Hi @JudgElf ,

As far as I know, this limitation should be set by Atera API. I think in your API URL there should be some code to link to the determind page and the data limitation in each page should be 50.

You can try to change this in data source.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Atera API import limitation

JudgElf — Mon, 04 Jul 2022 08:51:32 GMT

Hello @Anonymous ,

thanks for your ansver!

It wasn't a question, as you can see the original post link I clear about the 50 limitation and how to get pages.

The question is: how can I import this 50 row/pages to one table if I have 33 pages? ( without add the sources one by one)

Thank you!

Zoltan

Re: Atera API import limitation

JudgElf — Thu, 07 Jul 2022 10:23:22 GMT

I found the solution in this video!

https://www.youtube.com/watch?v=hHkU8tPhVXs&t=492s

!!! Thank you for Hoosier BI !!!

Best Regards!

Zoltan