Query Database
Query a database.
External Documentation
To learn more, visit the Notion documentation.
Parameters
| Parameter | Description |
|---|---|
| Database ID | The ID of the database you want to query.Note: Only databases with titles will appear in the autofill. If the relevant database name does not appear, manually add it's ID instead.The ID can be found in the suffix of the database's web link, e.g. the database in link https://www.notion.so/d132f3904fbc45329chjc7b1d52661e5 will have the id d132f3904fbc45329chjc7b1d52661e5. |
| Filter Property | - |
| Select Equals | - |
Example Output
{
"has_more": false,
"next_cursor": "string",
"object": "string",
"results": [
{
"archived": false,
"cover": null,
"created_by": {
"id": "6794760a-1f15-45cd-9c65-0dfe42f5135a",
"object": "user"
},
"created_time": "2021-04-27T20:38:00.000Z",
"icon": null,
"id": "a1712d54-53e4-4893-a69d-4d581cd2c845",
"last_edited_by": {
"id": "92a680bb-6970-4726-952b-4f4c03bff617",
"object": "user"
},
"last_edited_time": "2021-05-12T06:07:00.000Z",
"object": "page",
"parent": {
"database_id": "8e2c2b76-9e1d-47d2-87b9-ed3035d607ae",
"type": "database_id"
},
"properties": {
"Author": {
"id": "qNw_",
"multi_select": [
{
"color": "default",
"id": "833e2c78-35ed-4601-badc-50c323341d76",
"name": "Kara Swisher"
}
],
"type": "multi_select"
},
"Link": {
"id": "VVMi",
"type": "url",
"url": "https://www.nytimes.com/2018/10/21/opinion/who-will-teach-silicon-valley-to-be-ethical.html"
},
"Name": {
"id": "title",
"title": [
{
"annotations": {
"bold": false,
"code": false,
"color": "default",
"italic": false,
"strikethrough": false,
"underline": false
},
"href": null,
"plain_text": "Who Will Teach Silicon Valley to Be Ethical? ",
"text": {
"content": "Who Will Teach Silicon Valley to Be Ethical? ",
"link": null
},
"type": "text"
}
],
"type": "title"
},
"Publisher": {
"id": "%3E%24Pb",
"select": {
"color": "default",
"id": "c5ee409a-f307-4176-99ee-6e424fa89afa",
"name": "NYT"
},
"type": "select"
},
"Publishing/Release Date": {
"date": {
"end": null,
"start": "2018-10-21",
"time_zone": null
},
"id": "%3Fex%2B",
"type": "date"
},
"Read": {
"checkbox": true,
"id": "_MWJ",
"type": "checkbox"
},
"Score /5": {
"id": ")Y7%22",
"select": {
"color": "default",
"id": "b7307e35-c80a-4cb5-bb6b-6054523b394a",
"name": "⭐️⭐️⭐️⭐️"
},
"type": "select"
},
"Status": {
"id": "%60zz5",
"select": {
"color": "red",
"id": "5925ba22-0126-4b58-90c7-b8bbb2c3c895",
"name": "Reading"
},
"type": "select"
},
"Summary": {
"id": "%3F%5C25",
"rich_text": [
{
"annotations": {
"bold": false,
"code": false,
"color": "default",
"italic": false,
"strikethrough": false,
"underline": false
},
"href": null,
"plain_text": "Some think chief ethics officers could help technology companies navigate political and social questions.",
"text": {
"content": "Some think chief ethics officers could help technology companies navigate political and social questions.",
"link": null
},
"type": "text"
}
],
"type": "rich_text"
},
"Type": {
"id": "%2F7eo",
"select": {
"color": "default",
"id": "f96d0d0a-5564-4a20-ab15-5f040d49759e",
"name": "Article"
},
"type": "select"
}
},
"url": "https://www.notion.so/Who-Will-Teach-Silicon-Valley-to-Be-Ethical-a1712d5453e44893a69d4d581cd2c845"
}
]
}
Workflow Library Example
Query Database with Notion and Send Results Via Email
Preview this Workflow on desktop