BLOCKED - Can't pass Retrieve Data With Aggregate Functions

Console Missions
1

There is no way to add multiple aggregate functions via REST CONSOLE UI. I can’t edit the request URL, therefore, I am stuck as I can’t apply the solution given here: Blocked at Mission Data Mining 6/6 - Retrieve Data with Aggregate Function - #4 by Igor_Bogunkov

image
image1841×943 116 KB

1 Like
2

Hello,
Please send the request from your browser as it is shown in the video, not from the REST console.

Screenshot 2020-08-12 at 12.04.52
Screenshot 2020-08-12 at 12.04.524320×1950 1.01 MB

Regards,
Olha

3

I understand. Why I can’t do it from REST console? Is there a limitation at the moment?

4

It works by the way. I would recommend to fix it or add a note to guide the user as I can see many persons get blocked trying to do it via the REST console.

5

This was frustrating. Seems it would be relatively easy to add support for multiple aggregate functions in the REST console.

6

Hello @Scott_Beeson

You are awesome and we appreciate you for reporting the proposal.
We will discuss with the team about implementing such a feature.

7

Hi,
Even when I run this in my browser, it doesn’t mark the task as completed. :frowning:
How can I mark the task as complete?

https://api.backendless.com/2923B479-9794-4973-FFE0-DC04DA2B4B00/E0E0AF27-F54E-4606-A443-1AC82E152B04/data/Country?property=COUNT(objectid)%20as%20CountryCount,MIN(LifeExpectancy)%20as%20MinLifeExpectancy,Continent&groupBy=Continent

8

Hi @Tim_McIntosh

You should have passed different properites separated not by commas but by &property=.

Try this url: https://api.backendless.com/2923B479-9794-4973-FFE0-DC04DA2B4B00/E0E0AF27-F54E-4606-A443-1AC82E152B04/data/Country?property=Continent&property=Count(objectId)%20as%20CountryCount&property=Min(LifeExpectancy)%20as%20MinLifeExpectancy&groupBy=Continent

2 Likes