Retrieve a database
GET
/v1/databases/{id}Retrieves a database object using the ID specified in the request path.
Request
Path Params
id
string
required
Request samples
Responses
200 Success - Retrieve a database(200)
200 Success - Retrieve a database
HTTP Code: 200
Content Type : JSONapplication/json
Data Schema
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
Example200 Success - Retrieve a database
{
"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"
}
]
}
Last modified: 2 years ago