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

null

Properties

Name	Label	Type	Control Type	Description	Required
token	Database Token	STRING	TEXT		true

---

Actions

Create Row

Name: createRow

Creates a new row.

Properties

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

JSON Example

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

Delete Row

Name: deleteRow

Deletes the specified row.

Properties

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

JSON Example

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

Get Row

Name: getRow

Fetches a single table row.

Properties

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

JSON Example

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

List Rows

Name: listRows

Lists table rows.

Properties

Name	Label	Type	Control Type	Description	Required
tableId	Table ID	INTEGER	INTEGER	ID of the table where you want to get the rows from.	true
size	Size	INTEGER	INTEGER	The maximum number of rows to retrieve.	false
order_by	Order By	STRING	TEXT	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	SELECT	The field names returned by this endpoint will be the actual names of the fields.	false

JSON Example

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

Update Row

Name: updateRow

Updates the specified row.

Properties

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

JSON Example

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