SQL Guides

OINO.cloud APIs support SQL ordering using parameter oinosqlorder in the request URL. You can give a comma separated list of fieldName ASC/DESC/+/- to define the fields and directions to sort on. Aggregation can be combined with oinosqlselect which limits the selected fields and allowing you to control what fields get grouped together.

Order Methods

The following aggregation methods are supported:

  • ASC or +: Ascending order.
  • DESC or -: Descending order.
Example 




    

        ProductName
        UnitPrice
        UnitsInStock
        UnitsOnOrder