Best answer

keep a airtable base updated from postgresql

  • 13 April 2021
  • 2 replies
  • 67 views

Userlevel 1

Hello!

I’m using Zapier to connect a Postgresql table to Airtable. My idea is to keep the airtable base live updated with the postgresql including multiple fields of past records. I’m using a three step zap:

  1. Trigger -  New or Updated Row in PostgreSQL
  2. Action - Find or Create Record in Airtable
  3. Action -  Update Record in Airtable

I think that steps 1 and 2 are working fine, as I got new records to Airtable, but I can’t understand why action 3 is not working. Not sure also if this configuration works or if I need to code something.

Ah, action 3 is returning “not found”. 

Thanks!

icon

Best answer by Troy Tessalone 13 April 2021, 16:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @vitordalpra 

Make sure you are mapping the Airtable Record ID from Step 2 to Step 3 using the ‘Custom’ mapping option.

Otherwise, please provide screenshots of how your Step 3 is configured, thanks.

Userlevel 1

Hey @Troy Tessalone, just passing by to say it worked (sorry for the super delay). Thank you!