Filterable fields

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

👍
Options for filtering with createdTime and updatedTime
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 & Customers

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)
`address.country`	`eq` (Equal) `ne` (Not equal)
`billCurrency` (Vendors) `invoiceCurrency` (Customers)	`eq` (Equal) `ne` (Not equal) `in` (In) `nin` (Not in)
`paymentStatus`	`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)

Bills

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)
`dueDate`	`gt` (Greater than) `gte` (Greater than or equal) `lt` (Less than) `lte` (Less than or equal)
`paymentStatus`	`eq` (Equal) `ne` (Not equal) `in` (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)
`payFromChartOfAccountId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.chartOfAccountId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.accountingClassId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.departmentId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.locationId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.itemId`	`eq` (Equal) `ne` (Not equal) `in` (In)

Invoices

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`archived`	`eq` (Equal) `ne` (Not equal)
`customerId`	`eq` (Equal) `in` (In)
`status`	`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)
`payToChartOfAccountId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.accountingClassId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.departmentId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.locationId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`classifications.itemId`	`eq` (Equal) `ne` (Not equal) `in` (In)

Recurring bills

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)

Vendor credits

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)
`creditDate`	`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)
`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)

Credit memos

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`archived`	`eq` (Equal) `ne` (Not equal)
`customerId`	`eq` (Equal) `in` (In)
`referenceNumber`	`eq` (Equal)
`creditDate`	`gt` (Greater than) `gte` (Greater than or equal) `lt` (Less than) `lte` (Less than or equal)
`payToChartOfAccountId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`payToBankAccountId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`status`	`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)

Bank accounts

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)
`accessToAdmins`	`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)

Payments

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)
`transactionNumber`	`eq` (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)
`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)

Received payments

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`customerId`	`eq` (Equal) `in` (In)
`paymentDate`	`gt` (Greater than) `gte` (Greater than or equal) `lt` (Less than) `lte` (Less than or equal)
`receivablesType`	`eq` (Equal) `ne` (Not equal) `in` (In) `nin` (Not in)
`status`	`eq` (Equal) `ne` (Not equal) `in` (In) `nin` (Not in)
`onlinePayment`	`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)

User roles

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)

Organization users

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`archived`	`eq` (Equal) `ne` (Not equal)
`role.type`	`eq` (Equal) `ne` (Not equal) `in` (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)

Classifications

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`archived`	`eq` (Equal) `ne` (Not equal)
`parentId`	`eq` (Equal) `ne` (Not equal) `in` (In)
`account.type` (Chart of accounts)	`eq` (Equal) `ne` (Not equal)
`chartOfAccountId` (Items)	`eq` (Equal) `ne` (Not equal) `in` (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)

Partner endpoints

Organizations

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`archived`	`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)

User roles

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)

Users

Fields you can filter with	Available operators
`id`	`eq` (Equal) `ne` (Not equal) `in` (In)
`archived`	`eq` (Equal) `ne` (Not equal)
`role.type`	`eq` (Equal) `ne` (Not equal) `in` (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)

Options for filtering with createdTime and updatedTime

Vendors & Customers

Bills

Invoices

Recurring bills

Vendor credits

Credit memos

Bank accounts

Payments

Received payments

User roles

Organization users

Classifications

Partner endpoints

Organizations

User roles

Users

Options for filtering with `createdTime` and `updatedTime`