Get all orders for a dashboard tooling
I'm building a dashboard for my ecommerce webshop. With the API I can get 250 orders at the time and that's okay for the new orders coming in. But to have a good overview, I want to get all my historic orders at once in my dashboard. Is there a way to get all the data from the api to the dashbaord? I want to do this one time and store it, so the new orders will be adding up. Anyone tried something like this for Powerbi, Tableau or another dashboard tooling?
Let me know! Thanks in advance.