MEmercurytechnologies
Books

List all journal entries

Changed on
get/books/journal-entries/{booksId}

Request

Path parameters

booksIdstring uuid required

Query parameters

startDatestring date

Only return Journal Entries after the start date (inclusive).

endDatestring date

Only return Journal Entries before the end date (inclusive).

ledgerIdstring base58 (max length 22)

Only return Journal Entries where at least one Line Entry belongs to the specified Ledger.

Example:7JRNsKwy2Lw66caxVU7WGC
creationSource'manual' | 'transaction' | 'accrual' | 'paymentApplication' | 'legacy'

Only return Journal Entries with the specified creation source.

journalEntrySort'descriptionAsc' | 'descriptionDesc' | 'dateTimeAsc' | 'dateTimeDesc' | 'amountAsc' | 'amountDesc' | 'creationDateAsc' | 'creationDateDesc' | 'transactionSourceAccountAsc' | 'transactionSourceAccountDesc' | 'transactionContraLedgerAsc' | 'transactionContraLedgerDesc' | 'tagNameAsc' | 'tagNameDesc' | 'debitLedgerAsc' | 'debitLedgerDesc' | 'creditLedgerAsc' | 'creditLedgerDesc' | 'reconciliationContraLedgerAsc' | 'reconciliationContraLedgerDesc'

The sort order for the results.

expand'lineEntries' | 'lineEntriesTransactions' | 'lineEntriesLedger' | 'lineEntriesOpposingLedgerIds' | 'lineEntriesPaymentApplications' | 'lineEntriesLinePaymentApplications' | 'accrualSource' | 'transfer' | 'autocatResult'

Comma-separated list of expandable paths.

pageTokenstring

token for pagination

keywordsstring

Only return Journal Entries where the description matches the specified keyword(s).

amountnumber double

Only return journal entries with the specified monetary amount. If specified, minAmount and maxAmount parameters are ignored. If no decimal place provided, rounded values will be matched. E.g. an input of 100 will match 100.13 and 100.45, but an input of 100.13 will only match that value.

minAmountnumber double

Only return journal entries with a monetary amount of at least the specified amount. Ignored if amount is set.

maxAmountnumber double

Only return journal entries with a monetary amount less than specified amount. Ignored if amount is set.

ledgerIdGroupsstring[]

One or more comma-separated lists of ledger IDs. Only return Journal Entries where at least one Line Entry belongs to one of the specified ledgers in a group. Specifying multiple groups will return an intersection of the matches.

[
  "7JRNsKwy2Lw66caxVU7WGC"
]
limitinteger

The maximum number of journal entries to return per page.

categorizationStatusstring[]

Comma-separated list of categorization statuses ('pending', 'delayed', 'completed', 'notAttempted'). Only return Journal Entries whose categorization status matches one of the specified values.

reviewStatusstring[]

Comma-separated list of review statuses ('unreviewed', 'reviewed'). Only return Journal Entries whose review status matches one of the specified values.

categorizationMethodstring[]

Comma-separated list of categorization methods ('ai', 'rule', 'user', 'matched', 'uncategorized'). Only return Journal Entries that were categorized by one of the specified methods. 'ai' matches every automatic method except 'rule'; 'user' matches Journal Entries with no live automatic categorization; 'matched' matches payment-application Journal Entries; 'uncategorized' matches Journal Entries with a Line Entry on an Uncategorized ledger. The other values never match the last two.

Response

nextPageTokenstring nullable

Token to fetch the next page of results

prevPageTokenstring nullable

Token to fetch the previous page of results

Changes