How To Use Filters

OINO.cloud APIs support SQL where conditions using parameter oinosqlfilter in the request URL. You can give filter conditions like (fieldName)-cond(value) to define a where condition.

Filter Conditions

The following aggregation methods are supported:

  • lt: Less than.
  • le: Less or equal to.
  • eq: Equal to.
  • ge: Greater or equal to.
  • gt: Greater than.
  • like: Like (% can be used for wildcard).
Example 




    

        ProductName
        UnitPrice
        UnitsInStock
        UnitsOnOrder