hi guys .. im new in supabase also in development ...
# sql
i
hi guys .. im new in supabase also in development ^^ but i was wondering how can i pull data through an api from e.g airtable and cashing it in supabase and then used these data from supabase api
t
I'm also new to supabase though do work with underlying technologies with postgrest.
Though I think the combination of the
http
extension and
pg_cron
both advertised as compatible in https://supabase.com/docs/guides/database/extensions will help. You could use
pg_cron
to call an function /
rpc
that uses
http
to call the airtable api. You could also have another
rpc
that receives a webhook from airtable. Note: i assume airtable has an api and webhooks as I'm not familiar with it or read their docs.
or there is paid service that will sync airtable to any postgres db: https://www.sequin.io/sources