Here is a scenario I’m trying to achieve using Parabola:
- Import data from my Airtable base and import data from a CSV
- Join the 2 tables together based on a unique ID
- If there was a match, I want the new data from my CSV to update fields for that record in Airtable
- If there are unique ID’s in my CSV that aren’t in Airtable, I want to create a new record in Airtable for each of these rows.
I know I need to bring in both data sources and join the tables based on the unique ID. I also know that I need to do a Patch API Export to Airtable to update the records and a Post API Export to Airtable for the unique ID’s not already in my Airtable.
However, I’m not sure how to accomplish this. I’m not even sure if I can do 2 API exports in the same flow. Any insight would be greatly appreciated!