Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Notion Databases API

Databases are collections of Notion pages organized with a shared schema of properties. Each database defines columns (properties) that all its pages share. Databases support filtering, sorting, and querying. Use these endpoints to create, retrieve, update, and query databases.

Notion Databases API is one of 6 APIs that Notion publishes on the APIs.io network, described by a machine-readable OpenAPI specification and an AsyncAPI event-driven specification.

This API exposes 3 JSON Schema definitions.

Tagged areas include Databases. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an AsyncAPI specification, a JSON-LD context, authentication docs, a getting-started guide, and 3 JSON Schemas.

This API exposes 4 operations across 3 paths, and defines 10 schemas. It is described by OpenAPI 3.1.0, at version 2022-06-28.

Requests are made against a single base URL, https://api.notion.com/v1.

4 operations 3 paths 10 schemas 1 GET1 PATCH2 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.1.0
API Version
2022-06-28
Server
https://api.notion.com/v1
Authentication
HTTP Bearer
Terms of Service
Resource Areas
1

Authentication & Security 1

Notion Databases API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (bearerAuth). By default, every request must be authenticated.

  • bearerAuth — Notion API uses bearer token authentication. Obtain an integration token from https://www.notion.so/my-integrations. Pass the token in the Authorization header…

Paths & Operations 4

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

Databases 4

Databases are collections of Notion pages organized with a shared schema of properties. Each database defines columns (properties) that all its pages share. Databases support filt…

POST
/databases
Notion Create a database
createDatabase 1 param body → 200400401404429
GET
/databases/{database_id}
Notion Retrieve a database
retrieveDatabase 2 params → 200401404429
PATCH
/databases/{database_id}
Notion Update a database
updateDatabase 2 params body → 200400401404429
POST
/databases/{database_id}/query
Notion Query a database
queryDatabase 3 params body → 200400401404429

Schemas 10

The contract defines 10 schemas that model the data the API accepts and returns. The most detailed are Database (17 properties), RichText (7 properties), PaginatedList (6 properties), Parent (5 properties). Each schema is shown below with its type and property counts.

PaginatedList
object
A paginated list of results returned by list and query endpoints. All paginated responses follow the same structure with a results array, pagination info, and…
6 properties 4 required
Emoji
object
An emoji icon object.
2 properties 2 required
Database
object
A Database object represents a database in Notion. Databases are collections of pages that share a common schema of properties. The schema defines the columns…
17 properties 12 required
File
object
A File object represents a file in Notion. Files can be either hosted by Notion (type "file") or externally hosted (type "external").
5 properties 1 required
PropertySchema
object
A Property Schema object defines a database property's configuration including its type and type-specific settings. Common property types include title, richte…
3 properties
RichText
object
A Rich Text object represents styled text content in Notion. Rich text can include annotations like bold, italic, and color, as well as links and mentions of o…
7 properties 2 required
Parent
object
A Parent object represents the parent of a page, database, or block. The parent can be a workspace, page, database, or block.
5 properties 1 required
ExternalFile
object
An external file reference.
2 properties 2 required
PartialUser
object
A partial User object containing only the object type and ID. Used in createdby and lasteditedby fields.
2 properties 2 required
Error
object
An error response from the Notion API.
5 properties 4 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

notion-databases-api-openapi.yml Raw ↑

Other APIs Notion publishes across the network.

Notion Blocks API
Notion Comments API
Notion Pages API
Notion Search API
Notion Users API