Data Minder Mission 6

Console Missions
1

Mission: DATA MINER
Task: Retrieve Data With Aggregate Functions

Hey guys,

So I’m issuing the following GET via the REST console and not passing through, it looks correct per the video, so what am I missing?

https://eu-api.backendless.com/8AB4C82A-6C80-4209-B823-920CD6A1A708/56285540-D001-4D04-BB91-34949F819790/data/Country?props=COUNT(objectId)%20as%20CountryCount,Continent,MIN(LifeExpectancy)%20as%20MinLifeExpectancy,MAX(LifeExpectancy)%20as%20MaxLifeExpectancy&groupBy=Continent

OR

https://eu-api.backendless.com/8AB4C82A-6C80-4209-B823-920CD6A1A708/56285540-D001-4D04-BB91-34949F819790/data/Country?props=COUNT(objectId)%20as%20CountryCount,Continent,MIN(LifeExpectancy)%20as%20MinLifeExpectancy&groupBy=Continent

2

Hi, @Elad_Sherf

Sorry for the inconvenience. Your second query looks correct, you just need to add quotes to objectId and MinLifeExpectancy properties. The request should look like this.

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

We will make a changes on our end so that the unquoted case also counts as shown in the video. Thank you for letting us know about this.

Regards,
Marina

3

:+1:t3:Thanks Marina.