Notifications
Clear all
Topic starter
Hi all,
I’m encountering an optimization challenge and would appreciate some ideas on how to improve my scenario.
Background:
I’m developing a simple email automation for a charter rental company. Daily, I need to retrieve all reservations (unfortunately, their booking system’s API doesn’t support webhooks for new reservations…), iterate through them, and for each reservation, call another API endpoint to get client details. After fetching this information, I need to update or create these records in Airtable.
blueprint (1).json (67.1 KB)
Problem:
There is no built-in logic or option to retrieve only new reservations. It’s crucial to refresh the database daily because last-minute and ad-hoc reservations need to be added to different email sequences.
Running this process daily consumes too many operations, making it unprofitable. I’m looking for ways to optimize this operation count.
Ideas so far:
- Since the objective is to avoid extensive iterations, it would be ideal to filter out only the new reservations (those not already in Airtable) and execute the additional steps solely for them (how can this be achieved?)
- Retrieve only current and next month’s reservations, rather than all reservations for the entire year.
- Instead of performing the iterations within callin.io, upload a JSON file to Airtable and set up the automation script within Airtable to iterate over the file and update/create records (this seems like an excessive approach).
Any suggestions?
Posted : 25/02/2025 11:57 am
Without understanding the function of each module and the nature of their output bundles, it's challenging to offer specific advice.
If you require assistance, please utilize the
Hire a Pro category. Here, you can receive personalized one-on-one support through methods like video calls, screensharing, or private messaging. This approach can expedite the resolution of your issue, particularly if it's time-sensitive. It is crucial to submit your request within the
Hire a Pro category, as forum members are prohibited from advertising their services in other sections, including this one (even for free or unpaid assistance). Once your request is posted in the
Hire a Pro category, other members will be able to assist you via alternative communication channels, such as screenshare.
Hope this helps! Feel free to reach out if you have any further questions or encounter additional issues.
P.S.: Investing some time in the callin.io Academy can significantly reduce the time and frustration you might experience when using callin.io.
Posted : 25/02/2025 2:12 pm
Topic starter
Appreciate the suggestions! Unfortunately, I can’t share the input/output of the nodes as it contains a lot of PII which I don’t want to expose.
Node 1: GET HTTP request to fetch all reservation details
Node 2: Parse the JSON
Node 3: Extract only the key values from the JSON (there is a lot of irrelevant data for each reservation so I extract key details like id, clientId, dateFrom, dateTo, commission, price etc.)
Node 4: Iterates through each reservation
Node 5: For each reservation make a GET request to fetch client details based on clientId
Node 6: Parse
Node 7: Extract only the key values from the JSON (name, email)
Hope this helps
Posted : 25/02/2025 2:45 pm