REST - count of distinct combinations

REST
1

Hi there all!

I’m trying to count the number of distinct combinations of three fields in a table.

I have the query working to the point that the pairs are separated and distinct. I would like the query to return a single count which tells me how many unique combinations there are.

Here’s a screenshot of the query:

image
image1335×611 64.7 KB

Can anyone help please?

Thanks for reading!
Rob

2

Hi @Rob_Simpson

You can use the “Count API”

https://backendless.com/docs/rest/data_get_object_count.html

Regards,
Vlad