Dear developer community,
We are currently building a 'work dashboard' tool, that aggregates information from different application databses and APIs. One of the sources we use is the Box Content API, to create an 'Open tasks on Box' counter for every user.
As far as our developers have been able to find, you can only find tasks on the document level. This means we have to maintain an index of files and periodically scan them to find changes in the tasks (new, or closed). However, this is only maintainable for a relatively small amount of documents. We are planning to expand our task counter across all files in Box, but the time to 'scan' all files (around 300k) is simply too long to be feasable taking the rate limit into account.
So my question is if there is a smarter way to tackle this problem? What is the optimal way to gather box tasks information on the user level? Is there an API endpoint we missed? Is there a way to know near real-time when a task is updated/closed?