Analytics

Deprecated
GET
/payables/analytics

Retrieve aggregated statistics for payables, including total amount and count, both overall and by status.

For more flexible configuration and retrieval of other data types, use GET /analytics/payables.

Headers

Auth
AuthorizationstringRequired
Bearer authentication of the form Bearer <token>, where token is your auth token.
x-monite-versionstringRequired
x-monite-entity-idstringRequired

The ID of the entity that owns the requested resource.

Query parameters

created_at__gtdatetimeOptional

Return only payables created in Monite after the specified date and time. The value must be in the ISO 8601 format YYYY-MM-DDThh:mm[:ss[.ffffff]][Z|±hh:mm].

created_at__ltdatetimeOptional

Return only payables created in Monite before the specified date and time.

created_at__gtedatetimeOptional

Return only payables created in Monite on or after the specified date and time.

created_at__ltedatetimeOptional

Return only payables created in Monite before or on the specified date and time.

statusenumOptional

Return only payables that have the specified status.

To query multiple statuses at once, use the status__in parameter instead.

status__inenumOptional

Return only payables that have the specified statuses.

To specify multiple statuses, repeat this parameter for each value: status__in=draft&status__in=new

id__instringOptional

Return only payables with specified IDs. Valid but nonexistent IDs do not raise errors but produce no results.

To specify multiple IDs, repeat this parameter for each value: id__in=<id1>&id__in=<id2>

total_amountintegerOptional

Return only payables with the exact specified total amount. The amount must be specified in the minor units of currency. For example, $12.5 is represented as 1250.

total_amount__gtintegerOptional

Return only payables whose total amount (in minor units) exceeds the specified value.

total_amount__ltintegerOptional

Return only payables whose total amount (in minor units) is less than the specified value.

total_amount__gteintegerOptional

Return only payables whose total amount (in minor units) is greater than or equal to the specified value.

total_amount__lteintegerOptional

Return only payables whose total amount (in minor units) is less than or equal to the specified value.

amountintegerOptional

Return only payables with the specified amount.

amount__gtintegerOptional

Return only payables whose amount (in minor units) exceeds the specified value.

amount__ltintegerOptional

Return only payables whose amount (in minor units) is less than the specified value.

amount__gteintegerOptional

Return only payables whose amount (in minor units) is greater than or equal to the specified value.

amount__lteintegerOptional

Return only payables whose amount (in minor units) is less than or equal to the specified value.

currencyenumOptional

Return only payables that use the specified currency.

counterpart_namestringOptional

Return only payables received from counterparts with the specified name (exact match, case-sensitive).

For counterparts of type = individual, the full name is formatted as first_name last_name.

counterpart_name__containsstringOptional

Return only payables received from counterparts whose name contains the specified string (case-sensitive).

counterpart_name__icontainsstringOptional

Return only payables received from counterparts whose name contains the specified string (case-insensitive).

search_textstringOptional

Apply the icontains condition to search for the specified text in the document_id and counterpart_name fields in the payables.

due_datestringOptional

Return payables that are due on the specified date (YYYY-MM-DD)

due_date__gtstringOptional

Return payables that are due after the specified date (exclusive, YYYY-MM-DD).

due_date__ltstringOptional

Return payables that are due before the specified date (exclusive, YYYY-MM-DD).

due_date__gtestringOptional

Return payables that are due on or after the specified date (YYYY-MM-DD).

due_date__ltestringOptional

Return payables that are due before or on the specified date (YYYY-MM-DD).

document_idstringOptional

Return a payable with the exact specified document number (case-sensitive).

The document_id is the user-facing document number such as INV-00042, not to be confused with Monite resource IDs (id).

document_id__containsstringOptional

Return only payables whose document number (document_id) contains the specified string (case-sensitive).

document_id__icontainsstringOptional

Return only payables whose document number (document_id) contains the specified string (case-insensitive).

was_created_by_user_idstringOptional

Return only payables created in Monite by the entity user with the specified ID.

counterpart_idstringOptional

Return only payables received from the counterpart with the specified ID.

Counterparts that have been deleted but have associated payables will still return results here because the payables contain a frozen copy of the counterpart data.

If the specified counterpart ID does not exist and never existed, no results are returned.

source_of_payable_data"ocr" or "user_specified"Optional

Return only payables coming from the specified source.

Allowed values: ocruser_specified
ocr_statusenumOptional

Return only payables with specific OCR statuses.

Allowed values: processingerrorsuccesscanceled
line_item_idstringOptional

Search for a payable by the identifier of the line item associated with it.

purchase_order_idstringOptional

Search for a payable by the identifier of the purchase order associated with it.

project_idstringOptional

Return only payables assigned to the project with the specified ID.

Valid but nonexistent project IDs do not raise errors but return no results.

tag_idsstringOptional

Return only payables whose tags include at least one of the tags with the specified IDs. Valid but nonexistent tag IDs do not raise errors but produce no results.

Response

Successful Response

countinteger

The total count of payables across all statuses.

datalist of objects

A list of aggregated items, each representing a status with its associated sum of the amount field and count.

sum_total_amountinteger

The total sum of the amount field for all payables across all statuses.

Errors