By Clay Li on Thursday, 05 December 2019
Category: Feature

How to Get Aggregate Results with REST API

​REST API in Calem allows one to fetch data from a data table such as work orders, assets and locations. In release R2019e the REST API allows one to fetch aggregate results from a data table. 

Prior to R2019e one can fetch a data list through a where, order by and limit clauses ("w", "o", and "l"):

In release R2019e two more clauses are added ("cs" and "g"):

​Here is a PHP code snippet to get total PM work order count from Calem.

Additional resources