Hey @timonvs, Thanks for being here! This is a great question,  you can do this using the search UI but I don’t think there is a way to do it programmatically via the API. I’ll dig a little dipper and post any updates here. Hopefully another user might have more insight into this question.

Thanks @andreagriffiths11. It’s indeed possible with the search API (https://help.github.com/articles/searching-issues-and-pull-requests/#search-by-commit-sha). For my use case however that would not work very well because I need be able to identify PRs from a bunch of commits. Doing a request for every commit would be very ineffecient and I’d quickly hit the API limits.

Ideally I’d be able to do the following GraphQL query:

{
  repository(owner: "awkward", name: "sketch-frontend") {
    ref(qualifiedName: "master") {
      target {
        ... on Commit {
          id
          associatedPullRequest {
            title
            number
          }
        }
      }
    }
  }
}

@timonvs thanks for clarifying, I believe that schema is not supported yet, but has been requested. 

I figured out how to do this using github3.py. It assumes you have cloned the repo locally.

import github3
import subprocess
import os
os.chdir('C:\yourRepo')
github_repo_owner = '15five'

github_repo_name = 'yourRepo'

sha = '1425ca3' # replace with desired sha
thanks to https://stackoverflow.com/questions/17818167
out = subprocess.check_output(['git', 'describe', '--all', '--contains', sha])

text = out.decode('utf-8')

branch = text.replace('remotes/origin/','').split('~')[0]
gh = github3.GitHub(token='CENSORED') # replace token

repo = gh.repository(github_repo_owner, github_repo_name)

pulls = repo.pull_requests(state='closed', sort='updated', head=github_repo_owner+':'+branch, number=1)

your_pr = next(pulls)

print(your_pr.title)

Here is another example graphql query that takes a specific sha and outputs the associated PR’s:

query associatedPRs($sha: String, $repo: String!, $owner: String!){
  repository(name: $repo, owner: $owner) {
    commit: object(expression: $sha) {
      ... on Commit {
        associatedPullRequests(first:5){
          edges{
            node{
              title
              number
              body
            }
          }
        }
      }
    }
  }
}
{

"sha": 14242132153asfe33453,

"repo": "repo name",

"owner": "repo owner"

}

Thanks! precisely what I was looking for.

So commits are abstracted behind GitObjects 🤭

OrderByField issue @caleb15 @timonvs can you guys help me?