How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Need help?

Contact us
Baserow

Baserow Database table fields API

The Database table fields API from Baserow — 9 operation(s) for database table fields.

Documentation Provider Profile APIs.io OpenAPI GitHub

Baserow Database table fields API is one of 58 APIs that Baserow publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 1 JSON Schema definition.

Tagged areas include Database table fields. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, authentication docs, and 1 JSON Schema.

This API exposes 12 operations across 9 paths, and defines 145 schemas. It is described by OpenAPI 3.0.3, at version 2.2.2.

Requests are made against the base URL https://api.baserow.io.

12 operations 9 paths 145 schemas 1 DELETE3 GET1 PATCH7 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.0.3
API Version
2.2.2
Base URL
https://api.baserow.io
Authentication
HTTP Bearer, HTTP Bearer, HTTP Bearer
Contact
https://baserow.io/contact
License
MIT
Resource Areas
1

Authentication & Security 3

Baserow Database table fields API declares 3 security schemes for authenticating requests. It accepts HTTP bearer tokens (Token your_token) (Database token). It accepts HTTP bearer tokens (JWT your_token) (JWT). It accepts HTTP bearer tokens (JWT your_token) (UserSource JWT).

Paths & Operations 12

Across 9 paths, the API surfaces 12 operations — 1 DELETE, 3 GET, 1 PATCH, 7 POST. Each is listed below with its method, path, parameters, and response codes.

Database table fields 12
GET
/api/database/fields/{field_id}/
Returns the existing field if the authorized user has access to the related database's workspace. Depending on the type different properties could be returned.
get_database_table_field 1 param → 200400404
PATCH
/api/database/fields/{field_id}/
Updates the existing field if the authorized user has access to the related database's workspace. The type can also be changed and depending on that type, different additional properties can optional…
update_database_table_field 3 params body → 200400404
DELETE
/api/database/fields/{field_id}/
Deletes the existing field if the authorized user has access to the related database's workspace. Note that all the related data to that field is also deleted. Primary fields cannot be deleted becaus…
delete_database_table_field 3 params → 200400404
POST
/api/database/fields/{field_id}/duplicate/async/
Duplicates the table with the provided tableid parameter if the authorized user has access to the database's workspace.
duplicate_table_field 3 params → 202400404
POST
/api/database/fields/{field_id}/generate-ai-field-values/
Endpoint that's used by the AI field to start an sync task that will update the cell value of the provided row IDs based on the dynamically constructed prompt configured in the field settings. This i…
generate_table_ai_field_value 3 params body → 202400404
GET
/api/database/fields/{field_id}/unique_row_values/
Returns a list of all the unique row values for an existing field, sorted in order of frequency.
get_database_field_unique_row_values 3 params → 200400404
POST
/api/database/fields/password-authentication/
Checks if the provided password and row matches what is stored in the cell. The field must have allowendpointauthentication set to true in order to work.
password_field_authentication body → 200400401404
GET
/api/database/fields/table/{table_id}/
Lists all the fields of the table related to the provided parameter if the user has access to the related database's workspace. If the workspace is related to a template, then this endpoint will be p…
list_database_table_fields 1 param → 200400401404
POST
/api/database/fields/table/{table_id}/
Creates a new field for the table related to the provided tableid parameter if the authorized user has access to the related database's workspace. Depending on the type, different properties can opti…
create_database_table_field 3 params body → 200400401404
POST
/api/database/fields/table/{table_id}/change-primary-field/
Changes the primary field of a table to the one provided in the body payload.
change_primary_field 3 params body → 200400404
POST
/api/database/fields/table/{table_id}/generate-ai-formula/
This endpoint generates a Baserow formula for the table related to the provided id, based on the human readable input provided in the request body. This is a premium feature.
generate_formula_with_ai 1 param body → 200400404
POST
/api/database/formula/{table_id}/type/
Calculates and returns the type of the specified formula value. Does not change the state of the field in any way.
type_formula_field 1 param body → 200400404

Schemas 145

The contract defines 145 schemas that model the data the API accepts and returns. The most detailed are LookupFieldFieldSerializerWithRelatedFields (36 properties), RollupFieldFieldSerializerWithRelatedFields (35 properties), LookupFieldField (35 properties), RollupFieldField (34 properties). Each schema is shown below with its type and property counts.

NullEnum
PhoneNumberFieldField
object
14 properties 11 required
SingleSelectFieldCreateField
object
7 properties 2 required
FileFieldUpdateField
object
5 properties
GenerateFormulaWithAIRequest
object
4 properties 3 required
FieldField
DateTimeFormatEnum
string
24 - 24 hour 12 - 12 hour
BooleanFieldUpdateField
object
6 properties
BooleanFieldCreateField
object
6 properties 2 required
FormulaFieldFieldSerializerWithRelatedFields
object
33 properties 18 required
TypeFormulaRequest
object
2 properties 2 required
UUIDFieldField
object
14 properties 11 required
GenerateFormulaWithAIResponse
object
1 property 1 required
GenerateAIValuesJobTypeResponse
object
12 properties 8 required
LastModifiedFieldFieldSerializerWithRelatedFields
object
20 properties 11 required
ArrayFormulaTypeEnum
string
invalid - invalid text - text char - char button - button link - link dateinterval - dateinterval duration - duration date - date boolean - boolean number - nu…
RatingFieldFieldSerializerWithRelatedFields
object
18 properties 12 required
FormulaFieldCreateField
object
20 properties 5 required
AutonumberFieldUpdateField
object
6 properties
EmailFieldFieldSerializerWithRelatedFields
object
15 properties 12 required
CreatedByFieldFieldSerializerWithRelatedFields
object
16 properties 13 required
LastModifiedByFieldUpdateField
object
5 properties
LookupFieldFieldSerializerWithRelatedFields
object
36 properties 17 required
MultipleCollaboratorsFieldField
object
16 properties 12 required
RelatedFields
object
1 property 1 required
LookupFieldCreateField
object
23 properties 4 required
CreatedOnFieldFieldSerializerWithRelatedFields
object
20 properties 11 required
SingleSelectFieldUpdateField
object
7 properties
PatchedFieldUpdateField
RollupFieldFieldSerializerWithRelatedFields
object
35 properties 16 required
LongTextFieldField
object
15 properties 11 required
AIFieldField
object
22 properties 11 required
AIFieldFieldSerializerWithRelatedFields
object
23 properties 12 required
SingleSelectFieldField
object
16 properties 11 required
CreatedOnFieldField
object
19 properties 11 required
FormulaFieldUpdateField
object
20 properties 3 required
LongTextFieldCreateField
object
6 properties 2 required
PhoneNumberFieldUpdateField
object
5 properties
MultipleCollaboratorsFieldUpdateField
object
6 properties
LookupFieldUpdateField
object
23 properties 2 required
CreatedByFieldUpdateField
object
5 properties
UUIDFieldFieldSerializerWithRelatedFields
object
15 properties 12 required
RatingFieldUpdateField
object
8 properties
MultipleSelectFieldUpdateField
object
7 properties
StyleEnum
string
star - Star heart - Heart thumbs-up - Thumbs Up flag - Flag smile - Smile
UUIDFieldCreateField
object
5 properties 2 required
FormViewEditRowFieldUpdateField
object
6 properties
FieldConstraint
object
1 property 1 required
LastModifiedFieldCreateField
object
11 properties 1 required
PhoneNumberFieldFieldSerializerWithRelatedFields
object
15 properties 12 required
EmailFieldField
object
14 properties 11 required
RollupFieldCreateField
object
22 properties 3 required
CountFieldUpdateField
object
20 properties 1 required
MultipleSelectFieldField
object
16 properties 11 required
FormViewEditRowFieldCreateField
object
6 properties 2 required
LinkRowFieldUpdateField
object
10 properties
PasswordFieldFieldSerializerWithRelatedFields
object
16 properties 12 required
RollupFieldUpdateField
object
22 properties 1 required
PasswordFieldAuthenticationResponse
object
1 property 1 required
EmailFieldUpdateField
object
5 properties
NumberFieldUpdateField
object
11 properties
TextFieldField
object
15 properties 11 required
NumberFieldFieldSerializerWithRelatedFields
object
21 properties 12 required
URLFieldUpdateField
object
5 properties
Field
object
14 properties 11 required
PasswordFieldCreateField
object
6 properties 2 required
LastModifiedByFieldCreateField
object
5 properties 2 required
NumberSeparatorEnum
string
- No formatting SPACECOMMA - Space, comma SPACEPERIOD - Space, period COMMAPERIOD - Comma, period PERIODCOMMA - Period, comma
TextFieldCreateField
object
6 properties 2 required
PhoneNumberFieldCreateField
object
5 properties 2 required
NumberFieldField
object
20 properties 11 required
SelectOption
object
3 properties 2 required
TextFieldFieldSerializerWithRelatedFields
object
16 properties 12 required
SingleSelectFieldFieldSerializerWithRelatedFields
object
17 properties 12 required
TypeC3eEnum
string
text - text longtext - longtext url - url email - email number - number rating - rating boolean - boolean date - date lastmodified - lastmodified lastmodifiedb…
FileFieldField
object
14 properties 11 required
LastModifiedFieldField
object
19 properties 11 required
RatingFieldField
object
17 properties 11 required
DurationFormatEnum
string
h:mm - hours:minutes h:mm:ss - hours:minutes:seconds h:mm:ss.s - hours:minutes:seconds:deciseconds h:mm:ss.ss - hours:minutes:seconds:centiseconds h:mm:ss.sss…
UniqueRowValues
object
1 property 1 required
URLFieldFieldSerializerWithRelatedFields
object
15 properties 12 required
DurationFieldCreateField
object
6 properties 2 required
AutonumberFieldFieldSerializerWithRelatedFields
object
15 properties 12 required
AiOutputTypeE9fEnum
string
text - text choice - choice
CountFieldField
object
29 properties 12 required
EmailFieldCreateField
object
5 properties 2 required
LastModifiedFieldUpdateField
object
11 properties
LongTextFieldUpdateField
object
6 properties
DateFieldUpdateField
object
11 properties
DurationFieldFieldSerializerWithRelatedFields
object
16 properties 12 required
CreatedOnFieldUpdateField
object
11 properties
DateFieldFieldSerializerWithRelatedFields
object
20 properties 11 required
RollupFieldField
object
34 properties 15 required
URLFieldCreateField
object
5 properties 2 required
DateFieldCreateField
object
11 properties 1 required
DateFormatEnum
string
EU - European (D/M/Y) US - US (M/D/Y) ISO - ISO (Y-M-D)
LongTextFieldFieldSerializerWithRelatedFields
object
16 properties 12 required
ChangePrimaryFieldParams
object
1 property 1 required
NumberFieldCreateField
object
11 properties 2 required
LinkRowFieldField
object
21 properties 14 required
LastModifiedByFieldFieldSerializerWithRelatedFields
object
16 properties 13 required
FieldSerializerWithRelatedFields
object
15 properties 12 required
URLFieldField
object
14 properties 11 required
CreatedOnFieldCreateField
object
11 properties 1 required
CountFieldFieldSerializerWithRelatedFields
object
30 properties 13 required
FormulaFieldField
object
32 properties 17 required
GenerateAIFieldValueView
object
1 property 1 required
AutonumberFieldCreateField
object
6 properties 2 required
DurationFieldField
object
15 properties 11 required
AutonumberFieldField
object
14 properties 11 required
TextFieldUpdateField
object
6 properties
CreatedByFieldCreateField
object
5 properties 2 required
BooleanFieldFieldSerializerWithRelatedFields
object
16 properties 12 required
FieldFieldSerializerWithRelatedFields
MultipleCollaboratorsFieldCreateField
object
6 properties 2 required
FormViewEditRowFieldFieldSerializerWithRelatedFields
object
16 properties 12 required
RatingFieldCreateField
object
8 properties 2 required
BooleanFieldField
object
15 properties 11 required
PasswordFieldAuthentication
object
3 properties 3 required
FormViewEditRowFieldField
object
15 properties 11 required
PasswordFieldUpdateField
object
6 properties
FormulaTypeEnum
string
invalid - invalid text - text char - char button - button link - link dateinterval - dateinterval duration - duration date - date boolean - boolean number - nu…
LookupFieldField
object
35 properties 16 required
MultipleSelectFieldFieldSerializerWithRelatedFields
object
17 properties 12 required
FieldCreateField
DurationFieldUpdateField
object
6 properties
LinkRowFieldCreateField
object
10 properties 2 required
DuplicateFieldJobTypeResponse
object
9 properties 8 required
AIFieldUpdateField
object
13 properties
AIFieldCreateField
object
13 properties 2 required
PasswordFieldField
object
15 properties 11 required
TypeFormulaResult
object
15 properties 2 required
MultipleCollaboratorsFieldFieldSerializerWithRelatedFields
object
17 properties 13 required
Collaborator
object
2 properties 2 required
BlankEnum
UUIDFieldUpdateField
object
5 properties
CreatedByFieldField
object
15 properties 12 required
LinkRowFieldFieldSerializerWithRelatedFields
object
22 properties 15 required
NumberDecimalPlacesEnum
integer
0 - 1 1 - 1.0 2 - 1.00 3 - 1.000 4 - 1.0000 5 - 1.00000 6 - 1.000000 7 - 1.0000000 8 - 1.00000000 9 - 1.000000000 10 - 1.0000000000
CountFieldCreateField
object
20 properties 3 required
DateFieldField
object
19 properties 11 required
FileFieldFieldSerializerWithRelatedFields
object
15 properties 12 required
LastModifiedByFieldField
object
15 properties 12 required
MultipleSelectFieldCreateField
object
7 properties 2 required
FileFieldCreateField
object
5 properties 2 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

baserow-database-table-fields-api-openapi.yml Raw ↑

Other APIs Baserow publishes across the network.

Baserow Admin API
AE Profile APIs.io
Baserow Admin data scanner API
AE Profile APIs.io
Baserow AI Assistant API
AE Profile APIs.io
Baserow Applications API
AE Profile APIs.io
Baserow Audit log API
AE Profile APIs.io
Baserow Auth API
AE Profile APIs.io
Baserow Automation history API
AE Profile APIs.io
Baserow Automation nodes API
AE Profile APIs.io
Baserow Automation workflows API
AE Profile APIs.io
Baserow Builder data sources API
AE Profile APIs.io
Baserow Builder domains API
AE Profile APIs.io
Baserow Builder elements API
AE Profile APIs.io
#Database table fields
← Back to B APIs
API Details
ID
baserow:baserow-database-table-fields-api
Base URL
https://api.baserow.io
Docs
https://baserow.io/docs/apis/rest-api
Provider
Baserow
APIs.io →  GitHub →
Explore more
All APIs Providers APIs.io Network
Work with this as data

Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.

Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.

MCP tools for apis
4 tools reach this content
  • search_api_evangelistSearch every content type across the network at once.
  • find_relatedThe shared-tag relevance graph — what else covers this.
  • get_tagEverything one tag labels, across all content types.
  • guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
All tools & prompts
Call it yourself
curl for this page
Search the network for this 
curl "https://api.apievangelist.com/v1/search?q=baserow-database-table-fields-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/baserow-database-table-fields-api"

Discovery needs no key. Full bodies and the synthesis endpoints are Pro.

Get an API key

Free tier, no email required. Sign in with whichever identity you already have.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have. Your account

Where this information came from

This is an independent, third-party profile of Baserow Database table fields API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.