How To Use Aggregation

OINO.cloud APIs support SQL aggregation of data using parameter oinosqlaggregation in the request URL. You can give a comma separated list for aggregation methods like function(fieldName). Aggregation can be combined with oinosqlselect which limits the selected fields and allowing you to control what fields get grouped together.

Aggregation Methods

The following aggregation methods are supported:

  • count: Count of aggregated values.
  • sum: Sum of the aggregated values.
  • avg: Average of the aggregated values.
  • min: Minumum of the aggregated values.
  • max: Maximum of the aggregated values.
Example 




    

        Freight
        ShipCountry