Update a database
PATCH
/v1/databases/{id}Update a database
Request
Path Params
id
string
required
Body Params application/json
properties
object
optional
Wine Pairing
object
optional
title
array [object {1}]
optional
text
object
optional
Example
{
"properties": {
"Wine Pairing": {
"rich_text": {}
}
},
"title": [
{
"text": {
"content": "Ever Better Reading List Title"
}
}
]
}
Request samples
Responses
200 Success - Update a database(200)
200 Success - Update a database
HTTP Code: 200
Content Type : JSONapplication/json
Data Schema
created_time
string
optional
Example:
2021-05-14T18:22:00.000Z
id
string
optional
Example:
7a94f22f-59ae-484d-90ac-4aeddd667641
last_edited_time
string
optional
Example:
2021-08-13T23:40:00.000Z
object
string
optional
Example:
database
parent
object
optional
page_id
string
optional
Example:
10941704-8885-4be3-83c9-bb918b171bb6
type
string
optional
Example:
page_id
properties
object
optional
Author
object
optional
Link
object
optional
Name
object
optional
Publisher
object
optional
Publishing/Release Date
object
optional
Read
object
optional
Score /5
object
optional
Status
object
optional
Summary
object
optional
Type
object
optional
Wine Pairing
object
optional
date
object
optional
title
array [object {5}]
optional
annotations
object
optional
href
null
optional
Example:
null
plain_text
string
optional
Example:
Ever Better Reading List Title
text
object
optional
type
string
optional
Example:
text
Example200 Success - Update a database
{
"created_time": "2021-05-14T18:22:00.000Z",
"id": "7a94f22f-59ae-484d-90ac-4aeddd667641",
"last_edited_time": "2021-08-13T23:40:00.000Z",
"object": "database",
"parent": {
"page_id": "10941704-8885-4be3-83c9-bb918b171bb6",
"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"
},
{
"color": "orange",
"id": "b598e780-263b-4b02-862c-9bf7a91859ac",
"name": "New Option"
},
{
"color": "purple",
"id": "ad038109-97d3-4b5d-a93a-3b88229b1b58",
"name": "New Option 3"
}
]
},
"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": "WO@Z",
"name": "Wine Pairing",
"rich_text": {},
"type": "rich_text"
},
"date": {
"date": {},
"id": "Lpwp",
"name": "date",
"type": "date"
}
},
"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"
}
]
}
Last modified: 2 years ago