Filtering

Filter Your Requests

You can do filtering queries towards our endpoints that returns more than one object in response!

This means that you don’t have to get all the data and filter on your side, you can now let the API handle all the filtering. This is done by applying the $filter query string parameter. We use the oData V4 standard. You can filter using a few different operands, here are the operands we recommend, followed by some examples from the articles endpoint:

• Greater than
  $filter= Number gt 1337

• Less than
  $filter= Number lt 1337

• Greater than or equal to
  $filter= Number ge 1337

• Less than or equal to
  $filter= Number le 1337

• Equals
  $filter= Number eq 1337

• Not equal
  $filter= Number ne 1337

• Starts with (select property and value)
  $filter=startswith(Number, ‘13’)

• Ends with (select property and value)
  $filter=endswith(Number, ‘37’)

• Contains (return properties that contains the value)
  $filter=contains(Name, ‘bakery’)

• Length (combined with other operand)
  $filter=length(Name) gt 16

The filtering for Datetimes are a bit more specific:

• The DateTime format for filtering: yyyy-MM-ddTHH-mm-ss-FFZ
  $filter=ChangedUtc gt 2016-12-31T23:59:59.00Z

• Year (combined with other operand)
  $filter=year(ChangedUtc) eq 2017

• Month (combined with other operand)
  $filter=month(ChangedUtc) eq 12

• Day (combined with other operand)
  $filter=day(ChangedUtc) eq 31

• Hour (combined with other operand)
  $filter=hour(ChangedUtc) eq 23

• Minute (combined with other operand)
  $filter=minute(ChangedUtc) eq 59

• Second (combined with other operand)
  $filter=second(ChangedUtc) eq 59

Combined queries:

• And
  $filter=Number gt 1337 and ChangedUtc gt 2016-12-31T23:59:59.00Z

• Or
  $filter=Netprice lt 1240 or StockBalance ge 15

Note that string values must be delimited by single quotation marks. Numeric values require no delimiters.

These are examples of the filtering types that we find useful for the API, but there are a few more that you can use. To find out more, here’s a link to the complete list of filter expressions in oData