Blocked at Mission Data Mining 6/6 - Retrieve Data with Aggregate Function

Hello,

I am passing this query:

https://api.backendless.com/BA5032BC-52A1-229D-FF57-E9263BFDXXXX/68D42F5C-2B41-4C10-BA0F-B6F7444DXXXX/data/Country?property=Continent,Count(objectId)%20as%20CountryCount,Min(LifeExpectancy)%20as%20MinLifeExpectancy&groupBy=Continent

I think it works correctly, but I cannot get the reward. Any tip ?

Thanks. Didier

Hi @didier-stadelmann,

Try changing

?property=

to

?props=

Cheers,
Mark

1 Like

I think there is mismatch between task and the Video. Please verify. My url is

https://api.backendless.com/DA677CC1-F5D0-508E-FF76-FA621192F000/8A4A86D7-D753-41B1-9857-7E6C5C2A20C4/data/Country?property=Continent&property=Min(LifeExpectancy)%20as%20MinLifeExpectancy,count(objectid)%20as%20CountryCount&groupBy=Continent

I have tried changing property to props and I get the same result and still task is not marked completed.

Also what does The Continent property must be included in the request, mean ?

Greetings, @Navjeet_Chabbewal,

use

&property=

for Count function same as you did it for Min

The next request worked for me and completed the mission:

https://api.backendless.com/DA677CC1-F5D0-508E-FF76-FA621192F000/8A4A86D7-D753-41B1-9857-7E6C5C2A20C4/data/Country?property=Continent&property=Count(objectId)%20as%20CountryCount&property=Min(LifeExpectancy)%20as%20MinLifeExpectancy&groupBy=Continent

2 Likes

I used this to fix my URL, and complete the task. There is now an updated REST API feature for aggregates.

?property=Continent&property=Count(objectId)%20as%20CountryCount&property=Min(LifeExpectancy)%20as%20MinLifeExpectancy&groupBy=Continent