Query Notion Database
n8n-nodes-base.httpRequest
Query pages from a Notion database with optional filters and sorting. Returns matching pages with their properties.
💡 Use Cases
- Query tasks from a project database
- Filter database entries by status or date
- Retrieve paginated results from large databases
- Search for specific records with complex filters
📚 API Documentation
Reference documentation for this API endpoint:
🔗 https://developers.notion.com/reference/post-database-query ↗📋 Node Configuration
{
"nodes": [
{
"parameters": {
"content": "## 📝 Query Notion Database\n\n**Usage:**\nQuery pages from a Notion database with optional filters and sorting.\n\n**Required Input:**\n- `database_id`: The ID of the Notion database to query\n\n**Optional Fields:**\n- `filter`: Filter object to narrow results\n- `sorts`: Array of sort criteria\n- `page_size`: Number of results (max 100)\n- `start_cursor`: Pagination cursor\n\n**Setup:**\n1. Create a Notion integration at notion.so/my-integrations\n2. Share your database with the integration\n3. Configure HTTP Header Auth with your API key\n4. Pass the database ID in the URL\n\n**Output:**\nReturns a list of pages matching the query with their properties.",
"height": 238,
"width": 389,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
332
],
"typeVersion": 1,
"id": "notion-query-db-sticky",
"name": "Sticky Note"
},
{
"parameters": {
"method": "POST",
"url": "=https://api.notion.com/v1/databases/{{ $json.database_id }}/query",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Notion-Version",
"value": "2022-06-28"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"page_size\": {{ $json.page_size || 100 }}\n {{ $json.filter ? ', \"filter\": ' + JSON.stringify($json.filter) : '' }}\n {{ $json.sorts ? ', \"sorts\": ' + JSON.stringify($json.sorts) : '' }}\n {{ $json.start_cursor ? ', \"start_cursor\": \"' + $json.start_cursor + '\"' : '' }}\n}",
"options": {}
},
"id": "notion-query-db-node",
"name": "Query Notion Database",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.1,
"position": [
368,
400
],
"credentials": {
"httpHeaderAuth": {
"id": "notion-auth",
"name": "Notion API Key"
}
}
}
],
"connections": {},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "notion-query-database-template"
}
}
[
{
"id": "56769553-7d4e-44c6-8ec4-bf641987cfa8",
"meta": {
"name": "API Call Node",
"id": "api-call",
"icon": {
"svg": "
{
"subflows": [
{
"flow": [
{
"id": 738,
"module": "http:ActionSendDataBasicAuth",
"version": 3,
"parameters": {
"key": "ANONYMIZED_CREDENTIALS",
"handleErrors": false,
"useNewZLibDeCompress": true
},
"mapper": {
"ca": "",
"qs": [],
"url": "https://api.notion.com/v1/databases/{{1.database_id}}/query",
"data": "{\n \"page_size\": {{ $json.page_size || 100 }}\n {{ $json.filter ? ', \"filter\": ' + JSON.stringify($json.filter) : '' }}\n {{ $json.sorts ? ', \"sorts\": ' + JSON.stringify($json.sorts) : '' }}\n {{ $json.start_cursor ? ', \"start_cursor\": \"' + $json.start_cursor + '\"' : '' }}\n}",
"gzip": true,
"method": "post",
"headers": [
{
"name": "Notion-Version",
"value": "2022-06-28"
},
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "Authorization",
"value": "Bearer {{ANONYMIZED_TOKEN}}"
}
],
"timeout": "",
"useMtls": false,
"bodyType": "raw",
"contentType": "application/json",
"serializeUrl": false,
"shareCookies": false,
"parseResponse": true,
"followRedirect": true,
"useQuerystring": false,
"followAllRedirects": false,
"rejectUnauthorized": true
},
"metadata": {
"designer": {
"x": 300,
"y": 300,
"name": "Query Notion Database"
},
"restore": {
"expect": {
"qs": {
"mode": "chose",
"items": []
},
"method": {
"mode": "chose",
"label": "POST"
},
"headers": {
"mode": "chose",
"items": [
null,
null,
null
]
},
"bodyType": {
"label": "Raw"
},
"contentType": {
"label": "JSON (application/json)"
}
},
"parameters": {
"key": {
"label": "ANONYMIZED_CREDENTIALS"
}
}
},
"parameters": [
{
"name": "key",
"type": "keychain:basicauth",
"label": "Credentials",
"required": true
},
{
"name": "handleErrors",
"type": "boolean",
"label": "Evaluate all states as errors (except for 2xx and 3xx )",
"required": true
},
{
"name": "useNewZLibDeCompress",
"type": "hidden"
}
],
"expect": [
{
"name": "url",
"type": "url",
"label": "URL",
"required": true
},
{
"name": "serializeUrl",
"type": "boolean",
"label": "Serialize URL",
"required": true
},
{
"name": "method",
"type": "select",
"label": "Method",
"required": true,
"validate": {
"enum": [
"get",
"head",
"post",
"put",
"patch",
"delete",
"options"
]
}
},
{
"name": "headers",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Headers"
},
{
"name": "qs",
"spec": [
{
"name": "name",
"type": "text",
"label": "Name",
"required": true
},
{
"name": "value",
"type": "text",
"label": "Value"
}
],
"type": "array",
"label": "Query String"
},
{
"name": "bodyType",
"type": "select",
"label": "Body type",
"validate": {
"enum": [
"raw",
"x_www_form_urlencoded",
"multipart_form_data"
]
}
},
{
"name": "parseResponse",
"type": "boolean",
"label": "Parse response",
"required": true
},
{
"name": "contentType",
"type": "select",
"label": "Content type",
"validate": {
"enum": [
"text/plain",
"application/json",
"application/xml",
"text/xml",
"text/html",
"custom"
]
}
},
{
"name": "data",
"type": "buffer",
"label": "Request content"
}
]
}
}
]
}
],
"metadata": {
"version": 1
}
}