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