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

Baserow Database table fields API

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

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.2.0, 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.2.0
API Version
2.2.2
Base URL
https://api.baserow.io
Authentication
HTTP Bearer, HTTP Bearer, HTTP Bearer
License
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}/
Get database table field
get_database_table_field 1 param → 200400404
PATCH
/api/database/fields/{field_id}/
Update database table field
update_database_table_field 3 params body → 200400404
DELETE
/api/database/fields/{field_id}/
Delete database table field
delete_database_table_field 3 params → 200400404
POST
/api/database/fields/{field_id}/duplicate/async/
Duplicate table field
duplicate_table_field 3 params → 202400404
POST
/api/database/fields/{field_id}/generate-ai-field-values/
Generate table ai field value
generate_table_ai_field_value 3 params body → 202400404
GET
/api/database/fields/{field_id}/unique_row_values/
Get database field unique row values
get_database_field_unique_row_values 3 params → 200400404
POST
/api/database/fields/password-authentication/
Password field authentication
password_field_authentication body → 200400401404
GET
/api/database/fields/table/{table_id}/
List database table fields
list_database_table_fields 1 param → 200400401404
POST
/api/database/fields/table/{table_id}/
Create database table field
create_database_table_field 3 params body → 200400401404
POST
/api/database/fields/table/{table_id}/change-primary-field/
Change primary field
change_primary_field 3 params body → 200400404
POST
/api/database/fields/table/{table_id}/generate-ai-formula/
Generate formula with ai
generate_formula_with_ai 1 param body → 200400404
POST
/api/database/formula/{table_id}/type/
Type formula field
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.

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

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
Baserow Admin data scanner API
Baserow AI Assistant API
Baserow Applications API
Baserow Audit log API
Baserow Auth API
Baserow Automation history API
Baserow Automation nodes API
Baserow Automation workflows API
Baserow Builder data sources API
Baserow Builder domains API
Baserow Builder elements API
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.