GraphQL to fetch GitHub Projects+Columns+Cards with issue/PR detail for a specific repo.

projects.graphql

{
  search(type: REPOSITORY, query: "org:huboard-testing spooky-octo-pug", first: 1) {
    edges {
      node {
        __typename
        ... on Repository {
          owner {
            id
          }
          name
          projects(first: 10) {
            edges {
              node {
                number
                name
                columns(first: 30) {
                  edges {
                    node {
                      name
                      cards(first: 30) {
                        edges {
                          cursor
                          node {
                            id
                            note
                            state
                            content {
                              ... on Issue {
                                id
                                number
                                title
                              }
                              ... on PullRequest {
                                id
                                number
                                title
                              }
                            }
                          }
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}