Paginating Response

Paginate your accounts data easily

As you're probably aware, using getProgramAccounts() can be tricky because it doesn't support pagination right now. This becomes a headache when dealing with large amounts of data in a single call, often resulting in connection timeouts. The good news is that GraphQL makes pagination a breeze. Let's revisit our earlier query and see how we can paginate the proposalsV2 account data.

To make pagination work, we just need to include the offset field in our query.

Its as simple as this, now we can just keep on increasing the offset to 1, 2,3 and so on and we will keep on getting more data.

Use our GraphQL demo project to try out these queries in code.

query MyQuery {
  GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw_ProposalV2(offset: 0) {
    name
    pubkey
  }
}