I would like to request a new column type called API Column or HTTP Column that enables making API calls to external services using data from the same row. This column type will facilitate dynamic fetching of data from third-party APIs and store the responses in the same row for further processing and reference.
Use Case:
- For each row, the column will use one or more fields from that row to construct an API request (GET, POST, etc.) to an external service.
- The response received from the API will be automatically stored in the same row.
- This feature will allow users to enrich their dataset with live data from external sources without manual intervention.
Benefits:
- Automate data enrichment by integrating external APIs directly within the database interface.
- Enable real-time data fetching for each record dynamically.
- Facilitate complex workflows and automation by bridging internal data with external services.
Example Scenario:
A row contains a product SKU and location details. The API Column uses this data to call a shipping rate API and stores the returned shipping cost and estimated delivery time in the same row where the return order