Skip to main content

Is there a way to return data in table format? Meaning column titles is the header (1st) row in the request

  • December 13, 2022
  • 1 reply
  • 544 views
J

Hello, I am trying to run api requests to pull a boards items into a google sheet, and want to see how I can structure the request to return data similar to exporting the data as an excel file, meaning each item is in a single row and the column titles in row 1 (header row). Is this possible to do?

1 reply

A
  • Anonymous
  • December 13, 2022

Hi @Jackdegiz,

Welcome to the community!

The GraphQL API responses come in JSON format, which is written in key/value pairs. The response will always come in this format regardless of how the query is structured. But you can always parse through this response to organize the values you need into a structure that pairs well with Google Sheets.

Terms & ConditionsCookie settingsAccessibility statement