Receivables

Search receivables

This is a POST version of the GET /receivables endpoint. Use it to send search and filter parameters in the request body instead of the URL query string in case the query is too long and exceeds the URL length limit of your HTTP client.

post/receivables/search

Request

  • Base URL: https://api.sandbox.monite.com/v1
  • URL: https://api.sandbox.monite.com/v1/receivables/search
  • Auth: HTTP bearer

Headers

x-monite-versionstring required
x-monite-entity-idstring required

The ID of the entity that owns the requested resource.

Request body

based_onstring uuid

This parameter accepts a quote ID or an invoice ID.

  • Specify a quote ID to find invoices created from this quote.
  • Specify an invoice ID to find credit notes created for this invoice.

Valid but nonexistent IDs do not raise errors but produce no results.

counterpart_idstring uuid

Return only receivables created for the counterpart with the specified ID.

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

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

counterpart_namestring

Return only receivables created for 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__containsstring

Return only receivables created for counterparts whose name contains the specified string (case-sensitive).

counterpart_name__icontainsstring

Return only receivables created for counterparts whose name contains the specified string (case-insensitive).

created_at__gtstring date-time

Return only receivables created after the specified date and time. The value must be in the ISO 8601 format YYYY-MM-DDThh:mm[:ss][Z|±hh:mm]. The milliseconds part of the value is ignored.

created_at__gtestring date-time

Return only receivables created on or after the specified date and time. The milliseconds part of the value is ignored.

created_at__ltstring date-time

Return only receivables created before the specified date and time. The milliseconds part of the value is ignored.

created_at__ltestring date-time

Return only receivables created before or on the specified date and time. The milliseconds part of the value is ignored.

discounted_subtotalinteger

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

discounted_subtotal__gtinteger

Return only receivables whose discounted subtotal (in minor units) is greater than the specified value.

discounted_subtotal__gteinteger

Return only receivables whose discounted subtotal (in minor units) is greater than or equal to the specified value.

discounted_subtotal__ltinteger

Return only receivables whose discounted subtotal (in minor units) is less than the specified value.

discounted_subtotal__lteinteger

Return only receivables whose discounted subtotal (in minor units) is less than or equal to the specified value.

document_idstring

Return a receivable 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__containsstring

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

document_id__icontainsstring

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

due_date__gtstring date

Return receivables whose due date is after the specified date (exclusive, YYYY-MM-DD).

This filter includes invoices and credit notes (only those with a due date) and excludes quotes.

due_date__gtestring date

Return receivables whose due date is on or after the specified date (YYYY-MM-DD).

This filter includes invoices and credit notes (only those with a due date) and excludes quotes.

due_date__ltstring date

Return receivables whose due date is before the specified date (exclusive, YYYY-MM-DD).

This filter includes invoices and credit notes (only those with a due date) and excludes quotes.

due_date__ltestring date

Return receivables whose due date is before or on the specified date (YYYY-MM-DD).

This filter includes invoices and credit notes (only those with a due date) and excludes quotes.

entity_user_idstring uuid

Return only receivables created by the entity user with the specified ID. To query receivables by multiple user IDs at once, use the entity_user_id__in parameter instead.

If the request is authenticated using an entity user token, this user must have the receivable.read.allowed (rather than allowed_for_own) permission to be able to query receivables created by other users.

IDs of deleted users will still produce results here if those users had associated receivables. Valid but nonexistent user IDs do not raise errors but produce no results.

entity_user_id__instring[]

Return only receivables created by the entity users with the specified IDs.

If the request is authenticated using an entity user token, this user must have the receivable.read.allowed (rather than allowed_for_own) permission to be able to query receivables created by other users.

IDs of deleted users will still produce results here if those users had associated receivables. Valid but nonexistent user IDs do not raise errors but produce no results.

has_due_dateboolean

If true, returns only invoices and credit notes that have the due_date defined.

If false, returns receivables (invoices, quotes, credit notes) without a due_date.

If omitted (default), all receivables are included.

id__instring[]

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

issue_date__gtstring date-time

Return only non-draft receivables that were issued after the specified date and time. The value must be in the ISO 8601 format YYYY-MM-DDThh:mm[:ss][Z|±hh:mm]. The milliseconds part of the value is ignored.

issue_date__gtestring date-time

Return only non-draft receivables that were issued on or after the specified date and time. The milliseconds part of the value is ignored.

issue_date__ltstring date-time

Return only non-draft receivables that were issued before the specified date and time. The milliseconds part of the value is ignored.

issue_date__ltestring date-time

Return only non-draft receivables that were issued before or on the specified date and time. The milliseconds part of the value is ignored.

limitinteger

The number of items (0 .. 250) to return in a single page of the response. Default is 100. The response may contain fewer items if it is the last or only page.

When using pagination with a non-default limit, you must provide the limit value alongside pagination_token in all subsequent pagination requests. Unlike other pagination parameters, limit is not inferred from pagination_token.

order'asc' | 'desc'
pagination_tokenstring

A pagination token obtained from a previous call to GET /receivables or POST /receivables/search. Use it to get the next or previous page of results for your initial query. If pagination_token is specified, all other parameters except limit are ignored and inferred from the initial query.

If not specified, the first page of results will be returned.

product_idsstring[]

Return only receivables with line items containing all of the products with the specified IDs and optionally other products that are not specified.

For example, given receivables that contain the following products:

  1. productA
  2. productB
  3. productA, productB
  4. productC
  5. productA, productB, productC

product_ids = [productA, productB] will return receivables 3 and 5.

Valid but nonexistent product IDs do not raise errors but produce no results.

product_ids__instring[]

Return only receivables with line items containing at least one of the products with the specified IDs.

For example, given receivables that contain the following products:

  1. productA
  2. productB
  3. productA, productB
  4. productC
  5. productB, productC

product_ids__in = [productA, productB] will return receivables 1, 2, 3, and 5.

Valid but nonexistent product IDs do not raise errors but produce no results.

project_idstring uuid

Return only receivables assigned to the project with the specified ID. Valid but nonexistent project IDs do not raise errors but return no results.

project_id__instring[]

Return only receivables that belong to one of the projects with the specified IDs. Valid but nonexistent project IDs do not raise errors but produce no results.

search_textstring

Searches for the specified substring in the counterpart_name and document_id fields in receivables. The search is case-insensitive and allows partial matches. For example, abc will match 12-ABCD.

sort'counterpart_name' | 'counterpart_id' | 'amount' | 'total_amount' | 'status' | 'due_date' | 'issue_date' | 'document_id' | 'created_at' | 'project_id'
status'draft' | 'issuing' | 'issued' | 'failed' | 'accepted' | 'expired' | 'declined' | 'recurring' | 'partially_paid' | 'paid' | 'overdue' | 'uncollectible' | 'canceled'

Return only receivables that have the specified status. See the applicable invoice statuses, quote statuses, and credit note statuses.

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

status__instring[]

Return only receivables that have the specified statuses. See the applicable invoice statuses, quote statuses, and credit note statuses.

tag_idsstring[]

Return only receivables whose tags include all of the tags with the specified IDs and optionally other tags that are not specified.

For example, given receivables with the following tags:

  1. tagA
  2. tagB
  3. tagA, tagB
  4. tagC
  5. tagA, tagB, tagC

tag_ids = [tagA, tagB] will return receivables 3 and 5.

tag_ids__instring[]

Return only receivables whose tags include at least one of the tags with the specified IDs.

For example, given receivables with the following tags:

  1. tagA
  2. tagB
  3. tagA, tagB
  4. tagC
  5. tagB, tagC

tag_ids__in = [tagA, tagB] will return receivables 1, 2, 3, and 5.

Valid but nonexistent tag IDs do not raise errors but produce no results.

total_amountinteger

Return only receivables 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__gtinteger

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

total_amount__gteinteger

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

total_amount__ltinteger

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

total_amount__lteinteger

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

type'quote' | 'invoice' | 'credit_note'

Response

Successful Response

next_pagination_tokenstring

A token that can be sent in the pagination_token query parameter to get the next page of results, or null if there is no next page (i.e. you've reached the last page).

prev_pagination_tokenstring

A token that can be sent in the pagination_token query parameter to get the previous page of results, or null if there is no previous page (i.e. you've reached the first page).

Changes

No recorded changes to this operation across all 1 revision of this API.