Query Examples

Part/76156733?$top=3&$filter=PartNumber eq '10-106' and Avail gt 0

Part/76156733?$top=3&$filter=LastReceivedDate gt datetime'2014-01-01'

Part/76156733?$top=3&$filter=Retail gt 100.00m

Customer/76156733?$top=10&$filter=LastName eq 'simmons'

ServiceDet/76156733?$top=3&$filter=datein ge datetime'2014-01-28T00:00:00'

InvoiceSum/76156733?$top=3&$filter=Sales gt 600.00m

InvoiceDet/76156733?$top=3&$filter=price gt 600.00m&$orderby=InvoiceNo

ServiceSum/76156733?$top=3&$filter=WarrantyJob eq 0 and InternalJob eq 0

Deal/76156733?$top=3&$filter=FinanceDate eq datetime'2014-05-16T00:00:00'

Query Parameter Field Support

Most fields are supported for querying, but there are some that will not be supported – especially if the data is coming directly from the dealer’s system database rather than the data warehouse. Notably under this DirectConnect circumstance, DateLastGathered may not be used in a query as it is always set to the current time. DealerId or Cmf are never allowed in the query as they are always specified in their own segment of the URL.