Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Work around small API Limits - 2000 API calls per hour for dot digital

I am working on getting all of the activity data from dotdigital into PowerBI but I can't fetch much data because of the API limit of 2000 calls per hour. I have been able to get all email campaigns ...
  • ibarrau's avatar
    5 years ago

    Hi. We can talk about the architecture to implement historical data. However we can't say if dotdigital will let you do it easily because that's a third party tool.

    The best way to build historical API data is loading a storage. You can create scripts in Azure Functions, Runbooks or even usar Azure Data Factory to get data from API and insert in storage. The storage is up to you. You can use Data Lake Gen2, Databases, etc.

    That way you can store the data of the results every day until you just run the minimum amount of requests per day to get the most recent data to the store.

    I hope that helps,