I really appreciate the API feature, as it’s helpful for calling constant values, even if it does require setting up each call manually. However, it would be even better if I could set it up to read values directly from a table, like Google Sheets or Airtable. Here’s what I envision:
For example, if I have an API URL like this:
GET /flights/cheapest-one-way?fromEntityId=CDG&toEntityId=JFK
In Google Sheets, I could set up column headers that match the parameters I need for each call. So, one column header could be fromEntityId for the starting destination, and another column could be toEntityId for the ending destination.
Each row could contain values for a specific request—one row might have CDG to JFK, and another could be LHR to SFO. Then, instead of having to manually set up each API call, the system could automatically pull the values from each row in the sheet to create live, working API calls.
This would allow me to easily automate and scale my API requests without needing to reconfigure them constantly. I could update values in the table as needed, and the API calls would adjust based on the latest data in the sheet.