Search bills

get

https://{tenant}.onechurchsoftware.com/api/bills

Retrieve the bills (payables) or invoices (receivables) matching the given filters. The type parameter selects which of the two record types is searched.

Required permission: Full Read Accounting

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

type

int32

required

The record type to search: 1 = bills (payables), 2 = invoices (receivables).

entry

int32

≥ 1

Return the single bill with this id.

memo

string

Return bills whose memo contains the given text.

reference

string

Return bills whose reference (or invoice number) contains the given text.

repeating

boolean

If true, returns repeating bill templates; if false, only one-time bills.

paid

boolean

If true, returns only fully paid bills; if false, only bills with a remaining amount.

payee

int32

≥ 1

The id of a payee (vendor or customer). Returns bills for that payee.

due.start

date-time

Return bills due on or after this date.

due.end

date-time

Return bills due on or before this date.

status

string

Comma-delimited list of status values: 1 = Not Yet Due (due more than 14 days out), 2 = Upcoming (due within the next 14 days, including past-due bills), 3 = Past Due, 4 = Paid, 5 = Written Off.

account

string

Comma-delimited list of account ids. Returns bills with a line item posted to one of those accounts.

fund

string

Comma-delimited list of fund ids. Returns bills with a line item in one of those funds.

tags

string

Comma-delimited list of accounting tag ids. Returns bills with a line item carrying one of those tags.

skip

int32

≥ 0

The number of records to skip before returning results, used for paging.

limit

int32

≥ 0

The maximum number of records to return per page. Defaults to 50.

sort.property

string

The field to sort the results by. The default field depends on the endpoint.

sort.dir

string

enum

The sort direction: "asc" or "desc".

Allowed:

Headers

string

enum

Defaults to application/json

Generated from available response content types

Allowed:

Responses

401

Authentication is required, or the Ocs-Api-Key header is missing or invalid.

Language

Credentials

Header

URL

Loading…

Response

Click Try It! to start a request and see the response here! Or choose an example:

text/plain

application/json

text/json

200OK