Airtable

jomablue's ingest api enables customers to seamlessly create or update people records to jomablue using data stored in airtable this integration example provides a flexible way to push user data into jomablue based on your own business logic, such as approvals, workflows, or status changes managed inside airtable requirements to use this integration you will need an airtable base with a table containing user/people records (e g , staff members or registered people) a table or workflow that determines when to send these records (e g , registrations, approvals, etc ) airtable automation access (available on most paid plans) a jomablue api endpoint and bearer token the field mapping for your instance configured in jomablue airtable automation trigger use any trigger appropriate to your workflow for example when a record matches conditions > approval status is approved optional step find records if your workflow requires correlating multiple tables, you may use find records to collect matching entities (for simple flows using lookup fields, this step is optional ) action run script in your script action add input variables (one input per field) important ensure you have a field for organisation uid as this will be used as a unique identifier for the person in airtable and used to update people records in jomablue without creating new ones mobile numbers need to be formatted in e 164 format to be accepted as a 'mobile number' in jomablue in airtable add a new secret containing your jomablue bearer token write code to deliver the payload example airtable code let firstname = input config() firstname\[0]; let lastname = input config() lastname\[0]; let email = input config() email\[0]; let phone = input config() phone\[0]; let department = input config() department\[0]; let organisation uid = input config() organisation uid\[0]; let payload = { organisation uid organisation uid, firstname firstname, lastname lastname, email email, phone phone, department department }; let token = input secret("jomablue token"); await fetch("https //{instance} jomablue com/api/webhook/ingest/{webhookid}", { method "post", headers { "authorization" `bearer ${token}`, "content type" "application/json" }, body json stringify(payload) }); example of airtable sent payload { "organisation uid" "abc123!@#", "firstname" "max", "lastname" "piper", "email" "max piper\@jomablue com", "phone" "+61412345678", "department" "marketing" } turn on the automation once you have turned the automation on, every time the workflow is triggered, it will deliver the payload to the jomablue instance creating or updating the people list