Menu
Query A Database
Query a database
POST
/v1/databases/{id}/queryUse it in a workflow
- Add a step and choose the Notion connector.
- Pick the Query A Database action (under Databases).
- Fill in the fields below, then reference the result from later steps as
{{queryADatabase.response.data}}.
Request
Path parameters
Headers
Request body
Enter the body as JSON in the step's Body field.
{
"filter": {
"property": "Status",
"select": {
"equals": "Reading"
}
}
}
Response
Returns 200 with an object. Read it in later steps with {{queryADatabase.response.data.<field>}}.
{
"has_more": false,
"next_cursor": null,
"object": "list",
"results": [
{
"archived": false,
"cover": null,
"created_by": {
"id": "6794760a-1f15-45cd-9c65-0dfe42f5135a",
"object": "user"
},
"created_time": {},
"icon": null,
"id": "557ef501-bfdb-4586-918e-4434f31bca8c",
"last_edited_by": {
"id": "6794760a-1f15-45cd-9c65-0dfe42f5135a",
"object": "user"
},
"last_edited_time": {},
"object": "page",
"parent": {
"database_id": "8e2c2b76-9e1d-47d2-87b9-ed3035d607ae",
"type": "database_id"
},
"properties": {
"Author": {
"id": "qNw_",
"multi_select": [
{
"color": "default",
"id": "ae3a2cbe-1fc9-4376-be35-331628b34623",
"name": "Karen Swallow Prior"
}
],
"type": "multi_select"
},
"Link": {
"id": "VVMi",
"type": "url",
"url": "https://www.theatlantic.com/entertainment/archive/2016/03/how-jane-eyre-created-the-modern-self/460461/"
},
"Name": {
"id": "title",
"title": [
{
"annotations": {
"bold": false,
"code": false,
"color": "default",
"italic": true,
"strikethrough": false,
"underline": false
},
"href": null,
"plain_text": "Jane Eyre",
"text": {
"content": "Jane Eyre",
"link": null
},
"type": "text"
},
{
"annotations": {
"bold": false,
"code": false,
"color": "default",
"italic": false,
"strikethrough": false,
"underline": false
},
"href": null,
"plain_text": " and the Invention of Self",
"text": {
"content": " and the Invention of Self",
"link": null
},
"type": "text"
}
],
"type": "title"
},
"Publisher": {
"id": "%3E%24Pb",
"select": {
"color": "red",
"id": "01f82d08-aa1f-4884-a4e0-3bc32f909ec4",
"name": "The Atlantic"
},
"type": "select"
},
"Publishing/Release Date": {
"date": {
"end": null,
"start": {},
"time_zone": null
},
"id": "%3Fex%2B",
"type": "date"
},
"Read": {
"checkbox": false,
"id": "_MWJ",
"type": "checkbox"
},
"Score /5": {
"id": ")Y7%22",
"select": {
"color": "default",
"id": "66d3d050-086c-4a91-8c56-d55dc67e7789",
"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": [],
"type": "rich_text"
},
"Type": {
"id": "%2F7eo",
"select": {
"color": "default",
"id": "9cc30548-59d6-4cd3-94bc-d234081525c4",
"name": "Essay Resource"
},
"type": "select"
}
},
"url": "https://www.notion.so/Jane-Eyre-and-the-Invention-of-Self-557ef501bfdb4586918e4434f31bca8c"
},
{
"archived": false,
"cover": null,
"created_by": {
"id": "6794760a-1f15-45cd-9c65-0dfe42f5135a",
"object": "user"
},
"created_time": {},
"icon": null,
"id": "a1712d54-53e4-4893-a69d-4d581cd2c845",
"last_edited_by": {
"id": "92a680bb-6970-4726-952b-4f4c03bff617",
"object": "user"
},
"last_edited_time": {},
"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": {},
"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"
}
]
}
Need more? See the Notion guide for connection setup and behaviour shared by every action.
Was this page helpful?