Search journal entries

get

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

Retrieve the general ledger journal entries matching the given filters, most recent first.

Required permission: Full Read Accounting

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

entry

int32

≥ 1

Return the single journal entry with this id.

date.start

date

Return entries dated on or after this date.

date.end

date

Return entries dated on or before this date.

account

string

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

type

string

Comma-delimited list of entry kinds: 3 = Account Transfer, 4 = Fund Transfer, 5 = Batch Posting, 6 = Starting Balance, 7 = Journal Entry, 8 = Bill Payment.

fund

string

The id of a single fund. Returns entries with a line item in that fund. Only one fund id is supported.

tags

string

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

method

string

Comma-delimited list of payment method ids. Use -1 to include entries without a payment method. Values come from /api/property_values/accounting_payment_methods/values.

status

string

Comma-delimited list of status ids or codes (je_status_draft, je_status_posted, je_status_voided).

amount.start

double

Return entries with a total of at least this amount.

amount.end

double

Return entries with a total of at most this amount.

payee

string

Return entries with a line item payee whose name contains the given text.

memo

string

Return entries whose memo or line item descriptions contain the given text.

reference

string

Return entries whose entry number or reference matches the given value exactly.

reconciled

boolean

If true, returns only reconciled entries; if false, only unreconciled entries.

perspective

int32

≥ 1

The id of an account. Returns entries with a line item posted to that account.

payeeId

int32

≥ 1

The id of a payee (person or business). Returns entries with a line item for that payee.

created.start

date-time

Return entries created on or after this date and time.

created.end

date-time

Return entries created on or before this date and time.

modified.start

date-time

Return entries modified on or after this date and time.

modified.end

date-time

Return entries modified on or before this date and time.

createdBy

string

Return entries created by users whose name contains the given text.

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