Filterable fields

In this topic, we list the fields that you can filter with in your list requests.

📘

NOTE

For filtering with createdTime and updatedTime, you can set a range of ISO 8601 date-time values.

  • yyyy-MM-dd'T'HH:mm:ss.SSSX
  • yyyy-MM-dd'T'HH:mm:ss.SSS
  • yyyy-MM-dd'T'HH:mm:ss
  • yyyy-MM-dd'T'HH:mm
  • yyyy-MM-dd

Vendors and Customers

Fields you can filter withAvailable operators
ideq (Equal)
ne (Not equal)
in (In)
archivedeq (Equal)
ne (Not equal)
nameeq (Equal)
sw (Starts with)
accountTypeeq (Equal)
ne (Not equal)
in (In)
nin (Not in)
billCurrency (Vendors)
invoiceCurrency (Customers)
eq (Equal)
ne (Not equal)
in (In)
nin (Not in)
createdTimegt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)
updatedTimegt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)

Bills and Invoices

Fields you can filter withAvailable operators
ideq (Equal)
ne (Not equal)
in (In)
archivedeq (Equal)
ne (Not equal)
vendorId (Bills)
customerId (Invoices)
eq (Equal)
in (In)
createdTimegt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)
updatedTimegt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)

Recurring bills

Fields you can filter withAvailable operators
ideq (Equal)
ne (Not equal)
in (In)
archivedeq (Equal)
ne (Not equal)
vendorIdeq (Equal)
in (In)

Payments

Fields you can filter withAvailable operators
ideq (Equal)
ne (Not equal)
in (In)
vendorIdeq (Equal)
ne (Not equal)
in (In)
processDategt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)
amounteq (Equal)
gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)
statuseq (Equal)
ne (Not equal)
in (In)
nin (Not in)
onlinePaymenteq (Equal)
ne (Not equal)
disbursementTypeeq (Equal)
ne (Not equal)
in (In)
createdTimegt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)
updatedTimegt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal)