Exporting your API JSON data in a CSV file via a Google Spreadsheet
If you are an API developer working from time to time with data analysts, you might have already received a request along the lines of: “hey, would it be possible to export all of the data exposed in our API as a spreadsheet, so I could run some analysis on it” ?
Depending on how much time you had to work on this request, you could have done:
- a quick & dirty database export (which you would have then somehow converted to a csv file)
- a proper script to parse the JSON…