SQL Guides

OINO.cloud APIs support SQL ordering using parameter oinoqueryorder in the request URL. You can give a comma separated list of fieldName ASC/DESC/+/- to define the fields and directions to sort on.

Order Methods

The following ordering methods are supported:

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




    

        ProductName
        UnitPrice
        UnitsInStock
        UnitsOnOrder