How can I query a bitbucket rest API using the date created?

[Govind Haridas]

I want to get the data regarding all the pull requests made after a particular date. I have the api for that. I'm able to fetch data by giving state and limit. But I need to fetch only the pull requests made on or after a particular date.

This is the way i tried to get for the date '2019-08-03' : 

https://XXX-XXX.com/stash/rest/api/1.0/projects/XXXX/repos/XXX/pull-requests?state=open&limit=100&created_on>=2019-08-03T14:00:00-07:00

[Daniil Penkin]

Hi @Govind Haridas

Sorry I'm confused because you labeled your question with bitbucket-cloud whereas the API you referred to looks more like Bitbucket Server's.

I'm not sure if filtering by creation date is possible with Bitbucket Server. It can be done with Bitbucket Cloud though. Please clarify which product you're using.

Cheers,
Daniil

[Govind Haridas]

Hi @Daniil Penkin ,

I'm using BitBucket server only. I need to filter the pull requests made on or after a particular date from the rest api.

[Daniil Penkin]

Hello @Govind Haridas,

I double checked with Bitbucket Server team: unfortunately, pull requests REST API doesn't support filtering PRs by creation date.

The only date-related parameter is order, but it works with last update date, not creation date.

Cheers,
Daniil

[felis paul]

Hi Daniil,

Can you tell me the parameter name through which I can get pull requests created after a certain date in Bitbucket Cloud? Requesting you to please reply to this query on urgent basis as we are stuck in our work.

Regards,

Felis Paul

[Daniil Penkin]

Hello @felis paul ,

You can use BBQL query for that (see Filtering), something like this:

https://api.bitbucket.org/2.0/repositories/atlassian/atlaskit-mk-2/pullrequests?q=created_on%3C2017-08-25T00:00:00.000Z

Cheers,
Daniil

[felis paul]

Thanks a lot Daniil for your quick response. Really appreciate it.