Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to use Link field when accessing Airtable via SQL

Topic Labels: Integrations
480 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey all, we’re using https://syncinc.so/ to access Airtable from retool, where we use SQL to work with Airtable tables.

We have two table connected by a Link field and we need to set the Link field via SQL.

Normally it’d be something using foreign key, but I’m not sure how to achieve it here.

The SQL code would be this:

UPDATE table1
SET link_field_to_t2 = (
  select array[t2.id]
  from table2 t2
  where t2.email = 'email@email.com'
)
where id = '<some_ID>'

When I try to run this, I get:

permission denied for table table1

Is it possible to achieve what I’m trying to achieve?

0 Replies 0