Categories: Productivity and Collaboration

Type: baserow/v1

Connections

Version: 1

custom

Properties

Connection Setup

Connect Baserow to ByteChef using a Database Token.

Create a Database Token in Baserow

1. Log in to Baserow.
2. Open your avatar menu and go to My settings.
3. In the left sidebar, select Database tokens.
4. Click Create token +.
5. Enter a clear name (for example, ByteChef integration).
6. Choose the workspace this token should access and set the required permissions (read/create/update/delete) for the tables you plan to use.
7. Click Create token and copy the generated token value.

Actions

Create Row

Name: createRow

Creates a new row.

Properties

Example JSON Structure

{
  "label" : "Create Row",
  "name" : "createRow",
  "parameters" : {
    "tableId" : 1,
    "user_field_names" : false,
    "fields" : { }
  },
  "type" : "baserow/v1/createRow"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Find table ID

To find the Table ID, click here.

Delete Row

Name: deleteRow

Deletes the specified row.

Properties

Example JSON Structure

{
  "label" : "Delete Row",
  "name" : "deleteRow",
  "parameters" : {
    "tableId" : 1,
    "rowId" : 1
  },
  "type" : "baserow/v1/deleteRow"
}

Output

This action does not produce any output.

Find table ID and record ID

To find the Table ID, click here.

To find the Record ID, click here.

Get Row

Name: getRow

Fetches a single table row.

Properties

Example JSON Structure

{
  "label" : "Get Row",
  "name" : "getRow",
  "parameters" : {
    "tableId" : 1,
    "rowId" : 1,
    "user_field_names" : false
  },
  "type" : "baserow/v1/getRow"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Find table ID and record ID

To find the Table ID, click here.

To find the Record ID, click here.

List Rows

Name: listRows

Lists table rows.

Properties

Example JSON Structure

{
  "label" : "List Rows",
  "name" : "listRows",
  "parameters" : {
    "tableId" : 1,
    "size" : 1,
    "order_by" : "",
    "user_field_names" : false
  },
  "type" : "baserow/v1/listRows"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Find table ID

To find the Table ID, click here.

Update Row

Name: updateRow

Updates the specified row.

Properties

Example JSON Structure

{
  "label" : "Update Row",
  "name" : "updateRow",
  "parameters" : {
    "tableId" : 1,
    "rowId" : 1,
    "user_field_names" : false,
    "fields" : { }
  },
  "type" : "baserow/v1/updateRow"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Find table ID and record ID

To find the Table ID, click here.

To find the Record ID, click here.

What to do if your action is not listed here?

If this component doesn't have the action you need, you can use Custom Action to create your own. Custom Actions empower you to define HTTP requests tailored to your specific requirements, allowing for greater flexibility in integrating with external services or APIs.

To create a Custom Action, simply specify the desired HTTP method, path, and any necessary parameters. This way, you can extend the functionality of your component beyond the predefined actions, ensuring that you can meet all your integration needs effectively.

Additional Instructions

How to find your table ID

You have various methods to find your Baserow table ID:

• Method 1: Through database tokens

1. Click on your workspace in the top left corner.
2. Select Settings -> Database tokens.
3. Click on your token.
4. Select Show databases.
5. Your table IDs will be listed alongside table names.

• Method 2: Check the database API documentation

Similar to finding your database ID, the API documentation displays all table IDs within your database.

1. Go to your database settings.
2. Look for the View API docs link.
3. Baserow auto-generates documentation showing all table IDs and field structures.

• Example URL: https://api.baserow.io/api/database/tables/database/DATABASE_ID/

• Authorization: Token YOUR_API_TOKEN

• Response includes all tables with their IDs.

• Method 3: Table options menu

1. Click the three dots next to any table name.
2. The table ID appears in brackets next to the table name.

• Example: Customer Data (12345) where 12345 is your table ID.

• Method 4: Browser URL

1. Open the table you want to connect in Baserow.
2. Look at the browser address bar.
3. The URL structure is: https://baserow.io/database/DATABASE_ID/table/TABLE_ID/...
4. Extract the number after /table/.

How to find your record ID

Baserow row IDs are permanent identifiers for each record. Unlike row counts, they don't change when you sort or delete other rows.

• Method 1: Grid view

The row ID is typically visible in the grid view. Note that if you switch to other views like Kanban or Form, the row ID column might not be visible by default.

• Method 2: Browser URL

1. Open the table in Baserow.
2. Expand the row you want to identify to its full view.
3. Look at your browser’s address bar.
4. The URL structure will be: https://baserow.io/database/DATABASE_ID/table/TABLE_ID/ROW_ID/row/RECORD_ID
5. The last part of the URL is your record ID.