Notion API - Public Beta (English)
  1. Databases
Notion API - Public Beta (English)
  • Introduction
  • Integration capabilities
  • Request limits
  • Status codes
  • ENDPOINTS
    • Authentication
      • Authentication
      • Token
    • Blocks
      • Delete a block
      • Append block children
      • Retrieve a block
      • Update a block
      • Retrieve block children
    • Databases
      • Filter database entries
      • Sort database entries
      • Update database properties
      • Retrieve a database
        GET
      • Update a database
        PATCH
      • Query a database
        POST
    • Pages
      • Archive a page
      • Retrieve a page property item
      • Create a page
      • Retrieve a Page
      • Update Page properties
    • Users
      • List all users
      • Retrieve your token's bot user
      • Retrieve a user
    • Comments
      • Create comment
      • Retrieve comments
    • Search
      • Search optimizations and limitations
      • Search by title
  • OBJECTS
    • Block
    • Comment
    • Unfurl attribute object for Link Previews
    • Page
      • Page
      • Page properties
    • Database
      • Database
      • Database properties
    • User
      • User
      • Comment
    • Other
      • Emoji object
      • File object
      • Parent object
      • Rich text object
  • Versioning
    • Versioning
    • Changes by version
  • ENDPOINTS Copy
    • Authentication
      • Authentication
      • Token
    • Blocks
      • Retrieve a block
      • Update a block
      • Retrieve block children
      • Delete a block
      • Append block children
    • Databases
      • Filter database entries
      • Sort database entries
      • Update database properties
      • Retrieve a database
      • Update a database
      • Query a database
      • Create a database
    • Pages
      • Archive a page
      • Retrieve a Page
      • Update Page properties
      • Retrieve a page property item
      • Create a page
    • Users
      • Retrieve a user
      • List all users
      • Retrieve your token's bot user
    • Comments
      • Create comment
      • Retrieve comments
  1. Databases

Update a database

PATCH
/v1/databases/{id}
Databases
Update a database
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request PATCH '/v1/databases/' \
--header 'Content-Type: application/json' \
--data-raw '{
    "properties": {
        "Wine Pairing": {
            "rich_text": {}
        }
    },
    "title": [
        {
            "text": {
                "content": "Ever Better Reading List Title"
            }
        }
    ]
}'
Response Response Example
{
  "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"
    }
  ]
}

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
Examples

Responses

🟢200200 Success - Update a database
application/json
Body
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
Modified at 2023-04-27 10:02:23
Previous
Retrieve a database
Next
Query a database
Built with