Query a database.

External Documentation

To learn more, visit the Notion documentation.

Parameters

ParameterDescription
Database IDThe 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 PropertyThe name or ID of a property to filter by.Using this parameter together with Select Equals will return only database entries where the specified property value is identical to this string.
Select EqualsA string value to match exactly against the selected property.Using this parameter together with Filter Property will return only database entries where the specified property value is identical to this string.

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