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.