Notion API, how to retrieve the entries in a database
Here’s how to list all entries in a Notion database using the official Notion API.
First you need to have a reference to the Notion instance
import { Client } from '@notionhq/client'
//...
const notion = new Client({ auth: process.env.NOTION_API_KEY })
Then you can call notion.database.query()
to retrieve the entries.
This retrieves all entries:
const postsReady = await notion.databases.query({
database_id: process.env.NOTION_DB_ID,
})
This retrieves all entries with the checkbox property named “Ready” checked:
const postsReady = await notion.databases.query({
database_id: process.env.NOTION_DB_ID,
filter: {
and: [
{
property: 'Ready',
checkbox: {
equals: true,
},
},
],
},
})
You can do a lot more.
You can add more filtering rules, combining them with or
or and
logic.
You can sort them by a specific property, ascending or descending.
It’s pretty cool.
See the official docs of notion.databases.query()
: https://developers.notion.com/reference/post-database-query
Here is how can I help you:
- COURSES where I teach everything I know
- THE VALLEY OF CODE your web development manual
- BOOTCAMP 2024 cohort in progress, next edition in 2025
- BOOKS 16 coding ebooks you can download for free on JS Python C PHP and lots more
- SOLO LAB everything I know about running a lifestyle business as a solopreneur
- Interesting links collection
- Follow me on X