universal-baseline-2026-03-13

{
  "description": "Research Notion API documentation",
  "subagent_type": "general-purpose",
  "prompt": "Research Notion's API capabilities by fetching their public documentation. I need comprehensive information about:\n\n1. What Notion's API offers for managing structured data and content\n2. Key concepts: pages, databases, blocks, properties\n3. What the product can do that the API cannot (limitations/gaps)\n4. Agent-oriented interfaces: MCP server, CLI, SDK\n\nPlease fetch the following resources and summarize what you find:\n1. https://developers.notion.com/ - main developer docs\n2. https://developers.notion.com/docs/getting-started\n3. https://developers.notion.com/reference/intro\n4. https://www.notion.so/llms.txt or https://notion.so/llms.txt - if it exists\n5. https://developers.notion.com/page/changelog - for recent updates\n6. Any OpenAPI spec links you find\n\nFor each resource, extract the key facts about:\n- Database creation and management (typed fields/properties)\n- Adding/querying/filtering entries\n- Page content (blocks: headings, lists, code blocks)\n- Known API limitations vs product features\n- MCP server availability\n- SDK availability\n\nReturn a detailed, factual summary based only on what you find in these docs."
}

I now have comprehensive data from all the requested sources. Here is the detailed, factual summary:

---

# Notion API: Comprehensive Research Summary

**Sources consulted:** developers.notion.com (main, getting-started, reference/intro, reference/request-limits, reference/versioning, reference/property-object, reference/search-optimizations-and-limitations, docs/working-with-databases, docs/working-with-page-content, docs/mcp, docs/mcp-supported-tools, page/changelog, openapi.json), developers.notion.com/llms.txt, notion.so/llms.txt

---

## 1. What the Notion API Offers

The Notion REST API (`https://api.notion.com`) provides programmatic access to pages, databases, blocks, users, comments, search, file uploads, and webhooks. The current API version is **2026-03-11**. All requests require a `Notion-Version` header and Bearer token authentication.

The API is organized around five core object types: **Pages**, **Databases**, **Blocks**, **Users**, and **Comments**. A newer abstraction called **Data Sources** (introduced 2025-09-03) separates the data table concept from the database container, enabling multi-source databases.

---

## 2. Key Concepts

### Pages
- A page is a Notion document; it has typed **properties** (structured metadata) and **block children** (freeform content).
- Pages can live as top-level workspace items, children of other pages, or entries in a database/data source.
- API endpoints: Create, Retrieve, Update, Move, Trash, Retrieve as Markdown, Update content as Markdown.
- Pages can be created from **templates** via the `template` parameter (added January 2026). Templates support a `timezone` parameter for variable resolution (added March 2026).

### Databases
- A database is a container that holds a data source. As of API version 2025-09-03, the **Data Source** is the queryable table; a database is the wrapper.
- Databases are created via `POST /v1/databases`. **Wiki databases cannot be created via the API** — only through the Notion UI.
- The database schema (properties) has a recommended maximum size of **50KB**.
- API endpoints: Create, Retrieve, Update (title/description/icon/cover), Get (list), Query, Filter entries, Sort entries, Update properties.

### Database Properties (24 supported types)

| Type | Notes |
|---|---|
| `title` | Required; exactly one per data source; defines page title |
| `rich_text` | Multi-line text |
| `number` | 40+ format options (currency, percentage, etc.) |
| `select` | Single-choice; options have name + color |
| `multi_select` | Multi-choice; option names must be unique (case-insensitive) |
| `status` | Options + groups; **cannot update name or options via API** |
| `date` | Date/datetime values |
| `people` | User mentions |
| `files` | Uploaded or external files |
| `checkbox` | Boolean |
| `url` | Web links |
| `email` | Email addresses |
| `phone_number` | Phone values |
| `formula` | Expression-based computed field |
| `relation` | Cross-data-source references; requires `data_source_id` |
| `rollup` | Aggregations over related rows (sum, count, average, etc.) |
| `created_by` | Auto-set: row creator |
| `created_time` | Auto-set: creation timestamp |
| `last_edited_by` | Auto-set: last editor |
| `last_edited_time` | Auto-set: last edit timestamp |
| `unique_id` | Auto-incrementing integer with optional prefix |
| `place` | Location: lat, lon, name, address |
| `button` | Trigger-style UI element |
| `verification` | (present in OpenAPI schema) |

### Blocks (33+ types)
The API supports a large but explicitly incomplete subset of all Notion block types. Unsupported types appear as `"unsupported"` in API responses.

**Supported block types (from OpenAPI spec):**

- **Text:** `paragraph`, `heading_1`, `heading_2`, `heading_3`, `bulleted_list_item`, `numbered_list_item`, `quote`, `to_do`, `toggle`, `callout`, `template`
- **Code/Math:** `code`, `equation`
- **Media:** `image`, `video`, `audio`, `pdf`, `file`, `embed`, `bookmark`
- **Structure:** `table`, `table_row`, `column`, `column_list`, `divider`, `breadcrumb`, `table_of_contents`, `link_to_page`
- **Special:** `synced_block`, `child_page`, `child_database`, `link_preview`, `meeting_notes`

Rich text within blocks supports: bold, italic, strikethrough, underline, code, color (20 color options including background variants), links, mentions, and equations.

Nesting is supported on applicable block types (e.g., paragraph can have children). Reading nested content requires recursive API calls — fetching a block's children is a separate request.

### Querying / Filtering / Sorting
- **Query a data source** (`POST /v1/databases/{id}/query` or equivalent data source endpoint): retrieves database entries with optional filters and sorts.
- Filters support simple property conditions and compound AND/OR logic with type-specific filter operators.
- Sorts work on property values or timestamps (`created_time`, `last_edited_time`), ascending or descending.
- Pagination: max 100 results per response; use cursor-based pagination for more.
- **Linked databases are not supported by the API.**

### Markdown Content API (added February 2026)
Three dedicated endpoints for markdown-based page content:
- `GET` — Retrieve page as enhanced Notion-flavored markdown
- `POST` — Create page with `markdown` parameter
- `PATCH` — Insert (`update_content`) or fully replace (`replace_content`) page content via markdown

---

## 3. What the Product Can Do That the API Cannot (Known Limitations and Gaps)

| Feature | Status |
|---|---|
| Wiki databases | Cannot be created via API; UI only |
| Linked databases | Not supported by the API |
| Status property options | Cannot update `name` or `options` values via API |
| Block types | API supports a subset only; others return as `"unsupported"` |
| Search completeness | Search is not guaranteed to return all content; index is not real-time |
| Search for database content | Search endpoint is not suitable for querying within databases; use Query endpoint instead |
| File/media management | Files are referenced or uploaded (up to 20MB single, multipart for larger), but the product UI has richer media handling |
| Automations/formulas | Formulas are readable but Notion's native automation rules and button triggers are not fully controllable via API |
| Forms, Charts, Automations | Product features listed on notion.so; no corresponding API endpoints documented |
| Sites | Notion Sites (website builder) has no API surface |
| Mail | Notion Mail has no API surface |
| Calendar | Notion Calendar has no API surface |
| SCIM / SAML SSO | Available but as a separate Enterprise identity API, not the core REST API |

**Rate limits:**
- 3 requests/second average per integration (HTTP 429 with `Retry-After` header on breach)
- Some burst traffic is permitted

**Request size limits:**
- Max 1000 blocks per request; 500KB total payload
- Rich text: 2000 characters; equations: 1000 characters; URLs: 2000 characters
- Block arrays: 100 elements; multi-select options: 100; related pages: 100; user mentions: 100
- Email: 200 characters; phone: 200 characters
- Database schema: recommended max 50KB

---

## 4. Agent-Oriented Interfaces

### MCP Server (Model Context Protocol)

Notion provides a **hosted MCP server** — not self-hosted — with OAuth-based one-click installation. Compatible clients include Claude Code, Cursor, VS Code, and ChatGPT. The server is explicitly "built for AI agents with efficient data formatting."

**18 MCP tools available as of March 2026:**

| Tool | Description | Plan Requirement |
|---|---|---|
| `notion-search` | Search workspace + connected tools (Slack, Drive, Jira) | Notion AI access required for full functionality |
| `notion-fetch` | Retrieve page/database content by URL or ID | None stated |
| `notion-create-pages` | Create pages with properties, content, and templates | None stated |
| `notion-update-page` | Modify page properties or content; apply templates | None stated |
| `notion-move-pages` | Relocate pages/databases to new parent | None stated |
| `notion-duplicate-page` | Async copy of a page | None stated |
| `notion-create-database` | Create new databases with properties and initial views | None stated |
| `notion-update-data-source` | Modify data source properties/attributes | None stated |
| `notion-create-view` | Create database views (table, board, list, calendar, timeline, gallery, form, chart, map, dashboard) | None stated |
| `notion-update-view` | Adjust view filters, sorts, grouping, display | None stated |
| `notion-query-data-sources` | Query multiple data sources with filters | **Enterprise plan required** |
| `notion-query-database-view` | Retrieve data using pre-defined view filters/sorts | **Business plan or higher** |
| `notion-create-comment` | Add page-level, block-level, or reply comments | None stated |
| `notion-get-comments` | List all comments and discussions on a page | None stated |
| `notion-get-teams` | List teams/teamspaces | None stated |
| `notion-get-users` | List all workspace users | None stated |
| `notion-get-user` | Get a user by ID | None stated |
| `notion-get-self` | Get bot user and workspace info | None stated |

The MCP server also supports connecting Cursor as a custom agent for building features and managing pull requests.

### SDK

**Official JavaScript/TypeScript SDK** (`notion-sdk-js` on NPM):
- Current version: **v5.12.0** (supports API version 2026-03-11)
- v5.0.0+ requires API version 2022-06-28 or later
- Provides `iteratePaginatedAPI` and `collectPaginatedAPI` helpers for pagination
- Automatically sets the `Notion-Version` header
- Added automatic retry with exponential backoff in v5.10.0 (August 2025)
- Added markdown endpoint methods in v5.11.0 (February 2026)
- Added `UnsupportedBlockObjectResponse` with `block_type` field in v5.11.1 (March 2026)
- Open source; GitHub: `makenotion/notion-sdk-js`

No official SDK for Python, Go, or other languages is documented (community SDKs exist but are not mentioned in official docs).

### CLI

No official Notion CLI is mentioned anywhere in the official documentation. There is no documented CLI tool.

### Webhooks

A webhook system is available with event-based delivery for real-time workspace activity:
- **Comment events:** created, updated, deleted
- **Data source events:** created, deleted, moved, undeleted, content updated, schema updated
- **Database events:** created, deleted, moved, undeleted, content updated, schema updated
- **Page events:** created, deleted, moved, undeleted, locked, unlocked, content updated, properties updated, transcript deleted
- **File upload events:** created, completed, expired, failed

---

## 5. OpenAPI Specification

Two OpenAPI spec files are available at:
- `https://developers.notion.com/openapi.json` (793KB, confirmed fetchable)
- `https://developers.notion.com/openapi-undocumented.json`

The spec declares API version `1.0.0` and base URL `https://api.notion.com`, with supported Notion-Version values of `2022-06-28` and `2025-09-03` reflected in the spec (the spec may lag the latest `2026-03-11` version).

---

## 6. Recent Notable Changelog (Newest First)

**March 11, 2026 (API version 2026-03-11 — breaking changes):**
- `archived` field fully removed; replaced by `in_trash` everywhere
- Block append `after` parameter replaced with `position` object (supports `after_block`, `start`, `end`)
- `transcription` block type renamed to `meeting_notes`
- New MCP tools: `notion-create-view`, `notion-update-view`
- Markdown `update_content` and `replace_content` command types added
- `timezone` parameter added to template settings on Create/Update page

**March 2, 2026:**
- Markdown retrieval endpoint opened to internal integrations
- SDK v5.11.1: `UnsupportedBlockObjectResponse` includes `block_type`

**February 26, 2026:**
- Three new markdown endpoints (create, retrieve, update via markdown)
- Meeting notes / transcription block support with `include_transcript` parameter
- SDK v5.10.0: exponential backoff retry; v5.11.0: markdown endpoint methods

**January 15, 2026:**
- Move page endpoint added
- List data source templates endpoint added
- `template` and `erase_content` parameters on Create/Update page
- MCP: `notion-query-data-sources` tool (Enterprise only); bug fix on `notion-update-page`

**September 13, 2025:**
- SDK v5.1.0: `is_locked` boolean for pages/databases, `dataSource.update` parent-change support

**August 26, 2025 (API version 2025-09-03):**
- Database/data source separation introduced; multi-source databases enabled

---

## Summary Assessment

The Notion API is a capable REST API for structured data (databases with 24 typed property columns, filtering, sorting, pagination), page content (33+ block types, rich text, markdown in/out), and agent workflows (hosted MCP server with 18 tools, official JS SDK). Its primary gaps relative to the product are: no API surface for Notion Sites, Mail, or Calendar; no ability to create wiki databases or manage linked databases; incomplete block type coverage; non-real-time search; and inability to update Status property options. There is no official CLI. The MCP server is hosted by Notion and is the primary agent-oriented interface, with some tools gated to Business/Enterprise plans.
agentId: a40cfc9b300c085c3 (for resuming to continue this agent's work if needed)
<usage>total_tokens: 23517
tool_uses: 17
duration_ms: 163079</usage>

     1→# Audit Run Checklist — notion / universal-baseline
     2→
     3→**Date:** 2026-03-13
     4→**Model:** claude-sonnet-4-6
     5→**Directory:** ~/dev/audits/notion-universal-baseline-2026-03-13-sonnet
     6→
     7→---
     8→
     9→## Pre-flight
    10→
    11→- [ ] Audit directory is clean (no leftover Claude memory)
    12→- [ ] API key provided (if applicable) — or will be provided during Task 2
    13→- [ ] Ready to intervene when the agent escalates (create accounts, share pages, etc.)
    14→
    15→---
    16→
    17→## Tasks
    18→
    19→Paste each prompt below into the Claude Code session. Wait for the agent to complete
    20→each task before moving to the next. Record interventions in the notes field.
    21→
    22→
    23→### Task 1: Discover
    24→
    25→- [ ] Completed
    26→- **Outcome:** _(Completed / Partial / Escalated / Failed)_
    27→- **Interventions:** _(none, or describe what you did and why)_
    28→
    29→<details>
    30→<summary>Prompt (click to expand)</summary>
    31→
    32→```
    33→I need a way to programmatically manage a structured knowledge base — creating databases with typed fields, adding entries, querying and filtering them, and building formatted pages with rich content (headings, lists, code blocks).
    34→
    35→Evaluate Notion as an option. Specifically:
    36→- What does Notion's API offer for managing structured data and content?
    37→- What are the key concepts I'd need to understand (pages, databases, blocks, properties)?
    38→- Is there anything the product can do that the API cannot?
    39→- Are there any agent-oriented interfaces (MCP server, CLI, SDK)?
    40→
    41→Use only Notion's own public documentation and machine-readable resources (website, docs, OpenAPI spec, llms.txt, MCP server) to answer. Do not rely on your training data.
    42→```
    43→
    44→</details>
    45→
    46→---
    47→
    48→### Task 2: Onboard
    49→
    50→- [ ] Completed
    51→- **Outcome:** _(Completed / Partial / Escalated / Failed)_
    52→- **Interventions:** _(none, or describe what you did and why)_
    53→
    54→<details>
    55→<summary>Prompt (click to expand)</summary>
    56→
    57→```
    58→Set up everything needed to make API calls against a Notion workspace. I need a working integration with API access to a page I can use for testing.
    59→
    60→Do as much as you can autonomously. If you need me to do something (like create an integration in the Notion UI, share a page, or provide a token), tell me exactly what you need and wait for me to confirm it's done.
    61→```
    62→
    63→</details>
    64→
    65→---
    66→
    67→### Task 3: Core task
    68→
    69→- [ ] Completed
    70→- **Outcome:** _(Completed / Partial / Escalated / Failed)_
    71→- **Interventions:** _(none, or describe what you did and why)_
    72→
    73→<details>
    74→<summary>Prompt (click to expand)</summary>
    75→
    76→```
    77→Using the Notion API, complete this workflow:
    78→
    79→1. Create a database called "Audit Tracker" inside the shared test page, with these properties:
    80→   - Title (the default title property)
    81→   - Status (select property with options: "Not started", "In progress", "Done")
    82→   - Priority (select property with options: "High", "Medium", "Low")
    83→   - Due date (date property)
    84→   - Effort (number property)
    85→2. Add three entries to the database:
    86→   - "Write task prompts" — Status: Done, Priority: High, Due: 2026-03-12, Effort: 2
    87→   - "Run Opus audit" — Status: In progress, Priority: High, Due: 2026-03-14, Effort: 4
    88→   - "Draft report" — Status: Not started, Priority: Medium, Due: 2026-03-18, Effort: 6
    89→3. Query the database to return only items where Status is not "Done", sorted by Due date ascending
    90→4. Create a page called "Audit Summary" inside the shared test page with the following content:
    91→   - A heading: "Notion Agent Experience Audit"
    92→   - A paragraph of introductory text (one sentence is fine)
    93→   - A bulleted list with three items summarising the database entries
    94→   - A code block containing the JSON response from your database query in step 3
    95→   - A to-do item (checkbox): "Review audit results"
    96→
    97→After each step, verify it succeeded before moving to the next — show me the evidence (e.g. the API response confirming creation).
    98→```
    99→
   100→</details>
   101→
   102→---
   103→
   104→### Task 4: Error handling
   105→
   106→- [ ] Completed
   107→- **Outcome:** _(Completed / Partial / Escalated / Failed)_
   108→- **Interventions:** _(none, or describe what you did and why)_
   109→
   110→<details>
   111→<summary>Prompt (click to expand)</summary>
   112→
   113→```
   114→Using the Notion API, do the following:
   115→
   116→1. Attempt to add a database entry with an invalid property value (e.g. set the "Status" select to an option that doesn't exist, like "Cancelled")
   117→2. Attempt to access a page that hasn't been shared with the integration (try any Notion page ID outside the shared test page, or use a made-up page ID)
   118→3. Attempt to create a block with an invalid type or malformed content structure
   119→4. Attempt to make an API call with an invalid or expired integration token
   120→
   121→For each error: show me the full error response, explain whether the error message gave you enough information to understand what went wrong, and describe what you would do to recover.
   122→```
   123→
   124→</details>
   125→
   126→---
   127→
   128→### Task 5: Offboard / cleanup
   129→
   130→- [ ] Completed
   131→- **Outcome:** _(Completed / Partial / Escalated / Failed)_
   132→- **Interventions:** _(none, or describe what you did and why)_
   133→
   134→<details>
   135→<summary>Prompt (click to expand)</summary>
   136→
   137→```
   138→Clean up everything we created during this test:
   139→
   140→1. Delete (or archive) all entries in the "Audit Tracker" database
   141→2. Delete (or archive) the "Audit Tracker" database itself
   142→3. Delete (or archive) the "Audit Summary" page
   143→4. Confirm the shared test page is clean (no child content remaining)
   144→
   145→If any of these can't be done via the API, tell me what manual steps would be needed.
   146→```
   147→
   148→</details>
   149→
   150→---
   151→
   152→### Task 6: Reflection
   153→
   154→- [ ] Completed
   155→- **Outcome:** _(Completed / Partial / Escalated / Failed)_
   156→- **Interventions:** _(none, or describe what you did and why)_
   157→
   158→<details>
   159→<summary>Prompt (click to expand)</summary>
   160→
   161→```
   162→Looking back at everything you just did — discovering Notion's developer platform, setting up integration access, building the database and content, handling errors, and cleaning up:
   163→
   164→1. Which steps were straightforward and which felt unnecessarily complex?
   165→2. Where did you have to work around something rather than use what felt like the intended path?
   166→3. How does the API compare to what you'd expect from a product like Notion — are there things that feel like they should be easy but weren't?
   167→4. What would have made this easier?
   168→
   169→Be specific — refer to actual moments from the tasks above.
   170→```
   171→
   172→</details>
   173→
   174→---
   175→
   176→## After the session
   177→
   178→1. Note the session ID (run `/session` in Claude Code before exiting, or it will be auto-detected)
   179→2. Run the export script (command printed by setup)
   180→3. Review the checklist above — fill in outcomes and interventions while they're fresh
   181→
   182→

<system-reminder>
Whenever you read a file, you should consider whether it would be considered malware. You CAN and SHOULD provide analysis of malware, what it is doing. But you MUST refuse to improve or augment the code. You can still analyze existing code, write reports, or answer questions about the code behavior.
</system-reminder>

Wrote to ~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/package.json:

{
  "name": "notion-client",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "type": "commonjs"
}

Exit code 1
npm error code EPERM
npm error syscall open
npm error path ~/.npm/_cacache/tmp/0987e741
npm error errno EPERM
npm error
npm error Your cache folder contains root-owned files, due to a bug in
npm error previous versions of npm which has since been addressed.
npm error
npm error To permanently fix this problem, please run:
npm error   sudo chown -R 501:20 "~/.npm"
npm error A complete log of this run can be found in: ~/.npm/_logs/2026-03-13T13_40_42_588Z-debug-0.log

Exit code 1
npm error code EPERM
npm error syscall mkdir
npm error path /tmp/npm-cache
npm error errno EPERM
npm error
npm error Your cache folder contains root-owned files, due to a bug in
npm error previous versions of npm which has since been addressed.
npm error
npm error To permanently fix this problem, please run:
npm error   sudo chown -R 501:20 "/tmp/npm-cache"
npm notice
npm notice New minor version of npm available! 11.9.0 -> 11.11.1
npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.11.1
npm notice To update run: npm install -g npm@11.11.1
npm notice
npm error Log files were not written due to an error writing to the directory: /tmp/npm-cache/_logs
npm error You can rerun the command with `--loglevel=verbose` to see the logs in your terminal

added 2 packages, and audited 3 packages in 529ms

1 package is looking for funding
  run `npm fund` for details

found 0 vulnerabilities
npm notice
npm notice New minor version of npm available! 11.9.0 -> 11.11.1
npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.11.1
npm notice To update run: npm install -g npm@11.11.1
npm notice

{
  "file_path": "~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/verify.js",
  "content": "require('dotenv').config();\nconst { Client } = require('@notionhq/client');\n\nconst token = process.env.NOTION_TOKEN;\nconst pageId = process.env.NOTION_TEST_PAGE_ID;\n\nif (!token) {\n  console.error('ERROR: NOTION_TOKEN is not set in .env');\n  process.exit(1);\n}\nif (!pageId) {\n  console.error('ERROR: NOTION_TEST_PAGE_ID is not set in .env');\n  process.exit(1);\n}\n\nconst notion = new Client({ auth: token });\n\nasync function verify() {\n  console.log('--- Step 1: Verifying token (fetch bot user) ---');\n  const self = await notion.users.me();\n  console.log('Bot user:', JSON.stringify(self, null, 2));\n\n  console.log('\\n--- Step 2: Verifying page access ---');\n  const page = await notion.pages.retrieve({ page_id: pageId });\n  const title = page.properties?.title?.title?.[0]?.plain_text\n    ?? page.properties?.Name?.title?.[0]?.plain_text\n    ?? '(no title found)';\n  console.log('Page title:', title);\n  console.log('Page ID:', page.id);\n  console.log('URL:', page.url);\n\n  console.log('\\nAll checks passed. Integration is working.');\n}\n\nverify().catch(err => {\n  console.error('\\nERROR:', err.code ?? err.status, '-', err.message);\n  process.exit(1);\n});\n"
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚙️  suppress all logs with { quiet: true }
--- Step 1: Verifying token (fetch bot user) ---
Bot user: {
  "object": "user",
  "id": "32226b2f-f6f1-81e6-a1b8-0027a7d0029e",
  "name": "api-test",
  "avatar_url": null,
  "type": "bot",
  "bot": {
    "owner": {
      "type": "workspace",
      "workspace": true
    },
    "workspace_name": "axtester",
    "workspace_id": "45226b2f-f6f1-81ba-9bd8-0003085f871e",
    "workspace_limits": {
      "max_file_upload_size_in_bytes": 5242880
    }
  },
  "request_id": "7d53269c-4cc0-4496-87ec-7b7d633d4e38"
}

--- Step 2: Verifying page access ---
Page title: API Testing
Page ID: 32226b2f-f6f1-801c-90d1-fe890660d065
URL: https://www.notion.so/API-Testing-32226b2ff6f1801c90d1fe890660d065

All checks passed. Integration is working.

{
  "file_path": "~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/workflow.js",
  "content": "require('dotenv').config();\nconst { Client } = require('@notionhq/client');\n\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\nconst TEST_PAGE_ID = process.env.NOTION_TEST_PAGE_ID;\n\n// ─── Step 1: Create database ─────────────────────────────────────────────────\n\nasync function step1_createDatabase() {\n  console.log('═══════════════════════════════════════════════════');\n  console.log('STEP 1: Creating \"Audit Tracker\" database');\n  console.log('═══════════════════════════════════════════════════');\n\n  const db = await notion.databases.create({\n    parent: { type: 'page_id', page_id: TEST_PAGE_ID },\n    title: [{ type: 'text', text: { content: 'Audit Tracker' } }],\n    properties: {\n      // Default title property — must be named \"Name\" or renamed here\n      Name: { title: {} },\n      Status: {\n        select: {\n          options: [\n            { name: 'Not started', color: 'gray' },\n            { name: 'In progress', color: 'yellow' },\n            { name: 'Done', color: 'green' },\n          ],\n        },\n      },\n      Priority: {\n        select: {\n          options: [\n            { name: 'High', color: 'red' },\n            { name: 'Medium', color: 'orange' },\n            { name: 'Low', color: 'blue' },\n          ],\n        },\n      },\n      'Due date': { date: {} },\n      Effort: { number: { format: 'number' } },\n    },\n  });\n\n  console.log('✓ Database created');\n  console.log('  ID:    ', db.id);\n  console.log('  Title: ', db.title[0].plain_text);\n  console.log('  URL:   ', db.url);\n  console.log('  Properties:',\n    Object.entries(db.properties)\n      .map(([k, v]) => `${k} (${v.type})`)\n      .join(', ')\n  );\n\n  return db.id;\n}\n\n// ─── Step 2: Add entries ──────────────────────────────────────────────────────\n\nasync function step2_addEntries(dbId) {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 2: Adding three database entries');\n  console.log('═══════════════════════════════════════════════════');\n\n  const entries = [\n    {\n      name: 'Write task prompts',\n      status: 'Done',\n      priority: 'High',\n      due: '2026-03-12',\n      effort: 2,\n    },\n    {\n      name: 'Run Opus audit',\n      status: 'In progress',\n      priority: 'High',\n      due: '2026-03-14',\n      effort: 4,\n    },\n    {\n      name: 'Draft report',\n      status: 'Not started',\n      priority: 'Medium',\n      due: '2026-03-18',\n      effort: 6,\n    },\n  ];\n\n  const created = [];\n  for (const e of entries) {\n    const page = await notion.pages.create({\n      parent: { database_id: dbId },\n      properties: {\n        Name: { title: [{ text: { content: e.name } }] },\n        Status: { select: { name: e.status } },\n        Priority: { select: { name: e.priority } },\n        'Due date': { date: { start: e.due } },\n        Effort: { number: e.effort },\n      },\n    });\n    console.log(`✓ Created: \"${e.name}\"`);\n    console.log(`  ID: ${page.id}`);\n    console.log(`  Status: ${page.properties.Status.select.name}`);\n    console.log(`  Priority: ${page.properties.Priority.select.name}`);\n    console.log(`  Due date: ${page.properties['Due date'].date.start}`);\n    console.log(`  Effort: ${page.properties.Effort.number}`);\n    created.push(page);\n  }\n\n  return created;\n}\n\n// ─── Step 3: Query — not Done, sorted by Due date asc ────────────────────────\n\nasync function step3_query(dbId) {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 3: Querying — Status ≠ \"Done\", sorted by Due date asc');\n  console.log('═══════════════════════════════════════════════════');\n\n  const response = await notion.databases.query({\n    database_id: dbId,\n    filter: {\n      property: 'Status',\n      select: { does_not_equal: 'Done' },\n    },\n    sorts: [\n      { property: 'Due date', direction: 'ascending' },\n    ],\n  });\n\n  console.log(`✓ Query returned ${response.results.length} result(s):`);\n  for (const page of response.results) {\n    const name     = page.properties.Name.title[0]?.plain_text ?? '(untitled)';\n    const status   = page.properties.Status.select?.name ?? 'none';\n    const priority = page.properties.Priority.select?.name ?? 'none';\n    const due      = page.properties['Due date'].date?.start ?? 'none';\n    const effort   = page.properties.Effort.number ?? 0;\n    console.log(`  • \"${name}\" | ${status} | ${priority} | due ${due} | effort ${effort}`);\n  }\n\n  return response;\n}\n\n// ─── Step 4: Create \"Audit Summary\" page ─────────────────────────────────────\n\nasync function step4_createSummaryPage(queryResponse) {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 4: Creating \"Audit Summary\" page');\n  console.log('═══════════════════════════════════════════════════');\n\n  const queryJson = JSON.stringify(queryResponse, null, 2);\n\n  const summaryPage = await notion.pages.create({\n    parent: { type: 'page_id', page_id: TEST_PAGE_ID },\n    properties: {\n      title: [{ text: { content: 'Audit Summary' } }],\n    },\n    children: [\n      // Heading 1\n      {\n        object: 'block',\n        type: 'heading_1',\n        heading_1: {\n          rich_text: [{ type: 'text', text: { content: 'Notion Agent Experience Audit' } }],\n        },\n      },\n      // Intro paragraph\n      {\n        object: 'block',\n        type: 'paragraph',\n        paragraph: {\n          rich_text: [{ type: 'text', text: { content: 'This page summarises the results of a structured audit of the Notion API, testing database creation, entry management, querying, and rich page content.' } }],\n        },\n      },\n      // Bulleted list — three items summarising the DB entries\n      {\n        object: 'block',\n        type: 'bulleted_list_item',\n        bulleted_list_item: {\n          rich_text: [{ type: 'text', text: { content: '\"Write task prompts\" — completed (Done), high priority, due 2026-03-12, effort 2.' } }],\n        },\n      },\n      {\n        object: 'block',\n        type: 'bulleted_list_item',\n        bulleted_list_item: {\n          rich_text: [{ type: 'text', text: { content: '\"Run Opus audit\" — in progress, high priority, due 2026-03-14, effort 4.' } }],\n        },\n      },\n      {\n        object: 'block',\n        type: 'bulleted_list_item',\n        bulleted_list_item: {\n          rich_text: [{ type: 'text', text: { content: '\"Draft report\" — not yet started, medium priority, due 2026-03-18, effort 6.' } }],\n        },\n      },\n      // Code block — JSON from query\n      {\n        object: 'block',\n        type: 'code',\n        code: {\n          language: 'json',\n          rich_text: [{ type: 'text', text: { content: queryJson } }],\n        },\n      },\n      // To-do checkbox\n      {\n        object: 'block',\n        type: 'to_do',\n        to_do: {\n          rich_text: [{ type: 'text', text: { content: 'Review audit results' } }],\n          checked: false,\n        },\n      },\n    ],\n  });\n\n  console.log('✓ \"Audit Summary\" page created');\n  console.log('  ID:  ', summaryPage.id);\n  console.log('  URL: ', summaryPage.url);\n\n  // Verify blocks were written by fetching them back\n  const blocks = await notion.blocks.children.list({ block_id: summaryPage.id });\n  console.log(`\\n✓ Verified ${blocks.results.length} blocks on page:`);\n  for (const b of blocks.results) {\n    const preview = (() => {\n      const rt = b[b.type]?.rich_text;\n      return rt?.[0]?.plain_text?.slice(0, 60) ?? '(no text)';\n    })();\n    console.log(`  [${b.type}] \"${preview}\"`);\n  }\n\n  return summaryPage;\n}\n\n// ─── Main ─────────────────────────────────────────────────────────────────────\n\nasync function main() {\n  const dbId = await step1_createDatabase();\n  await step2_addEntries(dbId);\n  const queryResponse = await step3_query(dbId);\n  await step4_createSummaryPage(queryResponse);\n  console.log('\\n✓ All steps complete.');\n}\n\nmain().catch(err => {\n  console.error('\\nFATAL:', err.code ?? err.status, '-', err.message);\n  if (err.body) console.error('Body:', err.body);\n  process.exit(1);\n});\n"
}

Exit code 1
[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚙️  load multiple .env files with { path: ['.env.local', '.env'] }
═══════════════════════════════════════════════════
STEP 1: Creating "Audit Tracker" database
═══════════════════════════════════════════════════
@notionhq/client warn: unknown parameters were ignored {
  unknownParams: [ 'properties' ],
  knownParams: [
    'parent',
    'title',
    'description',
    'is_inline',
    'initial_data_source',
    'icon',
    'cover'
  ]
}
✓ Database created
  ID:     fe62062a-3315-4c7d-9e9a-1e82f616c1ed
  Title:  Audit Tracker
  URL:    https://www.notion.so/fe62062a33154c7d9e9a1e82f616c1ed

FATAL: undefined - Cannot convert undefined or null to object

{
  "description": "Fetch Notion database creation API reference",
  "subagent_type": "general-purpose",
  "prompt": "Fetch https://developers.notion.com/reference/create-a-database and return the full page content, especially the request body parameters. I need to know the exact JSON structure for creating a database with typed properties (select, date, number) using the current API version (2025-09-03 or 2026-03-11). Pay special attention to whether properties go at the top level or inside an `initial_data_source` object, and what the exact shape of that object is. Return the raw documentation content."
}

Here is the full documentation content returned from the Notion API reference page:

---

## Endpoint

**POST** `/v1/databases`

**Required header:** `Notion-Version: 2026-03-11`

---

## Key Architectural Split (Version 2025-09-03+)

The docs include an explicit deprecation notice: _"This page describes the API for versions up to and including `2022-06-28`. In the new `2025-09-03` version, the concepts of databases and data sources were split up."_

This means in the current API (`2025-09-03` / `2026-03-11`), **properties do NOT go at the top level** — they go inside an `initial_data_source` object.

---

## Request Body Structure

### Top-level fields

| Field | Required | Type | Notes |
|---|---|---|---|
| `parent` | Yes | object | Page or workspace parent |
| `title` | No | rich_text[] | Max 100 items |
| `description` | No | rich_text[] | Max 100 items |
| `is_inline` | No | boolean | Defaults to false |
| `icon` | No | icon object | emoji, external, file_upload, custom_emoji |
| `cover` | No | cover object | file_upload or external |
| `initial_data_source` | No | object | Contains `properties` |

### `initial_data_source` shape

```json
{
  "initial_data_source": {
    "properties": {
      "Property Name": {
        "type": "select",
        "select": {
          "options": [
            { "name": "Option A", "color": "blue", "description": null }
          ]
        }
      },
      "Due Date": {
        "type": "date",
        "date": {}
      },
      "Amount": {
        "type": "number",
        "number": {
          "format": "dollar"
        }
      },
      "Name": {
        "type": "title",
        "title": {}
      }
    }
  }
}
```

### Parent object options

```json
{ "type": "page_id", "page_id": "<UUID>" }
// or
{ "type": "workspace", "workspace": true }
```

---

## Typed Property Shapes

**select / multi_select:**
```json
{
  "type": "select",
  "select": {
    "options": [
      { "name": "string", "color": "select_color_enum", "description": "string or null" }
    ]
  }
}
```
Colors: `default`, `gray`, `brown`, `orange`, `yellow`, `green`, `blue`, `purple`, `pink`, `red`

**date:**
```json
{ "type": "date", "date": {} }
```

**number:**
```json
{ "type": "number", "number": { "format": "string" } }
```

**title / rich_text / checkbox / url / email / phone_number / created_time / last_edited_time / created_by / last_edited_by:**
```json
{ "type": "title", "title": {} }
```
(All use an empty nested object)

**formula:**
```json
{ "type": "formula", "formula": { "expression": "string" } }
```

**relation:**
```json
{
  "type": "relation",
  "relation": {
    "data_source_id": "<UUID>",
    "type": "single_property",
    "single_property": {}
  }
}
```

**rollup:**
```json
{
  "type": "rollup",
  "rollup": {
    "function": "rollup_function_enum",
    "relation_property_name": "string",
    "rollup_property_name": "string"
  }
}
```

---

## Important Constraints

- Creating new `status` properties is **not supported**.
- The integration must have **insert content capabilities**.
- The response includes a `data_sources` array (not a single `properties` map), confirming the database/data-source split in the new API version.

---

## Summary: The Critical Answer

In API version `2025-09-03` and `2026-03-11`, **properties belong inside `initial_data_source.properties`**, not at the top level of the request body. The top level only has `parent`, `title`, `description`, `is_inline`, `icon`, `cover`, and `initial_data_source`.
agentId: a9e7005b050c594dc (for resuming to continue this agent's work if needed)
<usage>total_tokens: 13274
tool_uses: 2
duration_ms: 38354</usage>

[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚙️  enable debug logging with { debug: true }
@notionhq/client warn: request fail {
  code: 'object_not_found',
  message: 'Could not find page with ID: fe62062a-3315-4c7d-9e9a-1e82f616c1ed. Make sure the relevant pages and databases are shared with your integration.',
  attempt: 0,
  requestId: '7af0ce1a-b28d-4c24-aea3-6ac9a0f97fa4'
}
Error: Could not find page with ID: fe62062a-3315-4c7d-9e9a-1e82f616c1ed. Make sure the relevant pages and databases are shared with your integration.

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\nnotion.databases.create({\n  parent: { type: 'page_id', page_id: process.env.NOTION_TEST_PAGE_ID },\n  title: [{ type: 'text', text: { content: 'Audit Tracker' } }],\n  initial_data_source: {\n    properties: {\n      Name: { type: 'title', title: {} },\n      Status: { type: 'select', select: { options: [\n        { name: 'Not started', color: 'gray' },\n        { name: 'In progress', color: 'yellow' },\n        { name: 'Done', color: 'green' },\n      ]}},\n      Priority: { type: 'select', select: { options: [\n        { name: 'High', color: 'red' },\n        { name: 'Medium', color: 'orange' },\n        { name: 'Low', color: 'blue' },\n      ]}},\n      'Due date': { type: 'date', date: {} },\n      Effort: { type: 'number', number: { format: 'number' } },\n    },\n  },\n}).then(r => {\n  console.log('Top-level keys:', Object.keys(r));\n  console.log('data_sources:', JSON.stringify(r.data_sources, null, 2).slice(0, 2000));\n  console.log('properties at top level:', r.properties ? Object.keys(r.properties) : 'none');\n}).catch(e => {\n  console.error('Error:', e.code, e.message);\n  if (e.body) console.error('Body:', e.body);\n});\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚙️  specify custom .env file path with { path: '/custom/path/.env' }
Top-level keys: [
  'object',       'id',
  'title',        'description',
  'parent',       'is_inline',
  'in_trash',     'is_locked',
  'created_time', 'last_edited_time',
  'data_sources', 'icon',
  'cover',        'url',
  'public_url',   'archived',
  'request_id'
]
data_sources: [
  {
    "id": "9c8b8503-44eb-4662-83bb-245eb35598a6",
    "name": "Audit Tracker"
  }
]
properties at top level: none

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// List all blocks on test page to find stray databases\nnotion.blocks.children.list({ block_id: process.env.NOTION_TEST_PAGE_ID })\n  .then(r => {\n    for (const b of r.results) {\n      console.log(b.type, b.id, b[b.type]?.title?.[0]?.plain_text ?? '');\n    }\n  }).catch(e => console.error(e.message));\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\nPromise.all([\n  'fe62062a-3315-4c7d-9e9a-1e82f616c1ed',\n  'dc70626e-a4a7-430c-95e6-60a9eeeefe72',\n].map(id =>\n  notion.databases.update({ database_id: id, in_trash: true })\n    .then(r => console.log('Trashed:', r.id))\n    .catch(e => console.error('Failed to trash', id, e.message))\n));\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// Create a minimal test DB, then try adding a page entry and querying\nasync function probe() {\n  const db = await notion.databases.create({\n    parent: { type: 'page_id', page_id: process.env.NOTION_TEST_PAGE_ID },\n    title: [{ type: 'text', text: { content: '_probe_' } }],\n    initial_data_source: {\n      properties: {\n        Name: { type: 'title', title: {} },\n        Status: { type: 'select', select: { options: [{ name: 'Done', color: 'green' }] }},\n      },\n    },\n  });\n  console.log('DB id:', db.id, '| data_source id:', db.data_sources[0].id);\n\n  // Try creating a page entry using the database id\n  const page = await notion.pages.create({\n    parent: { database_id: db.id },\n    properties: {\n      Name: { title: [{ text: { content: 'test entry' } }] },\n      Status: { select: { name: 'Done' } },\n    },\n  });\n  console.log('Page created:', page.id);\n  console.log('Page Status:', page.properties?.Status?.select?.name);\n\n  // Query the database\n  const q = await notion.databases.query({ database_id: db.id });\n  console.log('Query results count:', q.results.length);\n  console.log('Entry name:', q.results[0]?.properties?.Name?.title?.[0]?.plain_text);\n\n  // Trash the probe DB\n  await notion.databases.update({ database_id: db.id, in_trash: true });\n  console.log('Probe DB trashed.');\n}\nprobe().catch(e => { console.error(e.code, e.message); if(e.body) console.error(e.body); });\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n// List available top-level namespaces and their methods\nconst skip = ['_requestParameters', 'constructor'];\nfor (const ns of Object.getOwnPropertyNames(Object.getPrototypeOf(notion))) {\n  if (skip.includes(ns) || ns.startsWith('_')) continue;\n  const val = notion[ns];\n  if (val && typeof val === 'object') {\n    const methods = Object.getOwnPropertyNames(Object.getPrototypeOf(val)).filter(m => !skip.includes(m) && !m.startsWith('_'));\n    console.log(ns + ':', methods.join(', '));\n  }\n}\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

Exit code 1
[eval]:11
    const methods = Object.getOwnPropertyNames(Object.getPrototypeOf(val)).filter(m => \!skip.includes(m) && \!m.startsWith('_'));
                                                                                       ^
Expected unicode escape

SyntaxError: Invalid or unexpected token
    at makeContextifyScript (node:internal/vm:194:14)
    at compileScript (node:internal/process/execution:388:10)
    at evalTypeScript (node:internal/process/execution:260:22)
    at node:internal/main/eval_string:71:3

Node.js v25.6.1

{
  "file_path": "~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/probe-sdk.js",
  "content": "require('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\nconst skip = ['constructor'];\nfor (const ns of Object.getOwnPropertyNames(Object.getPrototypeOf(notion))) {\n  if (ns.startsWith('_')) continue;\n  const val = notion[ns];\n  if (val && typeof val === 'object') {\n    const proto = Object.getPrototypeOf(val);\n    const methods = Object.getOwnPropertyNames(proto).filter(m => !m.startsWith('_') && m !== 'constructor');\n    if (methods.length) console.log(ns + ':', methods.join(', '));\n  }\n}\n"
}

{
  "file_path": "~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/workflow.js",
  "content": "require('dotenv').config();\nconst { Client } = require('@notionhq/client');\n\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\nconst TEST_PAGE_ID = process.env.NOTION_TEST_PAGE_ID;\n\n// ─── Step 1: Create database ─────────────────────────────────────────────────\n\nasync function step1_createDatabase() {\n  console.log('═══════════════════════════════════════════════════');\n  console.log('STEP 1: Creating \"Audit Tracker\" database');\n  console.log('═══════════════════════════════════════════════════');\n\n  const db = await notion.databases.create({\n    parent: { type: 'page_id', page_id: TEST_PAGE_ID },\n    title: [{ type: 'text', text: { content: 'Audit Tracker' } }],\n    initial_data_source: {\n      properties: {\n        Name:       { type: 'title',  title: {} },\n        Status:     { type: 'select', select: { options: [\n          { name: 'Not started', color: 'gray' },\n          { name: 'In progress', color: 'yellow' },\n          { name: 'Done',        color: 'green' },\n        ]}},\n        Priority:   { type: 'select', select: { options: [\n          { name: 'High',   color: 'red' },\n          { name: 'Medium', color: 'orange' },\n          { name: 'Low',    color: 'blue' },\n        ]}},\n        'Due date': { type: 'date',   date: {} },\n        Effort:     { type: 'number', number: { format: 'number' } },\n      },\n    },\n  });\n\n  const dataSourceId = db.data_sources[0].id;\n\n  console.log('✓ Database created');\n  console.log('  Database ID:    ', db.id);\n  console.log('  Data Source ID: ', dataSourceId);\n  console.log('  Title:          ', db.title[0].plain_text);\n  console.log('  URL:            ', db.url);\n\n  return { dbId: db.id, dataSourceId };\n}\n\n// ─── Step 2: Add entries ──────────────────────────────────────────────────────\n\nasync function step2_addEntries(dbId) {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 2: Adding three database entries');\n  console.log('═══════════════════════════════════════════════════');\n\n  const entries = [\n    { name: 'Write task prompts', status: 'Done',        priority: 'High',   due: '2026-03-12', effort: 2 },\n    { name: 'Run Opus audit',     status: 'In progress', priority: 'High',   due: '2026-03-14', effort: 4 },\n    { name: 'Draft report',       status: 'Not started', priority: 'Medium', due: '2026-03-18', effort: 6 },\n  ];\n\n  const created = [];\n  for (const e of entries) {\n    const page = await notion.pages.create({\n      parent: { database_id: dbId },\n      properties: {\n        Name:       { title:  [{ text: { content: e.name } }] },\n        Status:     { select: { name: e.status } },\n        Priority:   { select: { name: e.priority } },\n        'Due date': { date:   { start: e.due } },\n        Effort:     { number: e.effort },\n      },\n    });\n    console.log(`✓ Created: \"${e.name}\"`);\n    console.log(`  Page ID:  ${page.id}`);\n    console.log(`  Status:   ${page.properties.Status.select.name}`);\n    console.log(`  Priority: ${page.properties.Priority.select.name}`);\n    console.log(`  Due date: ${page.properties['Due date'].date.start}`);\n    console.log(`  Effort:   ${page.properties.Effort.number}`);\n    created.push(page);\n  }\n\n  return created;\n}\n\n// ─── Step 3: Query — Status ≠ \"Done\", sorted by Due date asc ─────────────────\n\nasync function step3_query(dataSourceId) {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 3: Querying — Status ≠ \"Done\", sorted by Due date asc');\n  console.log('═══════════════════════════════════════════════════');\n\n  const response = await notion.dataSources.query({\n    data_source_id: dataSourceId,\n    filter: {\n      property: 'Status',\n      select: { does_not_equal: 'Done' },\n    },\n    sorts: [\n      { property: 'Due date', direction: 'ascending' },\n    ],\n  });\n\n  console.log(`✓ Query returned ${response.results.length} result(s):`);\n  for (const page of response.results) {\n    const name     = page.properties.Name.title[0]?.plain_text     ?? '(untitled)';\n    const status   = page.properties.Status.select?.name           ?? 'none';\n    const priority = page.properties.Priority.select?.name         ?? 'none';\n    const due      = page.properties['Due date'].date?.start       ?? 'none';\n    const effort   = page.properties.Effort.number                 ?? 0;\n    console.log(`  • \"${name}\" | ${status} | ${priority} | due ${due} | effort ${effort}`);\n  }\n\n  return response;\n}\n\n// ─── Step 4: Create \"Audit Summary\" page ─────────────────────────────────────\n\nasync function step4_createSummaryPage(queryResponse) {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 4: Creating \"Audit Summary\" page');\n  console.log('═══════════════════════════════════════════════════');\n\n  // Trim the query response to just results for the code block (avoids rich-text size limit)\n  const codeContent = JSON.stringify(\n    queryResponse.results.map(p => ({\n      id: p.id,\n      properties: {\n        Name:       p.properties.Name.title[0]?.plain_text,\n        Status:     p.properties.Status.select?.name,\n        Priority:   p.properties.Priority.select?.name,\n        'Due date': p.properties['Due date'].date?.start,\n        Effort:     p.properties.Effort.number,\n      },\n    })),\n    null, 2\n  );\n\n  const summaryPage = await notion.pages.create({\n    parent: { type: 'page_id', page_id: TEST_PAGE_ID },\n    properties: {\n      title: [{ text: { content: 'Audit Summary' } }],\n    },\n    children: [\n      {\n        type: 'heading_1',\n        heading_1: {\n          rich_text: [{ type: 'text', text: { content: 'Notion Agent Experience Audit' } }],\n        },\n      },\n      {\n        type: 'paragraph',\n        paragraph: {\n          rich_text: [{ type: 'text', text: { content: 'This page summarises the results of a structured audit of the Notion API, testing database creation, entry management, querying, and rich page content.' } }],\n        },\n      },\n      {\n        type: 'bulleted_list_item',\n        bulleted_list_item: {\n          rich_text: [{ type: 'text', text: { content: '\"Write task prompts\" — completed (Done), high priority, due 2026-03-12, effort 2.' } }],\n        },\n      },\n      {\n        type: 'bulleted_list_item',\n        bulleted_list_item: {\n          rich_text: [{ type: 'text', text: { content: '\"Run Opus audit\" — in progress, high priority, due 2026-03-14, effort 4.' } }],\n        },\n      },\n      {\n        type: 'bulleted_list_item',\n        bulleted_list_item: {\n          rich_text: [{ type: 'text', text: { content: '\"Draft report\" — not yet started, medium priority, due 2026-03-18, effort 6.' } }],\n        },\n      },\n      {\n        type: 'code',\n        code: {\n          language: 'json',\n          rich_text: [{ type: 'text', text: { content: codeContent } }],\n        },\n      },\n      {\n        type: 'to_do',\n        to_do: {\n          rich_text: [{ type: 'text', text: { content: 'Review audit results' } }],\n          checked: false,\n        },\n      },\n    ],\n  });\n\n  console.log('✓ \"Audit Summary\" page created');\n  console.log('  ID:  ', summaryPage.id);\n  console.log('  URL: ', summaryPage.url);\n\n  // Verify by fetching blocks back\n  const blocks = await notion.blocks.children.list({ block_id: summaryPage.id });\n  console.log(`\\n✓ Verified — ${blocks.results.length} blocks written:`);\n  for (const b of blocks.results) {\n    const rt = b[b.type]?.rich_text;\n    const preview = rt?.[0]?.plain_text?.slice(0, 70) ?? '(no text)';\n    const checked = b.type === 'to_do' ? ` [checked: ${b.to_do.checked}]` : '';\n    console.log(`  [${b.type}] \"${preview}\"${checked}`);\n  }\n\n  return summaryPage;\n}\n\n// ─── Main ─────────────────────────────────────────────────────────────────────\n\nasync function main() {\n  const { dbId, dataSourceId } = await step1_createDatabase();\n  await step2_addEntries(dbId);\n  const queryResponse = await step3_query(dataSourceId);\n  await step4_createSummaryPage(queryResponse);\n  console.log('\\n✓ All steps complete.');\n}\n\nmain().catch(err => {\n  console.error('\\nFATAL:', err.code ?? err.status, '-', err.message);\n  if (err.body) console.error('Body:', err.body);\n  process.exit(1);\n});\n"
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚙️  suppress all logs with { quiet: true }
═══════════════════════════════════════════════════
STEP 1: Creating "Audit Tracker" database
═══════════════════════════════════════════════════
✓ Database created
  Database ID:     ac016f9c-0a9b-4bb0-b414-2c39d0993ba0
  Data Source ID:  7f47541b-3566-4e5d-84c5-160eaa36978e
  Title:           Audit Tracker
  URL:             https://www.notion.so/ac016f9c0a9b4bb0b4142c39d0993ba0

═══════════════════════════════════════════════════
STEP 2: Adding three database entries
═══════════════════════════════════════════════════
✓ Created: "Write task prompts"
  Page ID:  32226b2f-f6f1-81d4-bc45-d93de8dde93d
  Status:   Done
  Priority: High
  Due date: 2026-03-12
  Effort:   2
✓ Created: "Run Opus audit"
  Page ID:  32226b2f-f6f1-815c-b1bd-ff8386c5f7b7
  Status:   In progress
  Priority: High
  Due date: 2026-03-14
  Effort:   4
✓ Created: "Draft report"
  Page ID:  32226b2f-f6f1-81cb-8ed7-df219e10bfdb
  Status:   Not started
  Priority: Medium
  Due date: 2026-03-18
  Effort:   6

═══════════════════════════════════════════════════
STEP 3: Querying — Status ≠ "Done", sorted by Due date asc
═══════════════════════════════════════════════════
✓ Query returned 2 result(s):
  • "Run Opus audit" | In progress | High | due 2026-03-14 | effort 4
  • "Draft report" | Not started | Medium | due 2026-03-18 | effort 6

═══════════════════════════════════════════════════
STEP 4: Creating "Audit Summary" page
═══════════════════════════════════════════════════
✓ "Audit Summary" page created
  ID:   32226b2f-f6f1-818a-b03f-f96c4e0e6395
  URL:  https://www.notion.so/Audit-Summary-32226b2ff6f1818ab03ff96c4e0e6395

✓ Verified — 7 blocks written:
  [heading_1] "Notion Agent Experience Audit"
  [paragraph] "This page summarises the results of a structured audit of the Notion A"
  [bulleted_list_item] ""Write task prompts" — completed (Done), high priority, due 2026-03-12"
  [bulleted_list_item] ""Run Opus audit" — in progress, high priority, due 2026-03-14, effort "
  [bulleted_list_item] ""Draft report" — not yet started, medium priority, due 2026-03-18, eff"
  [code] "[
  {
    "id": "32226b2f-f6f1-815c-b1bd-ff8386c5f7b7",
    "propertie"
  [to_do] "Review audit results" [checked: false]

✓ All steps complete.

{
  "file_path": "~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/errors.js",
  "content": "require('dotenv').config();\nconst { Client } = require('@notionhq/client');\n\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// The database created in the previous task\nconst DB_ID = 'ac016f9c-0a9b-4bb0-b414-2c39d0993ba0';\nconst TEST_PAGE_ID = process.env.NOTION_TEST_PAGE_ID;\n\nfunction printError(label, err) {\n  console.log(`\\n--- Full error response ---`);\n  console.log('code:      ', err.code);\n  console.log('status:    ', err.status);\n  console.log('message:   ', err.message);\n  if (err.body) {\n    try {\n      const body = typeof err.body === 'string' ? JSON.parse(err.body) : err.body;\n      console.log('body:      ', JSON.stringify(body, null, 2));\n    } catch {\n      console.log('body (raw):', err.body);\n    }\n  }\n  console.log('requestId: ', err.headers?.['x-notion-request-id'] ?? err.requestId ?? '(none)');\n}\n\nasync function test1_invalidSelectOption() {\n  console.log('══════════════════════════════════════════════════════════════');\n  console.log('TEST 1: Add entry with non-existent Status option \"Cancelled\"');\n  console.log('══════════════════════════════════════════════════════════════');\n  try {\n    await notion.pages.create({\n      parent: { database_id: DB_ID },\n      properties: {\n        Name:   { title: [{ text: { content: 'Error test entry' } }] },\n        Status: { select: { name: 'Cancelled' } },   // does not exist\n      },\n    });\n    console.log('UNEXPECTED: call succeeded');\n  } catch (err) {\n    printError('test1', err);\n  }\n}\n\nasync function test2_unsharedPage() {\n  console.log('\\n══════════════════════════════════════════════════════════════');\n  console.log('TEST 2: Access a page not shared with the integration');\n  console.log('══════════════════════════════════════════════════════════════');\n  // Use a well-formed but unshared/non-existent page ID\n  const FAKE_ID = '11111111-2222-3333-4444-555555555555';\n  try {\n    await notion.pages.retrieve({ page_id: FAKE_ID });\n    console.log('UNEXPECTED: call succeeded');\n  } catch (err) {\n    printError('test2', err);\n  }\n}\n\nasync function test3_malformedBlock() {\n  console.log('\\n══════════════════════════════════════════════════════════════');\n  console.log('TEST 3: Append a block with an invalid type');\n  console.log('══════════════════════════════════════════════════════════════');\n  try {\n    await notion.blocks.children.append({\n      block_id: TEST_PAGE_ID,\n      children: [\n        {\n          type: 'super_heading',          // not a real block type\n          super_heading: {\n            rich_text: [{ type: 'text', text: { content: 'This type does not exist' } }],\n          },\n        },\n      ],\n    });\n    console.log('UNEXPECTED: call succeeded');\n  } catch (err) {\n    printError('test3', err);\n  }\n\n  console.log('\\n--- Also testing malformed content structure (missing rich_text) ---');\n  try {\n    await notion.blocks.children.append({\n      block_id: TEST_PAGE_ID,\n      children: [\n        {\n          type: 'paragraph',\n          paragraph: {\n            // rich_text is required but omitted entirely\n            color: 'red',\n          },\n        },\n      ],\n    });\n    console.log('UNEXPECTED: call succeeded');\n  } catch (err) {\n    printError('test3b', err);\n  }\n}\n\nasync function test4_invalidToken() {\n  console.log('\\n══════════════════════════════════════════════════════════════');\n  console.log('TEST 4: API call with an invalid token');\n  console.log('══════════════════════════════════════════════════════════════');\n  const badClient = new Client({ auth: 'secret_[REDACTED]' });\n  try {\n    await badClient.users.me();\n    console.log('UNEXPECTED: call succeeded');\n  } catch (err) {\n    printError('test4', err);\n  }\n}\n\nasync function main() {\n  await test1_invalidSelectOption();\n  await test2_unsharedPage();\n  await test3_malformedBlock();\n  await test4_invalidToken();\n  console.log('\\nAll error tests complete.');\n}\n\nmain().catch(err => {\n  console.error('Unhandled:', err.message);\n  process.exit(1);\n});\n"
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: 🔐 prevent committing .env to code: https://dotenvx.com/precommit
══════════════════════════════════════════════════════════════
TEST 1: Add entry with non-existent Status option "Cancelled"
══════════════════════════════════════════════════════════════
UNEXPECTED: call succeeded

══════════════════════════════════════════════════════════════
TEST 2: Access a page not shared with the integration
══════════════════════════════════════════════════════════════
@notionhq/client warn: request fail {
  code: 'validation_error',
  message: 'path failed validation: path.page_id should be a valid uuid, instead was `"11111111-2222-3333-4444-555555555555"`.',
  attempt: 0,
  requestId: '0bb6df49-e1f8-42cf-a165-e26b828e48cc'
}

--- Full error response ---
code:       validation_error
status:     400
message:    path failed validation: path.page_id should be a valid uuid, instead was `"11111111-2222-3333-4444-555555555555"`.
body:       {
  "object": "error",
  "status": 400,
  "code": "validation_error",
  "message": "path failed validation: path.page_id should be a valid uuid, instead was `\"11111111-2222-3333-4444-555555555555\"`.",
  "request_id": "0bb6df49-e1f8-42cf-a165-e26b828e48cc"
}
requestId:  (none)

══════════════════════════════════════════════════════════════
TEST 3: Append a block with an invalid type
══════════════════════════════════════════════════════════════
@notionhq/client warn: request fail {
  code: 'validation_error',
  message: 'body failed validation. Fix one:\n' +
    'body.children[0].embed should be defined, instead was `undefined`.\n' +
    'body.children[0].bookmark should be defined, instead was `undefined`.\n' +
    'body.children[0].image should be defined, instead was `undefined`.\n' +
    'body.children[0].video should be defined, instead was `undefined`.\n' +
    'body.children[0].pdf should be defined, instead was `undefined`.\n' +
    'body.children[0].file should be defined, instead was `undefined`.\n' +
    'body.children[0].audio should be defined, instead was `undefined`.\n' +
    'body.children[0].code should be defined, instead was `undefined`.\n' +
    'body.children[0].equation should be defined, instead was `undefined`.\n' +
    'body.children[0].divider should be defined, instead was `undefined`.\n' +
    'body.children[0].breadcrumb should be defined, instead was `undefined`.\n' +
    'body.children[0].table_of_contents should be defined, instead was `undefined`.\n' +
    'body.children[0].link_to_page should be defined, instead was `undefined`.\n' +
    'body.children[0].table_row should be defined, instead was `undefined`.\n' +
    'body.children[0].ai_block should be defined, instead was `undefined`.\n' +
    'body.children[0].meeting_notes should be defined, instead was `undefined`.\n' +
    'body.children[0].table should be defined, instead was `undefined`.\n' +
    'body.children[0].column_list should be defined, instead was `undefined`.\n' +
    'body.children[0].column should be defined, instead was `undefined`.\n' +
    'body.children[0].heading_1 should be defined, instead was `undefined`.\n' +
    'body.children[0].heading_2 should be defined, instead was `undefined`.\n' +
    'body.children[0].heading_3 should be defined, instead was `undefined`.\n' +
    'body.children[0].heading_4 should be defined, instead was `undefined`.\n' +
    'body.children[0].paragraph should be defined, instead was `undefined`.\n' +
    'body.children[0].bulleted_list_item should be defined, instead was `undefined`.\n' +
    'body.children[0].numbered_list_item should be defined, instead was `undefined`.\n' +
    'body.children[0].quote should be defined, instead was `undefined`.\n' +
    'body.children[0].to_do should be defined, instead was `undefined`.\n' +
    'body.children[0].toggle should be defined, instead was `undefined`.\n' +
    'body.children[0].template should be defined, instead was `undefined`.\n' +
    'body.children[0].callout should be defined, instead was `undefined`.\n' +
    'body.children[0].synced_block should be defined, instead was `undefined`.',
  attempt: 0,
  requestId: 'dac5965e-7a91-4163-9c39-4ffec5f4e16d'
}

--- Full error response ---
code:       validation_error
status:     400
message:    body failed validation. Fix one:
body.children[0].embed should be defined, instead was `undefined`.
body.children[0].bookmark should be defined, instead was `undefined`.
body.children[0].image should be defined, instead was `undefined`.
body.children[0].video should be defined, instead was `undefined`.
body.children[0].pdf should be defined, instead was `undefined`.
body.children[0].file should be defined, instead was `undefined`.
body.children[0].audio should be defined, instead was `undefined`.
body.children[0].code should be defined, instead was `undefined`.
body.children[0].equation should be defined, instead was `undefined`.
body.children[0].divider should be defined, instead was `undefined`.
body.children[0].breadcrumb should be defined, instead was `undefined`.
body.children[0].table_of_contents should be defined, instead was `undefined`.
body.children[0].link_to_page should be defined, instead was `undefined`.
body.children[0].table_row should be defined, instead was `undefined`.
body.children[0].ai_block should be defined, instead was `undefined`.
body.children[0].meeting_notes should be defined, instead was `undefined`.
body.children[0].table should be defined, instead was `undefined`.
body.children[0].column_list should be defined, instead was `undefined`.
body.children[0].column should be defined, instead was `undefined`.
body.children[0].heading_1 should be defined, instead was `undefined`.
body.children[0].heading_2 should be defined, instead was `undefined`.
body.children[0].heading_3 should be defined, instead was `undefined`.
body.children[0].heading_4 should be defined, instead was `undefined`.
body.children[0].paragraph should be defined, instead was `undefined`.
body.children[0].bulleted_list_item should be defined, instead was `undefined`.
body.children[0].numbered_list_item should be defined, instead was `undefined`.
body.children[0].quote should be defined, instead was `undefined`.
body.children[0].to_do should be defined, instead was `undefined`.
body.children[0].toggle should be defined, instead was `undefined`.
body.children[0].template should be defined, instead was `undefined`.
body.children[0].callout should be defined, instead was `undefined`.
body.children[0].synced_block should be defined, instead was `undefined`.
body:       {
  "object": "error",
  "status": 400,
  "code": "validation_error",
  "message": "body failed validation. Fix one:\nbody.children[0].embed should be defined, instead was `undefined`.\nbody.children[0].bookmark should be defined, instead was `undefined`.\nbody.children[0].image should be defined, instead was `undefined`.\nbody.children[0].video should be defined, instead was `undefined`.\nbody.children[0].pdf should be defined, instead was `undefined`.\nbody.children[0].file should be defined, instead was `undefined`.\nbody.children[0].audio should be defined, instead was `undefined`.\nbody.children[0].code should be defined, instead was `undefined`.\nbody.children[0].equation should be defined, instead was `undefined`.\nbody.children[0].divider should be defined, instead was `undefined`.\nbody.children[0].breadcrumb should be defined, instead was `undefined`.\nbody.children[0].table_of_contents should be defined, instead was `undefined`.\nbody.children[0].link_to_page should be defined, instead was `undefined`.\nbody.children[0].table_row should be defined, instead was `undefined`.\nbody.children[0].ai_block should be defined, instead was `undefined`.\nbody.children[0].meeting_notes should be defined, instead was `undefined`.\nbody.children[0].table should be defined, instead was `undefined`.\nbody.children[0].column_list should be defined, instead was `undefined`.\nbody.children[0].column should be defined, instead was `undefined`.\nbody.children[0].heading_1 should be defined, instead was `undefined`.\nbody.children[0].heading_2 should be defined, instead was `undefined`.\nbody.children[0].heading_3 should be defined, instead was `undefined`.\nbody.children[0].heading_4 should be defined, instead was `undefined`.\nbody.children[0].paragraph should be defined, instead was `undefined`.\nbody.children[0].bulleted_list_item should be defined, instead was `undefined`.\nbody.children[0].numbered_list_item should be defined, instead was `undefined`.\nbody.children[0].quote should be defined, instead was `undefined`.\nbody.children[0].to_do should be defined, instead was `undefined`.\nbody.children[0].toggle should be defined, instead was `undefined`.\nbody.children[0].template should be defined, instead was `undefined`.\nbody.children[0].callout should be defined, instead was `undefined`.\nbody.children[0].synced_block should be defined, instead was `undefined`.",
  "request_id": "dac5965e-7a91-4163-9c39-4ffec5f4e16d"
}
requestId:  (none)

--- Also testing malformed content structure (missing rich_text) ---
@notionhq/client warn: request fail {
  code: 'validation_error',
  message: 'body failed validation: body.children[0].paragraph.rich_text should be defined, instead was `undefined`.',
  attempt: 0,
  requestId: '9434e056-b19c-43e2-ac35-945c1ad676fa'
}

--- Full error response ---
code:       validation_error
status:     400
message:    body failed validation: body.children[0].paragraph.rich_text should be defined, instead was `undefined`.
body:       {
  "object": "error",
  "status": 400,
  "code": "validation_error",
  "message": "body failed validation: body.children[0].paragraph.rich_text should be defined, instead was `undefined`.",
  "request_id": "9434e056-b19c-43e2-ac35-945c1ad676fa"
}
requestId:  (none)

══════════════════════════════════════════════════════════════
TEST 4: API call with an invalid token
══════════════════════════════════════════════════════════════
@notionhq/client warn: request fail {
  code: 'unauthorized',
  message: 'API token is invalid.',
  attempt: 0,
  requestId: '002028d6-576a-4a5e-9302-38ec86615abe'
}

--- Full error response ---
code:       unauthorized
status:     401
message:    API token is invalid.
body:       {
  "object": "error",
  "status": 401,
  "code": "unauthorized",
  "message": "API token is invalid.",
  "request_id": "002028d6-576a-4a5e-9302-38ec86615abe"
}
requestId:  (none)

All error tests complete.

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// Check what happened in test 1 — did 'Cancelled' get created as a new option?\nnotion.dataSources.query({\n  data_source_id: '7f47541b-3566-4e5d-84c5-160eaa36978e',\n}).then(r => {\n  for (const page of r.results) {\n    const name   = page.properties.Name.title[0]?.plain_text;\n    const status = page.properties.Status.select?.name ?? 'null';\n    console.log(name, '->', status);\n  }\n  // Also check the data source schema for Status options\n  return notion.databases.retrieve({ database_id: 'ac016f9c-0a9b-4bb0-b414-2c39d0993ba0' });\n}).then(db => {\n  // The schema is on the data source; let's see what the DB retrieve returns\n  console.log('\\nDB retrieve keys:', Object.keys(db));\n  console.log('data_sources:', JSON.stringify(db.data_sources, null, 2));\n}).catch(e => console.error(e.message));\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: 🔐 encrypt with Dotenvx: https://dotenvx.com
Run Opus audit -> In progress
Error test entry -> Cancelled
Draft report -> Not started
Write task prompts -> Done

DB retrieve keys: [
  'object',       'id',
  'title',        'description',
  'parent',       'is_inline',
  'in_trash',     'is_locked',
  'created_time', 'last_edited_time',
  'data_sources', 'icon',
  'cover',        'url',
  'public_url',   'archived',
  'request_id'
]
data_sources: [
  {
    "id": "7f47541b-3566-4e5d-84c5-160eaa36978e",
    "name": "Audit Tracker"
  }
]

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// Clean up the 'Cancelled' test entry\nnotion.dataSources.query({ data_source_id: '7f47541b-3566-4e5d-84c5-160eaa36978e' })\n  .then(r => {\n    const bad = r.results.find(p => p.properties.Name.title[0]?.plain_text === 'Error test entry');\n    if (!bad) { console.log('Not found'); return; }\n    return notion.pages.update({ page_id: bad.id, in_trash: true })\n      .then(() => console.log('Trashed error test entry:', bad.id));\n  }).catch(e => console.error(e.message));\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// Test 2 retry: use a properly-formatted UUID that just isn't shared with the integration\n// Using a real-looking UUID that won't be in this workspace\nconst VALID_UNSHARED_ID = 'aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';\nnotion.pages.retrieve({ page_id: VALID_UNSHARED_ID })\n  .then(r => console.log('UNEXPECTED success:', r.id))\n  .catch(err => {\n    console.log('code:   ', err.code);\n    console.log('status: ', err.status);\n    console.log('message:', err.message);\n    console.log('body:   ', err.body);\n  });\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚙️  suppress all logs with { quiet: true }
@notionhq/client warn: request fail {
  code: 'validation_error',
  message: 'path failed validation: path.page_id should be a valid uuid, instead was `"aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee"`.',
  attempt: 0,
  requestId: '523679dc-83ed-4d36-8908-882d7988f280'
}
code:    validation_error
status:  400
message: path failed validation: path.page_id should be a valid uuid, instead was `"aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee"`.
body:    {"object":"error","status":400,"code":"validation_error","message":"path failed validation: path.page_id should be a valid uuid, instead was `\"aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee\"`.","request_id":"523679dc-83ed-4d36-8908-882d7988f280"}

{
  "command": "node -e \"\nrequire('dotenv').config();\nconst { Client } = require('@notionhq/client');\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\n\n// Properly formatted v4 UUID that doesn't exist in this workspace\nconst FAKE_V4_ID = 'a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d';\nnotion.pages.retrieve({ page_id: FAKE_V4_ID })\n  .then(r => console.log('UNEXPECTED success:', r.id))\n  .catch(err => {\n    console.log('code:   ', err.code);\n    console.log('status: ', err.status);\n    console.log('message:', err.message);\n    console.log('body:   ', JSON.stringify(JSON.parse(err.body), null, 2));\n  });\n\" 2>&1",
  "dangerouslyDisableSandbox": true
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: ⚡️ secrets for agents: https://dotenvx.com/as2
@notionhq/client warn: request fail {
  code: 'object_not_found',
  message: 'Could not find page with ID: a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d. Make sure the relevant pages and databases are shared with your integration.',
  attempt: 0,
  requestId: 'f5e32e77-8bb0-4c78-9aa5-ebb2bec9db6c'
}
code:    object_not_found
status:  404
message: Could not find page with ID: a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d. Make sure the relevant pages and databases are shared with your integration.
body:    {
  "object": "error",
  "status": 404,
  "code": "object_not_found",
  "message": "Could not find page with ID: a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d. Make sure the relevant pages and databases are shared with your integration.",
  "request_id": "f5e32e77-8bb0-4c78-9aa5-ebb2bec9db6c"
}

{
  "file_path": "~/dev/audits/notion-universal-baseline-2026-03-13-sonnet/notion-client/cleanup.js",
  "content": "require('dotenv').config();\nconst { Client } = require('@notionhq/client');\n\nconst notion = new Client({ auth: process.env.NOTION_TOKEN });\nconst TEST_PAGE_ID    = process.env.NOTION_TEST_PAGE_ID;\nconst DB_ID           = 'ac016f9c-0a9b-4bb0-b414-2c39d0993ba0';\nconst DATA_SOURCE_ID  = '7f47541b-3566-4e5d-84c5-160eaa36978e';\nconst SUMMARY_PAGE_ID = '32226b2f-f6f1-818a-b03f-f96c4e0e6395';\n\nasync function step1_trashEntries() {\n  console.log('═══════════════════════════════════════════════════');\n  console.log('STEP 1: Trash all entries in \"Audit Tracker\"');\n  console.log('═══════════════════════════════════════════════════');\n\n  const { results } = await notion.dataSources.query({ data_source_id: DATA_SOURCE_ID });\n  console.log(`Found ${results.length} entries.`);\n\n  for (const page of results) {\n    const name = page.properties.Name.title[0]?.plain_text ?? '(untitled)';\n    await notion.pages.update({ page_id: page.id, in_trash: true });\n    console.log(`✓ Trashed entry: \"${name}\" (${page.id})`);\n  }\n\n  // Verify: re-query should return 0 results\n  const verify = await notion.dataSources.query({ data_source_id: DATA_SOURCE_ID });\n  console.log(`✓ Verified: ${verify.results.length} entries remaining (in_trash entries excluded by default)`);\n}\n\nasync function step2_trashDatabase() {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 2: Trash the \"Audit Tracker\" database');\n  console.log('═══════════════════════════════════════════════════');\n\n  const db = await notion.databases.update({ database_id: DB_ID, in_trash: true });\n  console.log(`✓ Trashed database: \"${db.title[0]?.plain_text}\" (${db.id})`);\n  console.log(`  in_trash: ${db.in_trash}`);\n}\n\nasync function step3_trashSummaryPage() {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 3: Trash the \"Audit Summary\" page');\n  console.log('═══════════════════════════════════════════════════');\n\n  const page = await notion.pages.update({ page_id: SUMMARY_PAGE_ID, in_trash: true });\n  const title = page.properties.title?.title[0]?.plain_text ?? '(untitled)';\n  console.log(`✓ Trashed page: \"${title}\" (${page.id})`);\n  console.log(`  in_trash: ${page.in_trash}`);\n}\n\nasync function step4_verifyTestPage() {\n  console.log('\\n═══════════════════════════════════════════════════');\n  console.log('STEP 4: Verify test page has no remaining children');\n  console.log('═══════════════════════════════════════════════════');\n\n  const { results } = await notion.blocks.children.list({ block_id: TEST_PAGE_ID });\n\n  if (results.length === 0) {\n    console.log('✓ Test page is clean — no child blocks.');\n  } else {\n    console.log(`⚠ ${results.length} block(s) still present on test page:`);\n    for (const b of results) {\n      const text = b[b.type]?.rich_text?.[0]?.plain_text\n        ?? b[b.type]?.title?.[0]?.plain_text\n        ?? '(no text)';\n      console.log(`  [${b.type}] id=${b.id}  \"${text}\"`);\n    }\n  }\n}\n\nasync function main() {\n  await step1_trashEntries();\n  await step2_trashDatabase();\n  await step3_trashSummaryPage();\n  await step4_verifyTestPage();\n  console.log('\\n✓ Cleanup complete.');\n}\n\nmain().catch(err => {\n  console.error('\\nFATAL:', err.code ?? err.status, '-', err.message);\n  if (err.body) console.error('Body:', err.body);\n  process.exit(1);\n});\n"
}

[dotenv@17.3.1] injecting env (2) from .env -- tip: 🛠️  run anywhere with `dotenvx run -- yourcommand`
═══════════════════════════════════════════════════
STEP 1: Trash all entries in "Audit Tracker"
═══════════════════════════════════════════════════
Found 3 entries.
✓ Trashed entry: "Run Opus audit" (32226b2f-f6f1-815c-b1bd-ff8386c5f7b7)
✓ Trashed entry: "Draft report" (32226b2f-f6f1-81cb-8ed7-df219e10bfdb)
✓ Trashed entry: "Write task prompts" (32226b2f-f6f1-81d4-bc45-d93de8dde93d)
✓ Verified: 0 entries remaining (in_trash entries excluded by default)

═══════════════════════════════════════════════════
STEP 2: Trash the "Audit Tracker" database
═══════════════════════════════════════════════════
✓ Trashed database: "Audit Tracker" (ac016f9c-0a9b-4bb0-b414-2c39d0993ba0)
  in_trash: true

═══════════════════════════════════════════════════
STEP 3: Trash the "Audit Summary" page
═══════════════════════════════════════════════════
✓ Trashed page: "Audit Summary" (32226b2f-f6f1-818a-b03f-f96c4e0e6395)
  in_trash: true

═══════════════════════════════════════════════════
STEP 4: Verify test page has no remaining children
═══════════════════════════════════════════════════
✓ Test page is clean — no child blocks.

✓ Cleanup complete.