I was recently talking with my brother who is a SEO practitioner about making a way for him and others (whom aren't techies) to simply download a CSV of all his Google Search Console API data which is hard to do without a knowledge of programming. Personally, there's been many times in my career that I would pick up a backlogged bug item and have to dig around months prior for the data to fix it and wished that I could get permission from my boss to write a proper cache server to poll our API data but there was never a perceived time or place to do it. Often the bug couldn't be solved because the given API no longer had the data. Also it would be slow for certain APIs and tricky to make sure you don't go over your quota.
Mostly I think that developers such as myself would like an easy and affordable way to safely just save all their API data without having to write their own servers to transfer and cache and archive it and have it normalized with something like JSON-LD with a more sane API design, and perhaps use SQL or something like it to interface with their cached data. However, for non-technical users, I think a spreadsheet interface would be preferred and would open up your every day user to new world of possibilities. Either or, I feel what matters is taking ownership over your data (which can get expensive to retain with a given API) especially in these ransomware times. This sort of service I'm alluding to is easier to do with OAuth services than it is for say Twilio because this hypothetical service would need your API key which could be a deal breaker for some companies.
So if you could magically turn an API into a spreadsheet, what API(s) would those be and why?
Mostly I think that developers such as myself would like an easy and affordable way to safely just save all their API data without having to write their own servers to transfer and cache and archive it and have it normalized with something like JSON-LD with a more sane API design, and perhaps use SQL or something like it to interface with their cached data. However, for non-technical users, I think a spreadsheet interface would be preferred and would open up your every day user to new world of possibilities. Either or, I feel what matters is taking ownership over your data (which can get expensive to retain with a given API) especially in these ransomware times. This sort of service I'm alluding to is easier to do with OAuth services than it is for say Twilio because this hypothetical service would need your API key which could be a deal breaker for some companies.
So if you could magically turn an API into a spreadsheet, what API(s) would those be and why?