Also, besides #3, none of these solutions will allow your data analyst to export the data into CSV whenever they want, on the click of a button… Whether you chose 1, 2 or 3, it’s still a task that takes some time and can be tricky: solution #1 will be hard to automate via a script, solution #2 has the risk of running into the rate limits of your API and solution #3 could run into performance issues when you’re trying to export in a single file the gazillions of records that your API contains.
a proper script to parse the JSON output of your API into a CSV file.a quick & dirty database export (which you would have then somehow converted to a csv file).
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” ?ĭepending on how much time you had to work on this request, you could have done: Exporting your API JSON data in a CSV file via a Google Spreadsheet
0 kommentar(er)
