List all expenses

Updated:

GET/accounting/{connection_id}/expense

Returns a list of AccountingExpenses. Narrow the results with the query parameters before paging, then page through them with `limit` and `offset` (the default and maximum page size depend on the integration). Use `fields` to return only the fields you need and reduce the response size. When the integration supports a total count, it is returned in the `X-Total-Count` response header. Use each item's `id` to retrieve, update, or delete it where those operations are supported.

Parameters

limitnumber default=100
offsetnumber default=0
updated_gtedate-time
Return only results whose updated date is equal or greater to this value (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
sort enum
order enum
querystring
Query string to search. eg. email address or name
user_idstring
The user/employee ID to filter by (reference to HrisEmployee)
approver_user_idstring
The expense approver user/employee ID to filter by (reference to HrisEmployee)
start_gtestring
The start date to filter by (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
end_ltstring
The end date to filter by (ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
contact_idstring
The contact ID to filter by (reference to AccountingContact)
category_idstring
The category ID to filter by (reference to AccountingCategory)
group_idstring
The group ID to filter by (reference to HrisGroup)
org_idstring
The org ID to filter by (reference to AccountingOrganization)
status enum
type enum
fieldsstring array
Fields to return
rawstring
Raw parameters to include in the 3rd-party request. Encoded as a URL component. eg. raw parameters: foo=bar&zoo=bar -> raw=foo%3Dbar%26zoo%3Dbar
connection_idstring required
ID of the connection

Returns

idstring
created_atdate-time
(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
updated_atdate-time
(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
user_idstring
references a HR employee/user (reference to HrisEmployee)
contact_idstring
(reference to AccountingContact)
account_idstring
(reference to AccountingAccount)
namestring
payment_methodstring
posted_atdate-time
(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
total_amountnumber
currencystring
tax_amountnumber
reimbursed_amountnumber
reimbursed_atdate-time
(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
approved_atdate-time
(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
approver_user_idstring
references HR employee/user (reference to HrisEmployee)
lineitems array
attachments array
organization_idstring
users array
approver_users array
expense approver(s); id is HR employee/user when resolved
status enum
Valid values:
"DRAFT"
"SUBMITTED"
"PENDING"
"APPROVED"
"REJECTED"
external_numberstring
category_idsstring array
(reference to AccountingCategory)
project_idstring
(reference to TaskProject)
metadata array
taxrate_idstring
ref -> AccountingTaxrate applied to the expense
exchange_ratenumber
Exchange rate to the base/home currency at the expense date
type enum
Valid values:
"USER"
"COMPANY"
USER = employee spend; COMPANY = books/purchase expense

Errors

Errors return the HTTP status code and a JSON body with statusCode, error (the short label) and message (a human-readable detail).

{
  "statusCode": 429,
  "error": "Too Many Requests",
  "message": "Too many requests to unified.to API; max requests per minute: N"
}
StatusErrorMeaning
400Bad RequestThe request was malformed or failed validation.
401UnauthorizedThe connection is likely broken; re-authorize it.
403ForbiddenThe connection is missing permissions or scopes.
404Not FoundThe requested resource does not exist.
429Too Many RequestsRate limit exceeded (see the two sources below).
500Internal Server ErrorAn unexpected error occurred.
501Not ImplementedNot supported by this integration.

Errors from the underlying integration pass through: the integration's status comes back as ours (429, 401, 403, 404 or 5xx), usually with its message. When the integration's error body is unclear, Unified extracts what it can and returns a clearer message.

429 Too Many Requests

A 429 has two possible sources:

  • The integration's own rate limit, passed through.
  • Unified's workspace limit: a rolling 60 seconds, set by plan, with the message Too many requests to unified.to API; max requests per minute: N.
const options = {
  method: 'GET',
  url: 'https://api.unified.to/accounting/5de520f96e439b002043d8dc/expense',
  headers: {
    authorization: 'bearer .....'
  },
  params: {
    limit: 50,
    offset: 0,
    updated_gte: '2026-10-23T21:39:36.191Z',
    sort: 'updated_at',
    order: 'asc',
    query: '',
    user_id: '',
    approver_user_id: '',
    start_gte: '',
    end_lt: '',
    contact_id: '',
    category_id: '',
    group_id: '',
    org_id: '',
    status: '',
    type: '',
    fields: '',
    raw: '',
  }
};

const results = await axios.request(options);
Are we missing anything? Let us know
Was this page helpful?