Google Sheets Is Outputting as CSV in Postman. How can I output as JSON?

0
votes

I've tried using ?alt=json instead of &output=csv, but I'm not having luck. Is it possible to output this Google Sheet as a JSON file?

The 2nd URL is returning the csv data in Postman, but issues trying to get JSON data returned.

The Google Sheets URL:

https://docs.google.com/spreadsheets/d/e/2PACX-1vS6HT4AanTSghUQZr_YWAauahN_zv6mhPcRMeAV8mGpTBs4ZixA09cqPMnZMCrivRbeU2FQ1RdiOMmo/pub?gid=0&single=true

The Google Sheets URL (CSV Output):

https://docs.google.com/spreadsheets/d/e/2PACX-1vS6HT4AanTSghUQZr_YWAauahN_zv6mhPcRMeAV8mGpTBs4ZixA09cqPMnZMCrivRbeU2FQ1RdiOMmo/pub?gid=0&single=true&output=csv

1
jsonapicsvgoogle-sheetsgoogle-sheets-query
In your case, the Spreadsheet ID can be used instead of 2PACX-###? – Tanaike
Where do I find the spreadsheet ID? Is it 1vS6HT4AanTSghUQZr_YWAauahN_zv6mhPcRMeAV8mGpTBs4ZixA09cqPMnZMCrivRbeU2FQ1RdiOMmo/pub?gid=0&single=true – jefelewis
Thank you for replying. I apologize for the inconvenience. 2PACX-### is different from the Spreadsheet ID. I asked whether you know the Spreadsheet ID. – Tanaike

1 Answers

1
votes

try:

https://spreadsheets.google.com/feeds/list/spreadsheetID/od6/public/values?alt=json

where you supply the spreadsheetID with:

0

https://developers.google.com/gdata/samples/spreadsheet_sample