`dataImports.suggest`

Suggest a column of a connected database (Notion) for each field of an import target, with a sample value per column, the status options found, and the mapping remembered for that database. Supply target, source and databaseId. A column whose name says it holds payment or tax details is marked sensitive, has no sample or options, and is never suggested or imported.

GETPOST/api/v1/accounting/dataImports.suggest

Permissions

accounting:read

Who can call it

admin, finance

Retries

Safe to retry: it only reads

MCP

accounting_data_imports_suggest

Fields

targetenumRequired
invoicescontractor_payments
sourceenum
Where the record came from.
notion
Default "notion"
databaseIdstringRequired
1–200 characters

curl -G https://app.getoatmilk.com/api/v1/accounting/dataImports.suggest \
  -H "Authorization: Bearer $OATMILK_API_KEY" \
  --data-urlencode 'target=invoices' \
  --data-urlencode 'databaseId=example'

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

curl -G https://app.getoatmilk.com/api/v1/accounting/dataImports.suggest \
  -H "Authorization: Bearer $OATMILK_API_KEY" \
  --data-urlencode 'target=invoices' \
  --data-urlencode 'databaseId=example'

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