Users

Get user details

get

Update user info

put

Delete user

delete

Aggregate Table

https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/aggregate

Expected parameters

NameDescriptionInRequiredSchema
db_branch_name

The DBBranchName matches the pattern `{db_name}:{branch_name}`.

path✅string
table_name

The Table name

path✅string

Run Aggregations Over a Table

POST
https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/aggregate

This endpoint allows you to run aggregations (analytics) on the data from one table. While the summary endpoint is served from a transactional store and the results are strongly consistent, the aggregate endpoint is served from our columnar store and the results are only eventually consistent. On the other hand, the aggregate endpoint uses a store that is more appropriate for analytics, makes use of approximation algorithms (e.g for cardinality), and is generally faster and can do more complex aggregations.

For usage, see the Aggregation documentation.

Request Body Type Definition

Responses