id | title |
---|---|
baserow |
Baserow |
ToolJet can connect to your Baserow account to read and write data. Select the hosted version of Baserow or the self-host option.
For self-hosted option, base URL is required to connect.
Baserow API token is required to create an Baserow data source on ToolJet. You can follow the steps to create API token from this link.
:::tip This guide assumes that you have already gone through Adding a data source tutorial. :::
This query lists all the fields in a table.
- Table ID
Example response from Baserow:
[
{
"id": 331156,
"table_id": 57209,
"name": "Name",
"order": 0,
"type": "text",
"primary": true,
"text_default": ""
},
{
"id": 331157,
"table_id": 57209,
"name": "Last name",
"order": 1,
"type": "text",
"primary": false,
"text_default": ""
},
{
"id": 331158,
"table_id": 57209,
"name": "Notes",
"order": 2,
"type": "long_text",
"primary": false
},
{
"id": 331159,
"table_id": 57209,
"name": "Active",
"order": 3,
"type": "boolean",
"primary": false
}
]
This query lists all the rows in a table.
- Table ID
Example response from Baserow:
{
"count": 3,
"next": null,
"previous": null,
"results": [
{
"id": 2,
"order": "0.99999999999999999991",
"Name": "Bill",
"Last name": "Gates",
"Notes": "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce dignissim, urna eget rutrum sollicitudin, sapien diam interdum nisi, quis malesuada nibh eros a est.",
"Active": false
},
{
"id": 3,
"order": "0.99999999999999999992",
"Name": "Mark",
"Last name": "Zuckerburg",
"Notes": null,
"Active": true
},
{
"id": 1,
"order": "0.99999999999999999997",
"Name": "Elon",
"Last name": "Musk",
"Notes": null,
"Active": true
}
]
}
- Table ID
- Row ID
Example response from Baserow:
{
"id": 1,
"order": "0.99999999999999999997",
"Name": "Elon",
"Last name": "Musk",
"Notes": null,
"Active": true
}
- Table ID
- Records
{
"Name": "Test",
"Last name": "Test Name",
"Notes": "Test Note",
"Active": true
}
Example response from Baserow:
{
"id": 19,
"order": "0.99999999999999999996",
"Name": "Test",
"Last name": "Test Name",
"Notes": "Test Note",
"Active": true
}
- Table ID
- Row ID
- Records
{
"Name": "Test",
"Last name": "Test Name",
"Notes": "Test Note",
"Active": true
}
Example response from Baserow:
{
"id": 19,
"order": "0.99999999999999999996",
"Name": "Test",
"Last name": "Test Name",
"Notes": "Test Note",
"Active": true
}
- Table ID
- Row ID
- Before ID (The row will be moved before the entered ID. If not provided, then the row will be moved to the end )
Example response from Baserow:
{
"id": 3,
"order": "2.00000000000000000000",
"Name": "Mark",
"Last name": "Zuckerburg",
"Notes": null,
"Active": true
}
- Table ID
- Row ID
While deleting a row, the response will be either success or failure from Baserow