Is there a way to export the api v4 graphql query results to excel sheet.
@vaishnav-n , welcome to the GitHub Support Community Forum!
For both the GitHub REST API and GitHub GraphQL API, all data is sent and received as JSON. While there’s not one specific document for mapping JSON to Excel, I’m sure there are client libraries out there for facilitating that transformation. You would need to first make a query to the GitHub GraphQL API, store the results (in JSON), and transform them into a format that Excel understands (CSV, TSV, or otherwise). It’s possible that the wider community has tools to recommend and I’d like to step back there and let others chime in
we were able to complete this by writing an export function in c#. would be easier in the future if export feature is available on the v4 explorer