Menu
Update A Database
Update a database
PATCH
/v1/databases/{id}Use it in a workflow
- Add a step and choose the Notion connector.
- Pick the Update A Database action (under Databases).
- Fill in the fields below, then reference the result from later steps as
{{updateADatabase.response.data}}.
Request
Path parameters
Headers
Request body
Enter the body as JSON in the step's Body field.
{
"properties": {
"Wine Pairing": {
"rich_text": {}
}
},
"title": [
{
"text": {
"content": "Ever Better Reading List Title"
}
}
]
}
Response
Returns 200 with an object. Read it in later steps with {{updateADatabase.response.data.<field>}}.
{
"archived": false,
"cover": null,
"created_by": {
"id": "6794760a-1f15-45cd-9c65-0dfe42f5135a",
"object": "user"
},
"created_time": {},
"icon": null,
"id": "8e2c2b76-9e1d-47d2-87b9-ed3035d607ae",
"last_edited_by": {
"id": "92a680bb-6970-4726-952b-4f4c03bff617",
"object": "user"
},
"last_edited_time": {},
"object": "database",
"parent": {
"page_id": "c4d39556-6364-46a1-8a61-ebbb668f7445",
"type": "page_id"
},
"properties": {
"Author": {
"id": "qNw_",
"multi_select": {
"options": [
{
"color": "default",
"id": "15592971-7b30-43d5-9406-2eb69b13fcae",
"name": "Spencer Greenberg"
},
{
"color": "default",
"id": "b80a988e-dccf-4f74-b764-6ca0e49ed1b8",
"name": "Seth Stephens-Davidowitz"
},
{
"color": "default",
"id": "0e71ee06-199d-46a4-834c-01084c8f76cb",
"name": "Andrew Russell"
},
{
"color": "default",
"id": "5807ec38-4879-4455-9f30-5352e90e8b79",
"name": "Lee Vinsel"
},
{
"color": "default",
"id": "4cf10a64-f3da-449c-8e04-ce6e338bbdbd",
"name": "Megan Greenwell"
},
{
"color": "default",
"id": "833e2c78-35ed-4601-badc-50c323341d76",
"name": "Kara Swisher"
},
{
"color": "default",
"id": "82e594e2-b1c5-4271-ac19-1a723a94a533",
"name": "Paul Romer"
},
{
"color": "default",
"id": "ae3a2cbe-1fc9-4376-be35-331628b34623",
"name": "Karen Swallow Prior"
},
{
"color": "default",
"id": "da068e78-dfe2-4434-9fd7-b7450b3e5830",
"name": "Judith Shulevitz"
}
]
},
"name": "Author",
"type": "multi_select"
},
"Link": {
"id": "VVMi",
"name": "Link",
"type": "url",
"url": {}
},
"Name": {
"id": "title",
"name": "Name",
"title": {},
"type": "title"
},
"Publisher": {
"id": ">$Pb",
"name": "Publisher",
"select": {
"options": [
{
"color": "default",
"id": "c5ee409a-f307-4176-99ee-6e424fa89afa",
"name": "NYT"
},
{
"color": "blue",
"id": "1b9b0c0c-17b0-4292-ad12-1364a51849de",
"name": "Netflix"
},
{
"color": "brown",
"id": "f3533637-278f-4501-b394-d9753bf3c101",
"name": "Indie"
},
{
"color": "yellow",
"id": "e70d713c-4be4-4b40-a44d-fb413c8b9d7e",
"name": "Bon Appetit"
},
{
"color": "pink",
"id": "9c2bd667-0a10-4be4-a044-35a537a14ab9",
"name": "Franklin Institute"
},
{
"color": "orange",
"id": "6849b5f0-e641-4ec5-83cb-1ffe23011060",
"name": "Springer"
},
{
"color": "gray",
"id": "6a5bff63-a72d-4464-a5d0-1a601af2adf6",
"name": "Emerald Group"
},
{
"color": "red",
"id": "01f82d08-aa1f-4884-a4e0-3bc32f909ec4",
"name": "The Atlantic"
}
]
},
"type": "select"
},
"Publishing/Release Date": {
"date": {},
"id": "?ex+",
"name": "Publishing/Release Date",
"type": "date"
},
"Read": {
"checkbox": {},
"id": "_MWJ",
"name": "Read",
"type": "checkbox"
},
"Score /5": {
"id": ")Y7\"",
"name": "Score /5",
"select": {
"options": [
{
"color": "default",
"id": "5c944de7-3f4b-4567-b3a1-fa2c71c540b6",
"name": "⭐️⭐️⭐️⭐️⭐️"
},
{
"color": "default",
"id": "b7307e35-c80a-4cb5-bb6b-6054523b394a",
"name": "⭐️⭐️⭐️⭐️"
},
{
"color": "default",
"id": "9b1e1349-8e24-40ba-bbca-84a61296bc81",
"name": "⭐️⭐️⭐️"
},
{
"color": "default",
"id": "66d3d050-086c-4a91-8c56-d55dc67e7789",
"name": "⭐️⭐️"
},
{
"color": "default",
"id": "d3782c76-0396-467f-928e-46bf0c9d5fba",
"name": "⭐️"
}
]
},
"type": "select"
},
"Status": {
"id": "`zz5",
"name": "Status",
"select": {
"options": [
{
"color": "yellow",
"id": "8c4a056e-6709-4dd1-ba58-d34d9480855a",
"name": "Ready to Start"
},
{
"color": "red",
"id": "5925ba22-0126-4b58-90c7-b8bbb2c3c895",
"name": "Reading"
},
{
"color": "blue",
"id": "59aa9043-07b4-4bf4-8734-3164b13af44a",
"name": "Finished"
},
{
"color": "red",
"id": "f961978d-02eb-4998-933a-33c2ec378564",
"name": "Listening"
},
{
"color": "red",
"id": "1d450853-b27a-45e2-979f-448aa1bd35de",
"name": "Watching"
}
]
},
"type": "select"
},
"Summary": {
"id": "?\\25",
"name": "Summary",
"rich_text": {},
"type": "rich_text"
},
"Type": {
"id": "/7eo",
"name": "Type",
"select": {
"options": [
{
"color": "default",
"id": "f96d0d0a-5564-4a20-ab15-5f040d49759e",
"name": "Article"
},
{
"color": "default",
"id": "4ac85597-5db1-4e0a-9c02-445575c38f76",
"name": "TV Series"
},
{
"color": "default",
"id": "2991748a-5745-4c3b-9c9b-2d6846a6fa1f",
"name": "Film"
},
{
"color": "default",
"id": "82f3bace-be25-410d-87fe-561c9c22492f",
"name": "Podcast"
},
{
"color": "default",
"id": "861f1076-1cc4-429a-a781-54947d727a4a",
"name": "Academic Journal"
},
{
"color": "default",
"id": "9cc30548-59d6-4cd3-94bc-d234081525c4",
"name": "Essay Resource"
}
]
},
"type": "select"
},
"Wine Pairing": {
"id": "Y=H]",
"name": "Wine Pairing",
"rich_text": {},
"type": "rich_text"
}
},
"title": [
{
"annotations": {
"bold": false,
"code": false,
"color": "default",
"italic": false,
"strikethrough": false,
"underline": false
},
"href": null,
"plain_text": "Ever Better Reading List Title",
"text": {
"content": "Ever Better Reading List Title",
"link": null
},
"type": "text"
}
]
}
Need more? See the Notion guide for connection setup and behaviour shared by every action.
Was this page helpful?