Baserow

Create, list, update, and delete rows in Baserow databases.

ProductivityAPI key8 actionsAll integrations

On this page

Connect
Call it from a workflow
Actions (8)
baserow_create_row
baserow_delete_row
baserow_update_row
baserow_clean_row
baserow_find_row
baserow_get_row
baserow_list_rows
custom_api_call
Details

Connect

Auth type: API key (secret_text). Paste the API key (or token) from the provider's settings into the connect dialog. It is encrypted at rest and only decrypted on the server when an action runs.

In the editor: Backend panel, Integrations tab, then Connect. This connects it for the project.
For every project in a workspace: Workspace settings, Integrations.
Owners and admins choose which integrations members may connect in the admin panel (Integrations tab), and can attach their own OAuth app there.

Call it from a workflow

Pass the action name and its input. The call resolves with { success, output, error? }; a missing connection resolves with success false and the reason. See ctx.integrations.invoke and ctx.integrations.call.

Native workflow

// .workflow.js (native ctx)
export async function run(ctx) {
  const res = await ctx.integrations.invoke("baserow", "baserow_create_row", {
    "table_id": "<table_id>",
    "table_fields": {}
  });
  if (!res.success) throw new Error(res.error);
  ctx.log.info("Baserow answered", { output: res.output });
}

defineWorkflow module

// defineWorkflow module (@app/sdk ctx)
import { defineWorkflow } from "@app/sdk";

export default defineWorkflow({
  id: "baserow-baserow-create-row",
  name: "Baserow: Create Row",
  description: "Calls Baserow when a row is created.",
  trigger: { type: "entity_event", entity: "tickets", event: "created" },
  async run(ctx, event) {
    const res = await ctx.integrations.call("baserow", {
      "action": "baserow_create_row",
      "table_id": "<table_id>",
      "table_fields": {}
    }) as { success: boolean; error?: string };
    if (!res.success) throw new Error(res.error);
  },
});

From an app (connector proxy)

curl -X POST "$APP_ORIGIN/__appbricx/connector-proxy/baserow/baserow_create_row" \
  -H "Authorization: Bearer $APP_KEY" \
  -H "content-type: application/json" \
  -d '{"props":{"table_id":"<table_id>","table_fields":{}}}'

Actions

baserow_create_rowin catalog

Create Row. Creates a new row.

Also accepted as create_row.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`table_fields`required	object (depends on other props)	Table Fields

baserow_delete_rowin catalog

Delete Row. Deletes an existing row.

Also accepted as delete_row.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`row_id`required	id (picked from your account)	Select the row.

baserow_update_rowin catalog

Update Row. Updates fields in an existing row. Empty values are skipped. To clear a field, use Clean Row.

Also accepted as update_row.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`row_id`required	id (picked from your account)	Select the row.
`table_fields`required	object (depends on other props)	Table Fields

baserow_clean_row

Clean Row. Clears fields in a row. Empty values will clear the corresponding fields.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`row_id`required	id (picked from your account)	Select the row.
`table_fields`required	object (depends on other props)	Table Fields

baserow_find_row

Find Row. Finds a row by matching a field value. Returns the first match.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`field_name`required	id (picked from your account)	Select the field to search by.
`field_value`required	text	The value to search for (exact match).

baserow_get_row

Get Row. Fetches a single table row.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`row_id`required	id (picked from your account)	Select the row.

baserow_list_rows

List Rows. Finds a page of rows in given table.

Input	Type	Description
`table_id`required	id (picked from your account)	Select the table.
`page`optional	number	Page number to return. Defaults to 1.
`limit`optional	number	Number of rows to return per page. Defaults to 100.
`search`optional	text	If provided only rows with cell data that matches the search query are going to be returned.
`order_by`optional	text	If provided rows will be order by specific field.Use - sign for descending / + sing for ascending ordering. Example. "-My Field" will return rows in descending order based on "My Field" field.

custom_api_call

Custom API Call. Make a custom API call to a specific endpoint

Input	Type	Description
`url`required	object (depends on other props)	url
`method`required	one of "GET" \| "POST" \| "PATCH" \| "PUT" \| "DELETE" \| "HEAD"	Method
`headers`required	object	Authorization headers are injected automatically from your connection.
`queryParams`required	object	Query Parameters
`body_type`optional	one of "none" \| "json" \| "form_data" \| "raw"	Body Type
`body`optional	object (depends on other props)	Body
`response_is_binary`optional	boolean	Enable for files like PDFs, images, etc.
`failsafe`optional	boolean	No Error on Failure
`timeout`optional	number	Timeout (in seconds)
`followRedirects`optional	boolean	Follow redirects

Details

Id: baserow
Category: Productivity
Tags: database, open-source, nocode, airtable-alternative
Package: @activepieces/piece-baserow@0.3.0
Tier: Community