I’m trying to synchronize my base using Integromat with Harvest to get the budget spent per project and keep it up to date. I’m able to get the information from Harvest using their API which gives 1 bundle with all the values of every project in an array. The problem is to match the Harvest Project IDs to it’s corresponding Airtable Record ID (Which already has a field with the correct Harvest Project ID). I have tried Upsert Record, Update Record, Airtable API (Patch), I use the filter between the modules and I just don’t understand how to make them match even using Smart Links.
Any help or ideas would be appreciated