# 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.

`GET | POST /api/v1/accounting/dataSources.rows`

Permissions: `accounting:read` · Roles: admin, finance

MCP tool: `accounting_data_sources_rows`

## Fields

| Field | Type | Required | Notes |
| --- | --- | --- | --- |
| `source` | enum | Yes | Where the record came from. One of: `notion`, `google_drive`, `onedrive`. |
| `databaseId` | string | Yes | 1–200 characters; Matches ^[A-Za-z0-9_.:-]+$. |
| `cursor` | string |  | Where the next page starts: the nextCursor value from the previous response. 1–500 characters. |
| `limit` | integer |  | How many results to return at most. 1 to 100. Default `50`. |
| `search` | string |  | Text to search for. at most 100 characters. |
| `sortBy` | string |  | Which field to sort by. 1–200 characters. |
| `sortDirection` | enum |  | asc for oldest or smallest first, desc for newest or largest first. One of: `ascending`, `descending`. Default `"descending"`. |
| `withFiles` | boolean |  |  |
| `target` | enum |  | One of: `receipts`, `tax_sources`, `signing_files`, `executed_agreements`, `contractor_agreements`, `company_documents`. |

## Example request

```bash
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'
```

Reference page: https://app.getoatmilk.com/docs/api/dataSources.rows