MalloZup
Graphql: accessing GitHub issue more then 100
Hi all,
I have developed in past an utils for maintaining opensource projects especially issues in GitHub.
As current limitation, the CLI can’t access more then 100 Issue. (https://github.com/MalloZup/blacktango)
My question would be, do you know/ or have experience with the way for accessing all the issue in a project using Graphql?
Like if i would have 5000 issues, how would this work with Graphql GitHub
See my current query https://github.com/MalloZup/blacktango/blob/master/lib/github/graphql.ex#L9
Marked As Solved
Phillipp
Man are you lucky today. The GitHub GraphQL Explorer had one of my test queries from 2017 stored in my localstorage.
{
repository (owner: "bolt", name: "bolt") {
name
issues (last: 5, before: "Y3Vyc29yOjIxMDI0NDc1NA==") {
totalCount
edges {cursor}
nodes {
number
title
comments (first: 5) {
edges {cursor}
nodes {
body
}
}
}
}
}
}
the edges {cursor} is important because they give you the IDs for the before and after params.
As you can see in the query, I get some issues and then its comments. But the comments are also limited to a specific number so you have pagination there too.
(and comments have reactions (paginated) and issues have actions (opened, closed, etc. ) (paginated too)). It really is a mess if you want to grab everything 
Also Liked
Phillipp
The API supports pagination.
See https://developer.github.com/v4/object/repository/
Scroll down to “issues”.
LostKobrakai
I’d imagine it’s a hard limit by GitHub to limit execution time of queries. If you need more use pagination to query the rest in addition requests.
Phillipp
The problem with the GitHub GraphQL API is, that your rate limit is very low and they got pagination for everything. I once tried to fetch all issues/pull requests with all its comments and actions to analyze the data and give the repository a “rating” based on maintainer reaction times. It’s impossible if you want to stay inside the rate limit and the complexity of the queries is also huge since you would have to deal with multiple paginations at once if you want to use the least amount of queries.
MalloZup
THx! I was hoping that there was a more clever way to have all the issue in a chunk instead of iterating over 100 and keep the Cursor id updating over them. 
Phillipp
Yeah no, GitHub doesn’t really like it if you want to grab all the data. And since the rate limit is pretty low on the GraphQL API, you might even hit it while fetching all issues on a repository.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Practical resources that improve the lives of professional developers.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"