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

Retrieve a database

GET
/v1/databases/{id}
Databases
Retrieves a database object using the ID specified in the request path.
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET '/v1/databases/'
Response Response Example
{
  "created_time": "2021-04-27T20:38:19.437Z",
  "id": "8e2c2b76-9e1d-47d2-87b9-ed3035d607ae",
  "last_edited_time": "2021-04-27T21:15:00.000Z",
  "object": "database",
  "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"
          }
        ]
      },
      "type": "multi_select"
    },
    "Link": {
      "id": "VVMi",
      "type": "url",
      "url": {}
    },
    "Name": {
      "id": "title",
      "title": {},
      "type": "title"
    },
    "Publisher": {
      "id": ">$Pb",
      "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+",
      "type": "date"
    },
    "Read": {
      "checkbox": {},
      "id": "_MWJ",
      "type": "checkbox"
    },
    "Score /5": {
      "id": ")Y7\"",
      "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",
      "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",
      "text": {},
      "type": "text"
    },
    "Type": {
      "id": "/7eo",
      "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"
    }
  },
  "title": [
    {
      "annotations": {
        "bold": false,
        "code": false,
        "color": "default",
        "italic": false,
        "strikethrough": false,
        "underline": false
      },
      "href": null,
      "plain_text": "Media",
      "text": {
        "content": "Media",
        "link": null
      },
      "type": "text"
    }
  ]
}

Request

Path Params
id
string 
required

Responses

🟢200200 Success - Retrieve a database
application/json
Body
created_time
string 
optional
Example:
2021-04-27T20:38:19.437Z
id
string 
optional
Example:
8e2c2b76-9e1d-47d2-87b9-ed3035d607ae
last_edited_time
string 
optional
Example:
2021-04-27T21:15:00.000Z
object
string 
optional
Example:
database
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
title
array [object {5}] 
optional
annotations
object 
optional
href
null 
optional
Example:
null
plain_text
string 
optional
Example:
Media
text
object 
optional
type
string 
optional
Example:
text
Modified at 2023-04-27 10:02:23
Previous
Update database properties
Next
Update a database
Built with