In this section, 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.SSSXyyyy-MM-dd'T'HH:mm:ss.SSSyyyy-MM-dd'T'HH:mm:ssyyyy-MM-dd'T'HH:mmyyyy-MM-dd
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
archived | eq (Equal)
ne (Not equal) |
name | eq (Equal)
sw (Starts with) |
accountType | eq (Equal)
ne (Not equal)
in (In)
nin (Not in) |
billCurrency (Vendors)
invoiceCurrency (Customers) | eq (Equal)
ne (Not equal)
in (In)
nin (Not in) |
createdTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
updatedTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
archived | eq (Equal)
ne (Not equal) |
vendorId (Bills)
customerId (Invoices) | eq (Equal)
in (In) |
dueDate (Bills) | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
createdTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
updatedTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
archived | eq (Equal)
ne (Not equal) |
vendorId | eq (Equal)
in (In) |
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
archived | eq (Equal)
ne (Not equal) |
status | eq (Equal)
ne (Not equal)
in (In)
nin (Not in) |
type | eq (Equal)
ne (Not equal) |
ownerType | eq (Equal)
ne (Not equal) |
createdTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
updatedTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
vendorId | eq (Equal)
ne (Not equal)
in (In) |
processDate | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
amount | eq (Equal)
gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
status | eq (Equal)
ne (Not equal)
in (In)
nin (Not in) |
onlinePayment | eq (Equal)
ne (Not equal) |
disbursementType | eq (Equal)
ne (Not equal)
in (In) |
transactionNumber | eq (Equal) |
createdTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
updatedTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
archived | eq (Equal)
ne (Not equal) |
role | eq (Equal)
ne (Not equal) |
createdTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
updatedTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
| Fields you can filter with | Available operators |
|---|
id | eq (Equal)
ne (Not equal)
in (In) |
type | eq (Equal)
ne (Not equal) |
createdTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
updatedTime | gt (Greater than)
gte (Greater than or equal)
lt (Less than)
lte (Less than or equal) |
