This endpoint requires your private API key.
Examples
Quering event properties, context, and traits
To query a specific nested property, you can use theJSONExtract
function. For example, to query all events where the totalAccounts
property is greater than 3, you can use the following query:
Joining identified users with their events
Allidentify
calls are sent to the same underlying events
ClickHouse table, so you can join events with identified users using the userId
column. For example, to query all events for a user with the ID user-123
, you can use the following query:
track
and identify
event types:
Body
application/json
The queries to execute.
Example:
[
"SELECT COUNT(*) FROM events WHERE event = \"UserSignedUp\""
]
Response
200 - application/json
The queries have been successfully executed.
The limit of the pagination.
The offset of the pagination.
The total number of results. If null
, the total is unknown.
The results of the queries, returned in the same order as the queries.
Example:
[{ "results": [{ "count": 3485241 }] }]