Query collection rows

POST /collection/{id}/rows/query

Path Parameters

idstring

required·

Resource id

Request Body

groupobject

required·

Only the rows of one group: the rows an aggregate group_by [{ field, bucket }] counts under the key value. field is a select, text, email, url, user, boolean, date or datetime field (400 validation_error, details.field "group.field", for number, long_text, json, multi_select or a system field). A date or datetime field needs bucket and refuses none; every other type refuses one (details.field "group.bucket"). value is the key the aggregate returned: "2026-10-05" for day, the Monday "2026-10-05" for week, "2026-10" for month (UTC), 1 or 0 (true/false also accepted) for boolean. value null (or empty) is the empty group. total_count is null when set. 400 field_protected on a protected field below edit.

bucketstring

Possible values:

dayweekmonth

fieldstring

valuestring,number,boolean,null

cursorstring

fieldsstring[]

filter

limitinteger

qstring

sortarray

Response Body

next_cursorstring,null

prev_cursorstring,null

resultobject[]

created_atstring

created_bystring,null

fieldsobject

idstring

updated_atstring

updated_bystring,null

row_visibilitystring

total_countinteger,null

users

curl -X POST 'https://api.elaichi.ai/collection/<id>/rows/query' \
  -H 'Authorization: Bearer $ELAICHI_API_TOKEN' \
  -H 'Content-Type: application/json' \
  -d '{"q":"your_q","sort":[],"fields":[],"limit":0,"cursor":"your_cursor","group":{}}'

const body = {
  "q": "your_q",
  "sort": [],
  "fields": [],
  "limit": 0,
  "cursor": "your_cursor",
  "group": {}
};

const response = await fetch('https://api.elaichi.ai/collection/<id>/rows/query', {
  method: 'POST',
  headers: {
    'Authorization': 'Bearer ' + process.env.ELAICHI_API_TOKEN,
    'Content-Type': 'application/json',
  },
  body: JSON.stringify(body),
});

const data = await response.json();
console.log(data);

import os
import requests

url = "https://api.elaichi.ai/collection/<id>/rows/query"
headers = {
    "Authorization": f"Bearer {os.environ['ELAICHI_API_TOKEN']}",
    "Content-Type": "application/json",
}
payload = {
    "q": "your_q",
    "sort": [],
    "fields": [],
    "limit": 0,
    "cursor": "your_cursor",
    "group": {}
}

response = requests.post(url, headers=headers, json=payload)
print(response.json())