DATA MINER: #6 Retrieve Data With Aggregate Functions

Console Missions
7

I’m also interested in understanding what I’m doing wrong here.

This is the full API request:
https://api.backendless.com/721FC2A7-E947-DBF2-FF27-F810EF2B1C00/9F3C8ADE-6F0B-4D0F-8445-3CB5D8920442/data/Country?property=Count(objectId)%20as%20CountryCount,Continent,MIN(LifeExpectancy)%20as%20MinLifeExpectancy&groupBy=Continent

Detailed description of the params and compared against the requirements of the task.

  1. Rest API :white_check_mark:
  2. table Country :white_check_mark: -> data/Country
  3. Grouped by Continent column :white_check_mark: -> &groupBy=Continent
  4. following aggregate function:
    count of countries in each continent named as CountryCount :white_check_mark: -> COUNT(objectId) %20as%20CountryCount
    Minimum life expectancy with property name MinLifeExpectancy :white_check_mark: -> MIN(LifeExpectancy)%20as%20MinLifeExpectancy
  5. Continent property included in request and response :white_check_mark:

What is wrong here? I’ve noticed that in the Video there is also MaxLifeExpectancy and IndepYear - but its not required based on the written requirements. Also, there are changes as in video we use props but in REST console we use now property.

Will appreciate help here.
Grzegorz