v1

latestOpenAPI 3.1.02026-08-0458234268.6 KB

catalog

List catalog variances

Returns catalog entries with price variance information from invoice items. By default, returns all items that had purchases in the specified period, including items with zero variance. Use variance_only=true to return only entries with non-zero variance. Use expand=invoice_items to include all invoice items inline (otherwise only the most recent invoice item is returned).

get/catalog/variances

Query parameters

ottimate_company_idinteger required

Filter by company ID (required)

variance_onlyboolean

If true, returns only entries with non-zero variance. Default: false (returns all items including zero variance)

expandstring

Comma-separated list of fields to expand. Supports 'invoice_items' to include all invoice items for each entry.

invoice_start_datestring date

Start of date range (YYYY-MM-DD)

invoice_end_datestring date

End of date range (YYYY-MM-DD)

erp_vendor_idsstring

Comma-separated ERP vendor IDs (accounting vendor IDs) to filter variances by vendor.

ottimate_location_idsstring

Comma-separated location IDs

exception_type'underbilling' | 'overbilling'

Filter by variance type

pageinteger

Page number for pagination

limitinteger

Number of items per page

Headers

Authorizationstring required

OAuth2 authentication flows. Auth server URLs will vary by environment

X-Api-Keystring required

API key for authentication

X-API-Versionstring

API version to use (optional, defaults to latest). Supported values: 1.0.0, 1.1.0.

Response

Successful response with paginated variance list

countinteger required