We use APIv2 to pull jira data for analytics and reporting. We pull data every hour based for monitoring SLAs.
If an issue has any change, the get issue - expand - changelog gives all the changes from the start, and could go back 3 months or a year, depending on when the issue was created. Every change is a new record. This causes us to pull 1.2 million records vs 6k records every hour. This causes the downstream to get overloaded with 200x records and miss reporting SLAs. We need a way to pull changelog, with a filter for date-time, where we can pull in changes in the last day and or hour