Group records

POST https://data.jetadmin.io/projects/{{project_id}}/prod/{{resource_name}}/models/{{model_id}}/group

Replace the double-brace placeholders with your identifiers. The interactive endpoint below uses standard OpenAPI path parameters.

Record fields, required values, filters, and operation support depend on the selected model. Use the generated API for your resource to check its exact schema.

Group records

post

Aggregates record data and groups it by one or more fields.

Authorizations

AuthorizationstringRequired

Static API token for the selected resource, passed directly in the Authorization header. Use the token and auth format shown by the resource API.

Path parameters

project_idstringRequired

Project identifier. Replace {{project_id}} with your project identifier.

resource_namestringRequired

Connected resource API name. Replace {{resource_name}} with your resource name.

model_idstringRequired

Collection/model API identifier. Replace {{model_id}} with your model identifier.

Body

y_funcstring · enumRequiredPossible values:

y_fieldstringOptional

Required when y_func is Sum, Min, Max, or Avg.

Responses

200

Grouped aggregate results.

application/json

400

Invalid request parameters or body.

application/json

401

Missing or invalid API token.

application/json

post/projects/{project_id}/prod/{resource_name}/models/{model_id}/group

POST /projects/{project_id}/prod/{resource_name}/models/{model_id}/group HTTP/1.1
Host: data.jetadmin.io
Authorization: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 68

{
  "y_func": "Count",
  "x_fields": [
    {
      "field": "date_add",
      "lookup": "date"
    }
  ]
}

{
  "results": [
    {
      "group": "2020-08-01T00:00:00",
      "value": 218
    },
    {
      "group": "2020-08-02T00:00:00",
      "value": 43
    }
  ]
}