Forum Discussion

JudgElf's avatar
JudgElf
Regular Visitor
4 years ago
Solved

Atera API import limitation

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

 

Need Help

3 Replies

Replies have been turned off for this discussion
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

     

    • JudgElf's avatar
      JudgElf
      Regular Visitor
      4 years ago

      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