Bitbucket Reporting - Get commits pushed by Jira users by period of time (e.g. Daily)

[Denny Aprilio Pratama]

Hi Everyone,

I am writing a Google Apps Script for Google Sheets to generate report from Bitbucket to get all commits pushed by selected Jira users by selected period of time.

There are 2 ways that I can think of :

1. Get commits from all repositories of a workspace, then filter if selected users and period match. This will return execution timeout error if there are a lot of repositories and commits.
2. I guess, to avoid timeout, get the selected Jira users first, then use each token/app password to get all repositories that the authenticated user has write access to, get the commits and filter by selected period.
I am not sure this is the best way to do it.

I am also aware there is Reports API but I haven't understand how it works yet.

Anyone have similar use cases or recommendation how can I improve what I'm trying to do?

Thank you guys.