Skip to content

Sample Database Response

This page contains a sample LoaderPage API response for a Notion database type.

Sample JSON Response

This sample JSON response is for the above Notion database.

Key components

type : Parent database with database_row chidren

url : Direct link to the Notion database and database rows

content : For databases, this is a table (in HTML or Markdown) containing all rows’ cell data. For database rows, it includes both the row’s cell data and any associated page content.

children : For databases, this array contains objects representing each database row. The nesting depth is determined by the depth query parameter in the API request.

{
"type": "database",
"id": "106a7f30-3194-800d-b4ab-ef01d8da0770",
"url": "https://www.notion.so/106a7f303194800db4abef01d8da0770",
"title": "LoaderPage Test Database",
"last_modified": "2024-09-26T05:06:00.000Z",
"conversion_timestamp": "2024-09-27T04:52:29.157716+00:00",
"content": {
"html": "<table><tr><th>Tags</th><th>title_property</th></tr><tr><td></td><td></td></tr><tr><td>LoaderPage, Notion</td><td>Row 2</td></tr><tr><td>LoaderPage</td><td>Row 1</td></tr></table>",
"markdown": "\n\n| Tags | title_property |\n| --- | --- |\n| | |\n| LoaderPage, Notion | Row 2 |\n| LoaderPage | Row 1 |\n\n"
},
"depth": 0,
"parent": {
"type": "workspace",
"parent_id": ""
},
"children": [
{
"type": "database_row",
"id": "5e8b61a5-2977-4e0e-bd43-5ec1fbc3ede9",
"url": "https://www.notion.so/5e8b61a529774e0ebd435ec1fbc3ede9",
"title": "Untitled",
"last_modified": "2024-09-19T07:28:00.000Z",
"conversion_timestamp": "2024-09-27T04:52:29.157716+00:00",
"content": {
"html": "<table><tr><th>Tags</th><th>title_property</th></tr><tr><td></td><td></td></tr></table><br>",
"markdown": "\n\n| Tags | title_property |\n| --- | --- |\n| | |\n\n"
},
"depth": 1,
"parent": {
"type": "database_id",
"parent_id": "106a7f30-3194-800d-b4ab-ef01d8da0770"
},
"children": []
},
{
"type": "database_row",
"id": "6db189aa-ad8b-4969-9fa4-e25bdc51ca34",
"url": "https://www.notion.so/Row-2-6db189aaad8b49699fa4e25bdc51ca34",
"title": "Row 2",
"last_modified": "2024-09-19T07:28:00.000Z",
"conversion_timestamp": "2024-09-27T04:52:29.157716+00:00",
"content": {
"html": "<table><tr><th>Tags</th><th>title_property</th></tr><tr><td>LoaderPage, Notion</td><td>Row 2</td></tr></table><br>",
"markdown": "\n\n| Tags | title_property |\n| --- | --- |\n| LoaderPage, Notion | Row 2 |\n\n"
},
"depth": 1,
"parent": {
"type": "database_id",
"parent_id": "106a7f30-3194-800d-b4ab-ef01d8da0770"
},
"children": []
},
{
"type": "database_row",
"id": "9f1fa368-136e-4e31-95b7-a2aecc5275a9",
"url": "https://www.notion.so/Row-1-9f1fa368136e4e3195b7a2aecc5275a9",
"title": "Row 1",
"last_modified": "2024-09-19T07:29:00.000Z",
"conversion_timestamp": "2024-09-27T04:52:29.157716+00:00",
"content": {
"html": "<table><tr><th>Tags</th><th>title_property</th></tr><tr><td>LoaderPage</td><td>Row 1</td></tr></table><br><p>Content in row 1’s page. </p><br/><p>This is a child page in row 1:</p><!-- notion-child-page id=\"106a7f303194806282d6e0d7036d2fe6\" has_children=\"True\" --><h3>Child Page: <a href=\"https://www.notion.so/106a7f303194806282d6e0d7036d2fe6\">Child page in row 1</a></h3>",
"markdown": "\n\n| Tags | title_property |\n| --- | --- |\n| LoaderPage | Row 1 |\n\n\n\nContent in row 1’s page. \n\n \nThis is a child page in row 1:\n\n### Child Page: [Child page in row 1](https://www.notion.so/106a7f303194806282d6e0d7036d2fe6)\n\n\n"
},
"depth": 1,
"parent": {
"type": "database_id",
"parent_id": "106a7f30-3194-800d-b4ab-ef01d8da0770"
},
"children": [
{
"type": "page",
"id": "106a7f30-3194-8062-82d6-e0d7036d2fe6",
"url": "https://www.notion.so/Child-page-in-row-1-106a7f303194806282d6e0d7036d2fe6",
"title": "Child page in row 1",
"last_modified": "2024-09-19T07:29:00.000Z",
"conversion_timestamp": "2024-09-27T04:52:29.157716+00:00",
"content": {
"html": "<p>Child page in row 1’s content</p>",
"markdown": "Child page in row 1’s content\n\n"
},
"depth": 2,
"parent": {
"type": "page_id",
"parent_id": "9f1fa368-136e-4e31-95b7-a2aecc5275a9"
},
"children": []
}
]
}
]
}