# dataSources.schema

Read a database's columns with their types, options, number formats (and the currency they imply), related databases, and the columns suggested for a first view. Columns whose names say they hold payment or tax details list no options and can't be sorted or searched by.

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

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

MCP tool: `accounting_data_sources_schema`

## 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_.:-]+$. |

## Example request

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

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