can we use aggregate function like count in backendless REST API?

General
1

Hi,

I have Poll results table, so i want to retrieve no.of responses(count) for each option provided as part of poll to draw a dynamic graph. How can i achieve this using backendless REST API ?

Thanks & Regards,
Santhosh P

2

Hi Santhosh,

We do not have any aggregation functions yet, this is something we’re working on. As a workaround, you could send a REST request like this:
https://api.backendless.com/<version>/data/<table-name>?where=whereClause&pageSize=1

and then use the “totalObjects” property in the response.

More details are available at:
https://backendless.com/documentation/data/rest/data_search_and_query.htm

Please keep in mind that the “totalObjects” property will be deprecated in the future version of Backendless. Instead we will be providing a separate REST route/API for that.

Mark