`notion.dataSources.query`

Preview rows of a Notion data source with simplified property values, optionally filtered by a title search. Paged with cursor. Properties whose names say they hold payment or tax details (bank, account, transit, institution and routing numbers, IBAN, SWIFT/BIC, Wise or Interac addresses, SIN, SSN, business or tax numbers) read as [hidden], and what they hold is hidden anywhere else in the rows too.

GETPOST/api/v1/accounting/notion.dataSources.query

Permissions

accounting:read

Who can call it

admin, finance

Retries

Safe to retry: it only reads

MCP

accounting_notion_data_sources_query

Reaches outside Oatmilk

It emails people or calls another service.

Fields

idstringRequired
The record's ID.
32–36 characters
searchstring
Text to search for.
at most 100 characters
cursorstring
Where the next page starts: the nextCursor value from the previous response.
1–200 characters
limitinteger
How many results to return at most.
1 to 50 · Default 20

curl -G https://app.getoatmilk.com/api/v1/accounting/notion.dataSources.query \
  -H "Authorization: Bearer $OATMILK_API_KEY" \
  --data-urlencode 'id=9f2b5c1d7e3a4b6c8d0e2f4a6b8c0d2e'

const response = await fetch("https://app.getoatmilk.com/api/v1/accounting/notion.dataSources.query?id=9f2b5c1d7e3a4b6c8d0e2f4a6b8c0d2e", {
  headers: {
    Authorization: `Bearer ${process.env.OATMILK_API_KEY}`,
  },
});
const { data, error } = await response.json();
if (!response.ok) throw new Error(`${error.code}: ${error.message}`);
console.log(data);

import os

import requests

response = requests.get(
    "https://app.getoatmilk.com/api/v1/accounting/notion.dataSources.query",
    headers={
        "Authorization": f"Bearer {os.environ['OATMILK_API_KEY']}",
    },
    params={
        "id": "9f2b5c1d7e3a4b6c8d0e2f4a6b8c0d2e",
    },
    timeout=30,
)
payload = response.json()
if not response.ok:
    raise RuntimeError(f"{payload['error']['code']}: {payload['error']['message']}")
print(payload["data"])

Response

{
  "data": { … }
}

Try it

Checks your input with this action’s real schema and answers like the API, with synthetic data. No key needed, and nothing changes.

Input

GET/api/v1/accounting/notion.dataSources.query

curl -G https://app.getoatmilk.com/api/v1/accounting/notion.dataSources.query \
  -H "Authorization: Bearer $OATMILK_API_KEY" \
  --data-urlencode 'id=9f2b5c1d7e3a4b6c8d0e2f4a6b8c0d2e'

const response = await fetch("https://app.getoatmilk.com/api/v1/accounting/notion.dataSources.query?id=9f2b5c1d7e3a4b6c8d0e2f4a6b8c0d2e", {
  headers: {
    Authorization: `Bearer ${process.env.OATMILK_API_KEY}`,
  },
});
const { data, error } = await response.json();
if (!response.ok) throw new Error(`${error.code}: ${error.message}`);
console.log(data);

import os

import requests

response = requests.get(
    "https://app.getoatmilk.com/api/v1/accounting/notion.dataSources.query",
    headers={
        "Authorization": f"Bearer {os.environ['OATMILK_API_KEY']}",
    },
    params={
        "id": "9f2b5c1d7e3a4b6c8d0e2f4a6b8c0d2e",
    },
    timeout=30,
)
payload = response.json()
if not response.ok:
    raise RuntimeError(f"{payload['error']['code']}: {payload['error']['message']}")
print(payload["data"])

Fields

Example

Try it