List Records - QuickBlox

Recipes

Filter records by location

1. Set a search operator for a field

Apply a search operator to the query. Here, the near operator is applied to a user_location field.

curl -X GET \
-H "Content-Type: application/json" \
-H "QB-Token: b97d22aee7773587ede6b2120fda1d0d7c012bba" \
https://api.quickblox.com/data/ScoreTable.json?user_location[near]=11.00,45.40;16800

2. As a result, the API returns records filtered by the specified location.

All records with the 11.00,45.40;16800 value for the user_location field are turned.

{
  "class_name": "ScoreTable",
  "skip": 0,
  "limit": 100,
  "items": [
    {
      "_id": "5d866b53a28f9a5ad51cb562",
      "_parent_id": null,
      "completed_levels": [
        1,
        2,
        3,
        4
      ],
      "created_at": 1569090387,
      "date": "2019-09-21T21:21:00Z",
      "expert_mode": false,
      "game_mode_name": "beta testing",
      "progress": 0.23,
      "score_value": 1000,
      "updated_at": 1574944158,
      "user_avatar": null,
      "user_id": 96753878,
      "user_location": [
        11.12,
        45.51
      ]
    },
    {
      "_id": "5d866a5aa0eb4753fc6099c3",
      "_parent_id": null,
      "completed_levels": [
        1,
        2,
        3,
        10,
        11,
        12,
        13
      ],
      "created_at": 1569090138,
      "date": "2019-09-21T21:21:00Z",
      "expert_mode": false,
      "game_mode_name": "4x4",
      "progress": 0.12,
      "score_value": 665,
      "updated_at": 1569189981,
      "user_avatar": null,
      "user_id": 96753878,
      "user_location": [
        11.13,
        45.52
      ]
    }
  ]
}

Filter records by criteria

1. Set a search operator for a field

Apply a search operator to the query. Here, the lt operator is applied to a score_value custom field.

curl -X GET \
-H "Content-Type: application/json" \
-H "QB-Token: 0bea0abd041b2431e5e1c2d0b06fab4414012bba" \
https://api.quickblox.com/data/ScoreTable.json?score_value[lt]=1000

2. As a result, the API returns records filtered upon the request.

All records with the score_value less than 1000 are returned.

{
  "class_name": "ScoreTable",
  "skip": 0,
  "limit": 100,
  "items": [
    {
      "_id": "5d866a5aa0eb4753fc6099c3",
      "_parent_id": null,
      "completed_levels": [
        1,
        2,
        3,
        10,
        11,
        12,
        13
      ],
      "created_at": 1569090138,
      "date": "2019-09-21T21:21:00Z",
      "expert_mode": false,
      "game_mode_name": "beta testing4",
      "progress": 0.12,
      "score_value": 665,
      "updated_at": 1569177165,
      "user_avatar": null,
      "user_id": 96753878,
      "user_location": [
        11.13,
        45.52
      ]
    }
  ]
}

Group records

1. Set an aggregation operator for a field to calculate an average for all numeric values

Apply an aggregation operator for a field to calculate an average for all numeric values.Here, the calc aggregation operator is applied to the score_value and set to the avg value.

curl -X GET \
-H "Content-Type: application/json" \
-H "QB-Token: 0bea0abd041b2431e5e1c2d0b06fab4414012bba" \
https://api.quickblox.com/data/ScoreTable.json?score_value[calc]=avg&group_by=game_mode_name

2. Set an aggregation operator for a field to group records

Apply an aggregation operator to a field to group records. Here, a group_by operator is applied to a game_mode_name field.

curl -X GET \
-H "Content-Type: application/json" \
-H "QB-Token: 0bea0abd041b2431e5e1c2d0b06fab4414012bba" \
https://api.quickblox.com/data/ScoreTable.json?score_value[calc]=avg&group_by=game_mode_name

3. As a result, the API returns records grouped according to the request.

The records are grouped by the gamed_mode_name field with an average calculated for the score_value field.

{
  "class_name": "ScoreTable",
  "skip": 0,
  "limit": 100,
  "items": [
    {
      "game_mode_name": "4x4",
      "avg": 665
    },
    {
      "game_mode_name": "beta testing",
      "avg": 2010.5
    },
    {
      "game_mode_name": "team rumble",
      "avg": 1211
    }
  ]
}

If you are sorting records by time, use the _id field. It is indexed and will be much faster than the created_at field.

Combinations of operators are allowed. For example:
score_value[gt]=100&score_value[lt]=1000&game_mode_name[in]=deathmatch,ctf Search Operators The request can contain all, some or none of the next search operators:

Operator	Description
lt	Less Than operator Types: integer, float Example: score_value[lt]=1000
lte	Less Than or Equal to operator Types: integer, float Example: score_value[lte]=850
gt	Greater Than operator Types: integer, float Example: bonus_count[gt]=2.45
gte	Greater Than or Equal to operator Types: integer, float Example: bonus_count[gte]=56.443
ne	Not Equal to operator Types: integer, float, string, boolean Example: game_mode_name[ne]=ctf
in	Contained IN array operator Types: integer, float, string Example: game_mode_name[in]=deathmatch,rage
nin	Not contained IN array operator Types: integer, float, string Example: game_mode_name[nin]=survivor,crazy_nightmare
all	ALL contained IN array operator Types: array Example: game_modes[all]=survivor,crazy
or	OR operator Types: integer, float, string Example: name[or]=sam,tim name[or]=sam&lastname[or]=johnson Will return records with name `sam` or `tim`. Will return records with name `sam` or last name `johnson`.
ctn	Contains substring operator Types: string Example: username[ctn]=son Will return all records where `username` field contains `son` substring.
near	Types: location Example: mylocation[near]=25.32,44.551;1000 Search records in a specific radius with the current position in meters. Format: `{field_name}[near]=longitude,latitude;radius`.

Sort Operators Next sorting operators are allowed:

Operator	Description
sort_asc	Types: all types Example: sort_asc=field_name Search results will be sorted by the specified field in ascending order.
sort_desc	Types: all types Example: sort_desc=field_name Search results will be sorted by the specified field in descending order.

Aggregation Operators

Operator	Description
{field_name}[calc]=	Types: integer, float Example: rating[calc]=min `avg`, `min`, `max`, `sum` can be used with `group_by` operator.
group_by={field_name}	Types: integer, float, string, boolean Example: group_by=game_mode_name The `group_by` works similarly to the SQL GROUP BY operator, should be used with the `calc` operator.

Path Parameters

class_name

string

required

Custom object class name.

Query Parameters

{custom_field_N}

string

Search records with the field that contains the specified value. Can be many 1..N.

{custom_field_N}[{search_operator}]

string

Search a record with the field that contains a value according to the specified value and operator.

limit

integer

default:"100"

Limit search results to N records. Max(Cloud/Enterprise): 100/1000. Useful for pagination.

skip

integer

default:"0"

Skip N records in search results. Useful for pagination.

count

integer

Count search results. Response will contain only count of records found.

sort_desc

string

Search results will be sorted by specified field in descending order.

sort_asc

string

Search results will be sorted by specified field in ascending order.

output[include]

string

The output parameter takes the form of a record with a list of fields for inclusion or exclusion from the result set. output[include] specifies the fields to include. The _id field is, by default, included in the result set. To exclude the _id field from the result set, you need to specify the exclusion of the _id field in the output[exclude] value.

output[exclude]

string

The output parameter takes the form of a record with a list of fields for inclusion or exclusion from the result set. output[exclude] specifies the fields to exclude. The _id field is, by default, included in the result set. To exclude the _id field from the result set, you need to specify the exclusion of the _id field in the output[exclude] value.

Headers

QB-Token

string

required

A user or application session token. See Authentication page to learn more about session tokens. Must be used either QB-Token or Authorization.

Response

200

A successful response

class_name

string

skip

integer

limit

integer

items

array of objects

Show properties

_id

string

_parent_id

string

created_at

integer

updated_at

integer

user_id

integer

curl -X GET \
-H "Content-Type: application/json" \
-H "QB-Token: 0bea0abd041b2431e5e1c2d0b06fab4414012bba" \
https://api.quickblox.com/data/ScoreTable.json?score_value[lt]=1000

{
  "class_name": "ScoreTable",
  "skip": 0,
  "limit": 100,
  "items": [
    {
      "_id": "5d866a5aa0eb4753fc6099c3",
      "_parent_id": null,
      "completed_levels": [
        1,
        2,
        3,
        10,
        11,
        12,
        13
      ],
      "created_at": 1569090138,
      "date": "2019-09-21T21:21:00Z",
      "expert_mode": false,
      "game_mode_name": "beta testing4",
      "progress": 0.12,
      "score_value": 665,
      "updated_at": 1569177165,
      "user_avatar": null,
      "user_id": 96753878,
      "user_location": [
        11.13,
        45.52
      ]
    }
  ]
}

REST API

​Recipes

​Path Parameters

​Query Parameters

​Headers

​Response

Recipes

Path Parameters

Query Parameters

Headers

Response