Load BitBucket Database Tables for PullRequests and commits by QlikView

[Stoyanov.K.Ly]

Hi everybody!

I need to extract commits grouped by pull requests from our bitbucket database by QlikView. So, I need name of the table where they  are linked. Can anybody help with that?

I'm trying to use the following code in QlikView, but it does not work:

http://login:password@example.com/rest/api/1.0/projects/{projectKey}/repos/{repositorySlug}/pull-requests

404 Errors

[Isabella Stephens]

Hi!

You can retrieve a list of commits associated with a specific pull request either via REST, or using our Java API. To retrieve them via REST you should use the /rest/api/1.0/projects/{projectKey}/repos/{repositorySlug}/pull-requests/{pullRequestId}/commits endpoint. To retrieve the commits via the Java API you can use PullRequestService.getCommits.

The REST endpoint you've mentioned can be used to retrieve pull requests in a repository, but the response won't include the commits on those pull requests. You'd need to make a separate request for each pull request to get its commits. Be mindful that doing so could put a lot of load on Bitbucket, especially if you are making multiple requests concurrently.

If you're seeing 404 errors from this endpoint you may be calling it incorrectly - can you give me more details on how you are attempting to call the endpoint?

Cheers,

Isabella - Atlassian