From API how to get pull requests closed between two dates?

Question

Using the official SDK https://pypi.org/project/atlassian-python-api/ how can someone get a list of pull requests that were closed between two dates?

Right now I can get only by creation date:

from atlassian.bitbucket.cloud import Cloud
from atlassian.bitbucket.cloud.repositories import Repository
from atlassian.bitbucket.cloud.repositories.pullRequests import PullRequest
from atlassian.bitbucket.cloud.workspaces.projects import Project

bitbucket: Cloud = Cloud(username = "zzz", password = "bbb")
project: Project = bitbucket.workspaces.get("xxx").projects.get("yyy")

repo: Repository
for repo in project.repositories.each():
    pull_request: PullRequest
    for pull_request in repo.pullrequests.each(
        q = " AND ".join([
            "state = \"MERGED\"",
            "destination.branch.name = \"master\"",
            "created_on >= \"ggg\"",
            "created_on <= \"ggg\""
        ])
    ):
        print(pull_request)

Theodora Boudale · Answer

Hi Marius,

I understand that this is not ideal. I went ahead and created a request in our issue tracker to support this:

* https://jira.atlassian.com/browse/BCLOUD-22709

Please make sure to vote for it to express your interest.

You can still use the rest of the filters you have in your examples, but filtering by closed_on date on the client side is the only workaround at the moment.

Kind regards,
Theodora

marius.guscius · Answer

but that will pull ALL pull requests and I will have to do the filtering on client side. What if we have thousands of pull requests - it will take ages to do it. Not only that, every time when new request is created and merged it will become even slower. This filtering should be done on server-side I think...

Theodora Boudale · Answer

Hi Marius,

This endpoint is for a specific pull request indeed. If you need to get the closed_on field for all pull requests, you can use fields=*.* with this endpoint:

https://api.bitbucket.org/2.0/repositories/{workspace}/{repo_slug}/pullrequests?q=state+=+"MERGED"&fields=*.*

I see though that filtering is not supported for the closed_on field, which is the reason for the error you posted in your other reply.

In this case, you could use fields=*.* with the rest of your filters in order to get the field closed_on in the output, and then use another tool that filters json data (like jq) in order to filter the results based on the value of this field.

Kind regards,
Theodora