Fabric GraphQL Pagination

Hello nbj-ksdh 

Please give this a try

const fetch = require('node-fetch');

// Example function to retrieve large sets in 1,000-row chunks.
async function fetchAllRows() {
let offset = 0;
const limit = 1000;
let allRows = [];

while (true) {
// Adjust field names or parameters as needed for your schema.
const query = `
query GetRows($limit: Int!, $offset: Int!) {
myTable(limit: $limit, offset: $offset) {
id
name
// Include other columns as necessary
}
}
`;

const response = await fetch("YOUR_GRAPHQL_ENDPOINT", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({ query, variables: { limit, offset } })
});

const json = await response.json();

const currentBatch = json.data?.myTable || [];
allRows.push(...currentBatch);

// If there's fewer than 'limit' rows, we're done
if (currentBatch.length < limit) {
break;
}

offset += limit;
}

return allRows;
}

// Usage example:
fetchAllRows()
.then(rows => {
console.log(`Retrieved ${rows.length} total rows.`);
// Do something with your data here
})
.catch(err => console.error(err));

function uses offset-based pagination (`limit` and `offset`), which is compatible with GraphQL implementations in Microsoft Fabric. However, if the schema includes fields like `endCursor` and `hasNextPage`, you might consider switching to cursor-based pagination for better efficiency

You must create a GraphQL API endpoint within your Fabric workspace. This involves selecting a data source (e.g., a Data Warehouse or SQL database) and exposing the required tables or fields through the API. The schema is automatically generated based on the selected data source

Please accept the answer if this is helpful and give kudos

Hi nbj-ksdh ,
Could you please confirm if the issue has been resolved after raising a support ticket? If a solution has been found, it would be greatly appreciated if you could share the insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

Regards,
Pallavi.

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.

Adjust the query below by changing the number after (first:

Hi nbj-ksdh ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

Regards,
Pallavi G