Baserow

Baserow is an open-source, no-code database platform that enables users to create, manage, and collaborate on databases through a user-friendly interface.

Categories: productivity-and-collaboration

Type: baserow/v1

---

Connections

Version: 1

custom

Properties

Name	Label	Type	Description	Required
token	Database Token	STRING		true

---

Actions

Create Row

Name: createRow

Creates a new row.

Properties

Name	Label	Type	Description	Required
tableId	Table ID	INTEGER	ID of the table where the row must be created in.	true
user_field_names	User Field Names	BOOLEAN Options true, false	The field names returned by this endpoint will be the actual names of the fields.	false
fields		DYNAMIC_PROPERTIES Depends On tableId		true

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.

Delete Row

Name: deleteRow

Deletes the specified row.

Properties

Name	Label	Type	Description	Required
tableId	Table ID	INTEGER	ID of the table containing the row to be deleted.	true
rowId	Row ID	INTEGER	ID of the row to be deleted.	true

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.

Get Row

Name: getRow

Fetches a single table row.

Properties

Name	Label	Type	Description	Required
tableId	Table ID	INTEGER	ID of the table where you want to get the row from.	true
rowId	Row ID	INTEGER	ID of the row to get.	true
user_field_names	User Field Names	BOOLEAN Options true, false	The field names returned by this endpoint will be the actual names of the fields.	false

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.

List Rows

Name: listRows

Lists table rows.

Properties

Name	Label	Type	Description	Required
tableId	Table ID	INTEGER	ID of the table where you want to get the rows from.	true
size	Size	INTEGER	The maximum number of rows to retrieve.	false
order_by	Order By	STRING	If provided rows will be order by specific field. Use - sign for descending ordering.	false
user_field_names	User Field Names	BOOLEAN Options true, false	The field names returned by this endpoint will be the actual names of the fields.	false

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.

Update Row

Name: updateRow

Updates the specified row.

Properties

Name	Label	Type	Description	Required
tableId	Table ID	INTEGER	ID of the table containing the row to be updated.	true
rowId	Row ID	INTEGER	ID of the row to be updated.	true
user_field_names	User Field Names	BOOLEAN Options true, false	The field names returned by this endpoint will be the actual names of the fields.	false
fields		DYNAMIC_PROPERTIES Depends On tableId		true

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.