Forum Discussion

nbj-ksdh's avatar
nbj-ksdh
Frequent Visitor
1 year ago
Solved

Fabric GraphQL Pagination

We will be using the new GraphQL API element to expose data from a Lakehouse to an application. The application needs to retrieve a lot of rows (+1mio). I can't find a single example online that show...
API for GraphQL
Lakehouse
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi nbj-ksdh ,
    Thank you for reaching out to Microsoft Fabric Community Forum!

    We sincerely apologize for the delay in response.Seems your issue is not resolved. Therefore, we request you to consider raising a support ticket to resolve the issue.

    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

     

anders75's avatar
anders75
Regular Visitor
1 year ago

Hello,

We have an Object that we can query like: {  "query": "query { xxx_factgeneraljournalaccountentryv1s(first: 1000) { items {ledgeraccount accountingdate transactioncurrencyamount} } }"

}
Where can we change the GraphQL schema to support cursor-based pagination since the schema viewer in Fabric is read only?  

 

ChatGPT tells me to ...

  1. Locate Your GraphQL Server Code:
  2. Find the file where your GraphQL schema is defined. This is typically a .graphql file or within your server code (e.g., using Apollo Server, Express-GraphQL, etc.).
  3. Add the Pagination Types:
    • Add the PageInfo type and other necessary types for cursor-based pagination to your schema definition.

       

 

I dont know if this is the right way though.

Any assistance is much appreciated.

Je-maintiendrai's avatar
Je-maintiendrai
Frequent Visitor
1 year ago

What do you want to achieve? do you want to output more records? if so, this might work: change the number after first to your desired amount (up until 100.000). 

query
{
  publicholidays (first:10000, after:null){
     items {
        countryOrRegion
        holidayName
        countryRegionCode
        date
     }
  }
}
 
If you want more records add the endCursor function like below and use its output to requery the api (I dont have the entire way mapped out unfortunately since its not necessary for our company)

query
{
  publicholidays (first:10000, after:null){
     items {
        countryOrRegion
        holidayName
        countryRegionCode
        date
     }
     endCursor
     hasNextPage
  }
}