---
title: Airtable
slug: docs/airtable
createdAt: 2025-12-04T03:30:18.782Z
---

::Image[]{src="https://upload.wikimedia.org/wikipedia/commons/thumb/4/4b/Airtable_Logo.svg/2560px-Airtable_Logo.svg.png" size="58" width="2560" height="558" position="center" showCaption="false"}

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.&#x20;

### Requirements

To use this integration you will need:

- &#x20;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

<u>Trigger</u>
Use any trigger appropriate to your workflow.
For example:
`When a record matches conditions -> Approval Status is Approved`
 <u>Optional Step: Find Records</u>
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.)
 <u>Action: Run Script</u>
In your Script Action:

1. Add Input Variables (one input per field)&#x20;

::Image[]{src="https://app.archbee.com/api/optimize/DHKOH0YwbTGPz2KqdQjth/OLSpR9KncAtBy0lGtAykd_cleanshot-2025-12-05-at-131002.png" size="54" width="393" height="1162" position="center" darkWidth="393" darkHeight="1162" showCaption="false"}

:::Paragraph{listRestartPolite="2" indent="1"}
**Important:**
:::

:::Paragraph{listStyleType="disc" listRestartPolite="2" indent="2"}
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.
:::

:::Paragraph{listStyleType="disc" indent="2"}
Mobile numbers need to be formatted in E.164 format to be accepted as a 'Mobile Number' in Jomablue
:::



2. In Airtable - Add a new Secret containing your Jomablue Bearer token.

::Image[]{src="https://app.archbee.com/api/optimize/DHKOH0YwbTGPz2KqdQjth/ASJwdkWxr0QAm1yewXk7H_cleanshot-2025-12-05-at-133331.png" size="76" width="387" height="218" position="center" showCaption="false"}

::Image[]{src="https://app.archbee.com/api/optimize/DHKOH0YwbTGPz2KqdQjth/34Oo3gcmq5emy33zE8MwU_cleanshot-2025-12-05-at-133253.png" size="70" width="588" height="567" position="center" showCaption="false"}

3. Write code to deliver the payload

:::CodeblockTabs
Example Airtable Code

```javascript
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

```none
{
  "organisation_uid": "ABC123!@#",
  "firstName": "Max",
  "lastName": "Piper",
  "email": "max.piper@jomablue.com",
  "phone": "+61412345678",
  "department": "Marketing"
}
```
:::

:::Paragraph{indent="1"}

:::

<u>Turn On the Automation</u>

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.

:::Paragraph{indent="1"}

:::
