`dataSources.rows`

Read rows of a database with readable, typed values for every column: text, numbers with their format, dates, options, people, related page titles, checkboxes, links and attached files. Supports search, sort by a column, only rows with files, and cursor paging. With target, files already imported there are marked. File download addresses are never returned. Columns 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], what they hold is hidden anywhere else in the rows too, and they're never searched or sorted by.

GETPOST/api/v1/accounting/dataSources.rows

Permissions

accounting:read

Who can call it

admin, finance

Retries

Safe to retry: it only reads

MCP

accounting_data_sources_rows

Fields

sourceenumRequired
Where the record came from.
notiongoogle_driveonedrive
databaseIdstringRequired
1–200 characters · Matches ^[A-Za-z0-9_.:-]+$
cursorstring
Where the next page starts: the nextCursor value from the previous response.
1–500 characters
limitinteger
How many results to return at most.
1 to 100 · Default 50
searchstring
Text to search for.
at most 100 characters
sortBystring
Which field to sort by.
1–200 characters
sortDirectionenum
asc for oldest or smallest first, desc for newest or largest first.
ascendingdescending
Default "descending"
withFilesboolean
targetenum
receiptstax_sourcessigning_filesexecuted_agreementscontractor_agreementscompany_documents

curl -G https://app.getoatmilk.com/api/v1/accounting/dataSources.rows \
  -H "Authorization: Bearer $OATMILK_API_KEY" \
  --data-urlencode 'source=notion' \
  --data-urlencode 'databaseId=database_id'

const response = await fetch("https://app.getoatmilk.com/api/v1/accounting/dataSources.rows?source=notion&databaseId=database_id", {
  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/dataSources.rows",
    headers={
        "Authorization": f"Bearer {os.environ['OATMILK_API_KEY']}",
    },
    params={
        "source": "notion",
        "databaseId": "database_id",
    },
    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/dataSources.rows

curl -G https://app.getoatmilk.com/api/v1/accounting/dataSources.rows \
  -H "Authorization: Bearer $OATMILK_API_KEY" \
  --data-urlencode 'source=notion' \
  --data-urlencode 'databaseId=database_id'

const response = await fetch("https://app.getoatmilk.com/api/v1/accounting/dataSources.rows?source=notion&databaseId=database_id", {
  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/dataSources.rows",
    headers={
        "Authorization": f"Bearer {os.environ['OATMILK_API_KEY']}",
    },
    params={
        "source": "notion",
        "databaseId": "database_id",
    },
    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