Adalo

App · 7 actions

Work with your Adalo app's data: list, read, add, update and delete records in its collections, start a workflow when a record is added, and send push notifications to its users.

Actions

ActionWhat it does
Create recordAdd a record to a collection, with values for its properties.
Delete recordDelete a record from a collection for good.
Get recordGet one record of a collection by its ID, with all its properties.
List collectionsList the collections saved on the Adalo connection, with the properties of each (read from its first record).
List recordsList a page of a collection's records, oldest first, optionally only those whose property equals a value.
Send push notificationSend a push notification to one user of the app, by their email address or user ID.
Update recordChange some properties of a record.

Create record

Add a record to a collection, with values for its properties.

Inputs

Collectioncollection_idtextRequired
The collection. Pick one saved on the connection, or give its ID (it starts with t_) or the endpoint address from the collection's API Documentation in Adalo.
FieldsfieldsobjectRequired
Each property's name, as in Adalo, with its value, such as Name: Jo. Properties left out are left empty.

Outputs

collection_idtext
The collection's ID
created_attext
When the record was added (ISO 8601), empty if Adalo gave none
idnumber
The record's ID
recordobject
Every property of the record by name, as Adalo gives it
updated_attext
When the record last changed (ISO 8601), empty if Adalo gave none
Example output
{
  "collection_id": "t_c9422c2457064383b6fb8e75a3cb",
  "created_at": "2026-11-10T09:00:00.000Z",
  "id": 42,
  "record": {
    "Email": "jo@example.com",
    "Name": "Jo Bloggs",
    "Paid": false,
    "Quantity": 3,
    "Status": "Open",
    "created_at": "2026-11-10T09:00:00.000Z",
    "id": 42,
    "updated_at": "2026-11-10T09:00:00.000Z"
  },
  "updated_at": "2026-11-10T09:00:00.000Z"
}

Delete record

Delete a record from a collection for good.

Inputs

Collectioncollection_idtextRequired
The collection. Pick one saved on the connection, or give its ID (it starts with t_) or the endpoint address from the collection's API Documentation in Adalo.
Record IDrecord_idtextRequired
The record's ID, a whole number, from 'List records' or an earlier step.

Outputs

collection_idtext
The collection's ID
deletedtrue/false
Always true once deleted
idnumber
The ID of the record deleted
Example output
{
  "collection_id": "t_c9422c2457064383b6fb8e75a3cb",
  "deleted": true,
  "id": 42
}

Get record

Get one record of a collection by its ID, with all its properties.

Inputs

Collectioncollection_idtextRequired
The collection. Pick one saved on the connection, or give its ID (it starts with t_) or the endpoint address from the collection's API Documentation in Adalo.
Record IDrecord_idtextRequired
The record's ID, a whole number, from 'List records' or an earlier step.

Outputs

collection_idtext
The collection's ID
created_attext
When the record was added (ISO 8601), empty if Adalo gave none
idnumber
The record's ID
recordobject
Every property of the record by name, as Adalo gives it
updated_attext
When the record last changed (ISO 8601), empty if Adalo gave none
Example output
{
  "collection_id": "t_c9422c2457064383b6fb8e75a3cb",
  "created_at": "2026-11-10T09:00:00.000Z",
  "id": 42,
  "record": {
    "Email": "jo@example.com",
    "Name": "Jo Bloggs",
    "Paid": false,
    "Quantity": 3,
    "Status": "Open",
    "created_at": "2026-11-10T09:00:00.000Z",
    "id": 42,
    "updated_at": "2026-11-10T09:00:00.000Z"
  },
  "updated_at": "2026-11-10T09:00:00.000Z"
}

List collections

List the collections saved on the Adalo connection, with the properties of each (read from its first record). Adalo can't list an app's collections itself.

Inputs

None.

Outputs

collectionslist
The saved collections
countnumber
How many are saved
Example output
{
  "collections": [
    {
      "fields": [
        {
          "name": "Name",
          "type": "text"
        },
        {
          "name": "Quantity",
          "type": "number"
        }
      ],
      "found": true,
      "has_records": true,
      "id": "t_c9422c2457064383b6fb8e75a3cb",
      "name": "Orders"
    }
  ],
  "count": 1
}

List records

List a page of a collection's records, oldest first, optionally only those whose property equals a value. Gets one page; to see more, run it again starting at the next offset it gives.

Inputs

Collectioncollection_idtextRequired
The collection. Pick one saved on the connection, or give its ID (it starts with t_) or the endpoint address from the collection's API Documentation in Adalo.
Match propertyfilter_keytext
Only records whose value for this property equals 'Match value'. Text, number, true/false and date properties only.
Match valuefilter_valuetext
The value 'Match property' must equal, such as Open or 42.
Page sizelimitnumber
How many records to return, 1 to 1,000. Adalo's default is 100.From 1 to 1000.
Start atoffsetnumber
How many records to skip, oldest first: 0 for the first page, or the 'next_offset' an earlier page gave.At least 0.

Outputs

collection_idtext
The collection's ID
countnumber
How many are on this page
has_moretrue/false
Whether the page was full, so more may follow
next_offsetnumber
Where the next page starts
offsetnumber
Where this page started
recordslist
The records on this page
Example output
{
  "collection_id": "t_c9422c2457064383b6fb8e75a3cb",
  "count": 1,
  "has_more": false,
  "next_offset": 1,
  "offset": 0,
  "records": [
    {
      "collection_id": "t_c9422c2457064383b6fb8e75a3cb",
      "created_at": "2026-11-10T09:00:00.000Z",
      "id": 42,
      "record": {
        "Email": "jo@example.com",
        "Name": "Jo Bloggs",
        "Paid": false,
        "Quantity": 3,
        "Status": "Open",
        "created_at": "2026-11-10T09:00:00.000Z",
        "id": 42,
        "updated_at": "2026-11-10T09:00:00.000Z"
      },
      "updated_at": "2026-11-10T09:00:00.000Z"
    }
  ]
}

Send push notification

Send a push notification to one user of the app, by their email address or user ID. Tapping it opens the app's home screen.

Inputs

TitletitletextRequired
The notification's title.
MessagemessagetextRequired
The notification's text.
Recipient emailrecipient_emailtext
The email address the user signed up to the app with. Give this or 'Recipient user ID'.
Recipient user IDrecipient_user_idtext
The user's record ID in the app's Users collection. Give this or 'Recipient email'.

Outputs

deliveredtrue/false
Whether it reached at least one device
failednumber
Devices that have turned notifications off
recipienttext
The email address or user ID it was sent to
successfulnumber
Devices it was delivered to
Example output
{
  "delivered": true,
  "failed": 0,
  "recipient": "jo@example.com",
  "successful": 1
}

Update record

Change some properties of a record. Properties not given keep their values.

Inputs

Collectioncollection_idtextRequired
The collection. Pick one saved on the connection, or give its ID (it starts with t_) or the endpoint address from the collection's API Documentation in Adalo.
Record IDrecord_idtextRequired
The record's ID, a whole number, from 'List records' or an earlier step.
FieldsfieldsobjectRequired
Each property to change, by its name in Adalo, with its new value, such as Status: Done.

Outputs

collection_idtext
The collection's ID
created_attext
When the record was added (ISO 8601), empty if Adalo gave none
idnumber
The record's ID
recordobject
Every property of the record by name, as Adalo gives it
updated_attext
When the record last changed (ISO 8601), empty if Adalo gave none
Example output
{
  "collection_id": "t_c9422c2457064383b6fb8e75a3cb",
  "created_at": "2026-11-10T09:00:00.000Z",
  "id": 42,
  "record": {
    "Email": "jo@example.com",
    "Name": "Jo Bloggs",
    "Paid": false,
    "Quantity": 3,
    "Status": "Done",
    "created_at": "2026-11-10T09:00:00.000Z",
    "id": 42,
    "updated_at": "2026-11-10T10:00:00.000Z"
  },
  "updated_at": "2026-11-10T10:00:00.000Z"
}

On this page