I’d like to be able to make API calls from within a cell, and use the data returned as the data in the cell. Similar to how the AI-field works, there would be a “generate” (or similar) button, and the field-value would be replaced with the returned values.
Further, it would then be great to be able to search for key/value pairs from within a formula field.
Here’s one instance of a use-case, though I’m sure there would be many, many others:
We log customers in Baserow, and keep track of their physical/mailing addresses, which is always a street address. I’d like to automatically collect the coordinates of each location as well. I’ll use these coordinates to build custom maps-tooling on some job-tracking software we’re building, with data being fed via our Baserow tables.
The best/easiest way to do this is through geocoding APIs like Google’s.
It would be great if I could click a “Generate Coordinates” button, and it would create a call to Google’s geocoding API, passing along my api key, and the street address field. Then the returned JSON data would be inputted into the field as its data. From there, I could use a formula field to parse the data, pulling only what I need from the JSON data.
