Integrating Harvest with Airtable using Integromat using the Airtable API

[Klimb_To_The_To]

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 :slightly_smiling_face:

[ScottWorld]

If you have a budget for your project and you’d like to hire an expert Airtable consultant & Registered Integromat Partner to help you with this, please feel free to contact me through my website at ScottWorld.com.

[M_k]

Hi @Klimb_To_The_Top!

Can you share the DM from @Cor here in Airtable?

Thank you,
Mary Kay