Search and Filters

Some API endpoints offered by Rotabull support enhanced search functionality.

By using Fields and Search Operators, you can filter against Deals based on many of the fields available on the object.

Field Name	Value Type	Description
`received_date`	Date String (YYYY-MM-DD) - "2023-09-01"	Date the RFQ was received, in UTC
`quoted_date`	Date String (YYYY-MM-DD) - "2023-09-01"	Date the Quote was sent, in UTC
`part_number`	String - "60B10028-17"	Any part number in the original RFQ
`part_number_quoted`	String - "60B10028-17"	Any part number in the sent Quote
`description`	String - "Windshield Assy"	Description for any part in the original RFQ
`quote_sent_by`	Integer - 933	ID for a User. Can be retrieved from the `/users` endpoint
`source`	String - "Email", "Phone", "ILS", "SkySelect", "PartsBase", etc.	Name of the source where the RFQ was received from. A full list can be seen in the UI under the "Deal Source" Filter option
`is_mro`	Boolean - True, False	Whether or not a Deal represents a Repair request (as opposed to a Sale request)

Operator	Operator Description
`:>`	Greater than. Commonly used for dates or numerical values
`:<`	Less than. Commonly used for dates or numerical values
`:=`	Equal to.
`:~`	Case-insensitive contains. Can be used to match against portions of values
`:i`	In. Used when multiple values can be added for a field

Fetch deals in the RFQ Inbox which contain a request for a Part Number that contains "12345" received after Sep 1st, 2023 where the Source is "Email":
GET /deals?filter=inbox&add_filters=part_number:~12345|received_date:>2023-09-01|deal_source:iEmail
Fetch deals that have been quoted which contain a quote for a Part Number that contains "60B10028" and where the Source is "ILS", sent by User with ID "933" or "934":
GET /deals?filter=quoted&add_filters=part_number:~60B10028|deal_source:iEmail|quote_sent_by:i933,934