![]() ![]() 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. modified your API directly to provide a CSV output. ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |