I chose @integromat to run the sync because sometimes native @bubble gets wonky at scale when running operations on lists of items.

I have 1000s of rows in my @airtable base so that's a large number!

Here's a screenshot of my Integromat setup!

#buildinpublic
Quick Tip:
Schedule large scale automated operations like these at a time when your Users are asleep. I typically schedule mine to run between 3 - 5AM.

This way, you're utilising your @bubble capacity during a down period of your app, and Users don't have to deal with lag! 😉
In my @airtable I have a View labeled API. This is locked and uneditable by collaborators.

The Airtable API uses data from the API View to supply to Integromat, based on the "Last Modified Time". So every day at a fixed time (3-5AM), any records that have changes get updated!🕐
I'm lazy, so I chose to POST to Bubble with a #JSON String.

@bubble can detect all the fields automatically because they have a neat "Detect Request Data" feature!

This saves me the trouble of inputting Key-Value pairs one by one...🤦‍♂️

#api
🚢Shipped this within a couple of hours! From figuring it out, configurations and testing.

Was this thread useful?

1. Follow me @felixtanhm

2. Please RT the first tweet above!

Every bit of support helps! :)
You can follow @felixtanhm.
Tip: mention @twtextapp on a Twitter thread with the keyword “unroll” to get a link to it.

Latest Threads Unrolled: