cURL Python JavaScript PHP Go Java
curl --request POST \
--url https://api.helicone.ai/v1/request/query-clickhouse \
--header 'Content-Type: application/json' \
--header 'authorization: <api-key>' \
--data '{
"filter": "all",
"isCached": false,
"limit": 100,
"offset": 0,
"sort": {
"created_at": "desc"
},
"includeInputs": false,
"isScored": false,
"isPartOfExperiment": false
}'
{
"filter" : "all" ,
"isCached" : false ,
"limit" : 10 ,
"offset" : 0 ,
"sort" : {
"created_at" : "desc"
} ,
"isScored" : false ,
"isPartOfExperiment" : false
}
For users in the European Union: Please use eu.api.helicone.ai
instead of
api.helicone.ai
to ensure compliance with data residency requirements and
optimal performance.
The following API is the same as the Get Requests API, but it is optimized for speed when querying large amount of data. This endpoint will timeout for point queries and is really slow when querying just a few requests.
The following API lets you get all of the requests
that would be visible in the request table at
helicone.ai/requests .
Premade examples 👇
A filter is either a FilterLeaf or a FilterBranch, and can be composed of multiple filters generating an AST of ANDs/ORs.
Here is how it is represented in typescript:
This allows us to build complex filters like this:
filter
Option 1 · object Option 2 · object Option 3 · enum<string>
required From T, pick a set of properties whose keys are in the union K
filter. request_response_rmt
Make all properties in T optional
filter.request_response_rmt. latency
Make all properties in T optional
filter.request_response_rmt.latency. not-equals
filter.request_response_rmt.latency. equals
filter.request_response_rmt.latency. gte
filter.request_response_rmt.latency. lte
filter.request_response_rmt.latency. lt
filter.request_response_rmt.latency. gt
filter.request_response_rmt. status
Make all properties in T optional
filter.request_response_rmt.status. not-equals
filter.request_response_rmt.status. equals
filter.request_response_rmt.status. gte
filter.request_response_rmt.status. lte
filter.request_response_rmt.status. lt
filter.request_response_rmt.status. gt
filter.request_response_rmt. request_created_at
Make all properties in T optional
filter.request_response_rmt.request_created_at. gte
filter.request_response_rmt.request_created_at. lte
filter.request_response_rmt.request_created_at. lt
filter.request_response_rmt.request_created_at. gt
filter.request_response_rmt. response_created_at
Make all properties in T optional
filter.request_response_rmt.response_created_at. gte
filter.request_response_rmt.response_created_at. lte
filter.request_response_rmt.response_created_at. lt
filter.request_response_rmt.response_created_at. gt
filter.request_response_rmt. model
Make all properties in T optional
filter.request_response_rmt.model. not-equals
filter.request_response_rmt.model. equals
filter.request_response_rmt.model. like
filter.request_response_rmt.model. ilike
filter.request_response_rmt.model. contains
filter.request_response_rmt.model. not-contains
filter.request_response_rmt. user_id
Make all properties in T optional
filter.request_response_rmt.user_id. not-equals
filter.request_response_rmt.user_id. equals
filter.request_response_rmt.user_id. like
filter.request_response_rmt.user_id. ilike
filter.request_response_rmt.user_id. contains
filter.request_response_rmt.user_id. not-contains
filter.request_response_rmt. organization_id
Make all properties in T optional
filter.request_response_rmt.organization_id. not-equals
filter.request_response_rmt.organization_id. equals
filter.request_response_rmt.organization_id. like
filter.request_response_rmt.organization_id. ilike
filter.request_response_rmt.organization_id. contains
filter.request_response_rmt.organization_id. not-contains
filter.request_response_rmt. node_id
Make all properties in T optional
filter.request_response_rmt.node_id. not-equals
filter.request_response_rmt.node_id. equals
filter.request_response_rmt.node_id. like
filter.request_response_rmt.node_id. ilike
filter.request_response_rmt.node_id. contains
filter.request_response_rmt.node_id. not-contains
filter.request_response_rmt. job_id
Make all properties in T optional
filter.request_response_rmt.job_id. not-equals
filter.request_response_rmt.job_id. equals
filter.request_response_rmt.job_id. like
filter.request_response_rmt.job_id. ilike
filter.request_response_rmt.job_id. contains
filter.request_response_rmt.job_id. not-contains
filter.request_response_rmt. threat
Make all properties in T optional
filter.request_response_rmt.threat. equals
filter.request_response_rmt. request_id
Make all properties in T optional
filter.request_response_rmt.request_id. not-equals
filter.request_response_rmt.request_id. equals
filter.request_response_rmt.request_id. like
filter.request_response_rmt.request_id. ilike
filter.request_response_rmt.request_id. contains
filter.request_response_rmt.request_id. not-contains
filter.request_response_rmt. prompt_tokens
Make all properties in T optional
filter.request_response_rmt.prompt_tokens. not-equals
filter.request_response_rmt.prompt_tokens. equals
filter.request_response_rmt.prompt_tokens. gte
filter.request_response_rmt.prompt_tokens. lte
filter.request_response_rmt.prompt_tokens. lt
filter.request_response_rmt.prompt_tokens. gt
filter.request_response_rmt. completion_tokens
Make all properties in T optional
filter.request_response_rmt.completion_tokens. not-equals
filter.request_response_rmt.completion_tokens. equals
filter.request_response_rmt.completion_tokens. gte
filter.request_response_rmt.completion_tokens. lte
filter.request_response_rmt.completion_tokens. lt
filter.request_response_rmt.completion_tokens. gt
filter.request_response_rmt. total_tokens
Make all properties in T optional
filter.request_response_rmt.total_tokens. not-equals
filter.request_response_rmt.total_tokens. equals
filter.request_response_rmt.total_tokens. gte
filter.request_response_rmt.total_tokens. lte
filter.request_response_rmt.total_tokens. lt
filter.request_response_rmt.total_tokens. gt
filter.request_response_rmt. target_url
Make all properties in T optional
filter.request_response_rmt.target_url. not-equals
filter.request_response_rmt.target_url. equals
filter.request_response_rmt.target_url. like
filter.request_response_rmt.target_url. ilike
filter.request_response_rmt.target_url. contains
filter.request_response_rmt.target_url. not-contains
filter.request_response_rmt. properties
filter.request_response_rmt.properties. {key}
Make all properties in T optional
filter.request_response_rmt.properties.{key}. not-equals
filter.request_response_rmt.properties.{key}. equals
filter.request_response_rmt.properties.{key}. like
filter.request_response_rmt.properties.{key}. ilike
filter.request_response_rmt.properties.{key}. contains
filter.request_response_rmt.properties.{key}. not-contains
filter.request_response_rmt. search_properties
filter.request_response_rmt.search_properties. {key}
Make all properties in T optional
filter.request_response_rmt.search_properties.{key}. not-equals
filter.request_response_rmt.search_properties.{key}. equals
filter.request_response_rmt.search_properties.{key}. like
filter.request_response_rmt.search_properties.{key}. ilike
filter.request_response_rmt.search_properties.{key}. contains
filter.request_response_rmt.search_properties.{key}. not-contains
filter.request_response_rmt. scores
filter.request_response_rmt.scores. {key}
Make all properties in T optional
filter.request_response_rmt.scores.{key}. not-equals
filter.request_response_rmt.scores.{key}. equals
filter.request_response_rmt.scores.{key}. like
filter.request_response_rmt.scores.{key}. ilike
filter.request_response_rmt.scores.{key}. contains
filter.request_response_rmt.scores.{key}. not-contains
filter.request_response_rmt. scores_column
Make all properties in T optional
filter.request_response_rmt.scores_column. not-equals
filter.request_response_rmt.scores_column. equals
filter.request_response_rmt.scores_column. like
filter.request_response_rmt.scores_column. ilike
filter.request_response_rmt.scores_column. contains
filter.request_response_rmt.scores_column. not-contains
filter.request_response_rmt. request_body
Make all properties in T optional
filter.request_response_rmt.request_body. contains
filter.request_response_rmt. response_body
Make all properties in T optional
filter.request_response_rmt.response_body. contains
Make all properties in T optional
filter.response. body_tokens
Make all properties in T optional
filter.response.body_tokens. not-equals
filter.response.body_tokens. equals
filter.response.body_tokens. gte
filter.response.body_tokens. lte
filter.response.body_tokens. lt
filter.response.body_tokens. gt
filter.response. body_model
Make all properties in T optional
filter.response.body_model. not-equals
filter.response.body_model. equals
filter.response.body_model. like
filter.response.body_model. ilike
filter.response.body_model. contains
filter.response.body_model. not-contains
filter.response. body_completion
Make all properties in T optional
filter.response.body_completion. not-equals
filter.response.body_completion. equals
filter.response.body_completion. like
filter.response.body_completion. ilike
filter.response.body_completion. contains
filter.response.body_completion. not-contains
Make all properties in T optional
filter.response.status. not-equals
filter.response.status. equals
filter.response.status. gte
filter.response.status. lte
filter.response.status. lt
filter.response.status. gt
Make all properties in T optional
filter.response.model. not-equals
filter.response.model. equals
filter.response.model. like
filter.response.model. ilike
filter.response.model. contains
filter.response.model. not-contains
Make all properties in T optional
Make all properties in T optional
filter.request.prompt. not-equals
filter.request.prompt. equals
filter.request.prompt. like
filter.request.prompt. ilike
filter.request.prompt. contains
filter.request.prompt. not-contains
filter.request. created_at
Make all properties in T optional
filter.request.created_at. gte
filter.request.created_at. lte
filter.request.created_at. lt
filter.request.created_at. gt
Make all properties in T optional
filter.request.user_id. not-equals
filter.request.user_id. equals
filter.request.user_id. like
filter.request.user_id. ilike
filter.request.user_id. contains
filter.request.user_id. not-contains
Make all properties in T optional
filter.request.auth_hash. not-equals
filter.request.auth_hash. equals
filter.request.auth_hash. like
filter.request.auth_hash. ilike
filter.request.auth_hash. contains
filter.request.auth_hash. not-contains
Make all properties in T optional
filter.request.org_id. not-equals
filter.request.org_id. equals
filter.request.org_id. like
filter.request.org_id. ilike
filter.request.org_id. contains
filter.request.org_id. not-contains
Make all properties in T optional
filter.request.id. not-equals
filter.request.id. contains
filter.request.id. not-contains
Make all properties in T optional
filter.request.node_id. not-equals
filter.request.node_id. equals
filter.request.node_id. like
filter.request.node_id. ilike
filter.request.node_id. contains
filter.request.node_id. not-contains
Make all properties in T optional
filter.request.model. not-equals
filter.request.model. equals
filter.request.model. like
filter.request.model. ilike
filter.request.model. contains
filter.request.model. not-contains
filter.request. modelOverride
Make all properties in T optional
filter.request.modelOverride. not-equals
filter.request.modelOverride. equals
filter.request.modelOverride. like
filter.request.modelOverride. ilike
filter.request.modelOverride. contains
filter.request.modelOverride. not-contains
Make all properties in T optional
filter.request.path. not-equals
filter.request.path. equals
filter.request.path. ilike
filter.request.path. contains
filter.request.path. not-contains
Make all properties in T optional
filter.request.prompt_id. not-equals
filter.request.prompt_id. equals
filter.request.prompt_id. like
filter.request.prompt_id. ilike
filter.request.prompt_id. contains
filter.request.prompt_id. not-contains
Make all properties in T optional
Make all properties in T optional
filter.feedback.id. not-equals
filter.feedback.id. equals
filter.feedback. created_at
Make all properties in T optional
filter.feedback.created_at. gte
filter.feedback.created_at. lte
filter.feedback.created_at. lt
filter.feedback.created_at. gt
Make all properties in T optional
filter.feedback.rating. equals
filter.feedback. response_id
Make all properties in T optional
filter.feedback.response_id. not-equals
filter.feedback.response_id. equals
filter.feedback.response_id. like
filter.feedback.response_id. ilike
filter.feedback.response_id. contains
filter.feedback.response_id. not-contains
filter. request_response_search
Make all properties in T optional
filter.request_response_search. request_body_vector
Make all properties in T optional
filter.request_response_search.request_body_vector. contains
filter.request_response_search. response_body_vector
Make all properties in T optional
filter.request_response_search.response_body_vector. contains
filter. sessions_request_response_rmt
Make all properties in T optional
filter.sessions_request_response_rmt. total_cost
Make all properties in T optional
filter.sessions_request_response_rmt.total_cost. not-equals
filter.sessions_request_response_rmt.total_cost. equals
filter.sessions_request_response_rmt.total_cost. gte
filter.sessions_request_response_rmt.total_cost. lte
filter.sessions_request_response_rmt.total_cost. lt
filter.sessions_request_response_rmt.total_cost. gt
filter.sessions_request_response_rmt. total_tokens
Make all properties in T optional
filter.sessions_request_response_rmt.total_tokens. not-equals
filter.sessions_request_response_rmt.total_tokens. equals
filter.sessions_request_response_rmt.total_tokens. gte
filter.sessions_request_response_rmt.total_tokens. lte
filter.sessions_request_response_rmt.total_tokens. lt
filter.sessions_request_response_rmt.total_tokens. gt
Make all properties in T optional
filter.cache_hits. organization_id
Make all properties in T optional
filter.cache_hits.organization_id. not-equals
filter.cache_hits.organization_id. equals
filter.cache_hits.organization_id. like
filter.cache_hits.organization_id. ilike
filter.cache_hits.organization_id. contains
filter.cache_hits.organization_id. not-contains
filter.cache_hits. request_id
Make all properties in T optional
filter.cache_hits.request_id. not-equals
filter.cache_hits.request_id. equals
filter.cache_hits.request_id. like
filter.cache_hits.request_id. ilike
filter.cache_hits.request_id. contains
filter.cache_hits.request_id. not-contains
filter.cache_hits. latency
Make all properties in T optional
filter.cache_hits.latency. not-equals
filter.cache_hits.latency. equals
filter.cache_hits.latency. gte
filter.cache_hits.latency. lte
filter.cache_hits.latency. lt
filter.cache_hits.latency. gt
filter.cache_hits. completion_tokens
Make all properties in T optional
filter.cache_hits.completion_tokens. not-equals
filter.cache_hits.completion_tokens. equals
filter.cache_hits.completion_tokens. gte
filter.cache_hits.completion_tokens. lte
filter.cache_hits.completion_tokens. lt
filter.cache_hits.completion_tokens. gt
filter.cache_hits. prompt_tokens
Make all properties in T optional
filter.cache_hits.prompt_tokens. not-equals
filter.cache_hits.prompt_tokens. equals
filter.cache_hits.prompt_tokens. gte
filter.cache_hits.prompt_tokens. lte
filter.cache_hits.prompt_tokens. lt
filter.cache_hits.prompt_tokens. gt
filter.cache_hits. created_at
Make all properties in T optional
filter.cache_hits.created_at. gte
filter.cache_hits.created_at. lte
filter.cache_hits.created_at. lt
filter.cache_hits.created_at. gt
Make all properties in T optional
filter.properties.{key}. not-equals
filter.properties.{key}. equals
filter.properties.{key}. like
filter.properties.{key}. ilike
filter.properties.{key}. contains
filter.properties.{key}. not-contains
Make all properties in T optional
filter.values.{key}. not-equals
filter.values.{key}. equals
filter.values.{key}. ilike
filter.values.{key}. contains
filter.values.{key}. not-contains
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Available options:
asc
,
desc
Construct a type with a set of properties K of type T
data.request_properties. {key}
data. provider
Option 1 · enum<string> Option 2 · enum<string>
required Available options:
OPENAI
,
ANTHROPIC
,
AZURE
,
LOCAL
,
HELICONE
,
AMDBARTEK
,
ANYSCALE
,
CLOUDFLARE
,
2YFV
,
TOGETHER
,
LEMONFOX
,
FIREWORKS
,
PERPLEXITY
,
GOOGLE
,
OPENROUTER
,
WISDOMINANUTSHELL
,
GROQ
,
COHERE
,
MISTRAL
,
DEEPINFRA
,
QSTASH
,
FIRECRAWL
,
AWS
,
DEEPSEEK
,
X
,
AVIAN
,
NEBIUS
,
NOVITA
data. prompt_cache_write_tokens
data. prompt_cache_read_tokens
data.llmSchema.request. llm_type
Available options:
chat
,
completion
data.llmSchema.request. model
data.llmSchema.request. provider
data.llmSchema.request. prompt
data.llmSchema.request. input
data.llmSchema.request. max_tokens
data.llmSchema.request. temperature
data.llmSchema.request. top_p
data.llmSchema.request. stream
data.llmSchema.request. presence_penalty
data.llmSchema.request. frequency_penalty
data.llmSchema.request. stop
data.llmSchema.request. messages
data.llmSchema.request.messages. _type
Available options:
function
,
functionCall
,
image
,
message
,
autoInput
,
contentArray
data.llmSchema.request.messages. contentArray
data.llmSchema.request.messages. idx
data.llmSchema.request.messages. image_url
data.llmSchema.request.messages. timestamp
data.llmSchema.request.messages. tool_call_id
data.llmSchema.request.messages. tool_calls
data.llmSchema.request.messages. content
data.llmSchema.request.messages. name
data.llmSchema.request.messages. role
data.llmSchema.request.messages. id
data.llmSchema.request. tools
data.llmSchema.request.tools. name
data.llmSchema.request.tools. description
data.llmSchema.request.tools. parameters
Construct a type with a set of properties K of type T
data.llmSchema.request. tool_choice
data.llmSchema.request.tool_choice. type
Available options:
auto
,
none
,
tool
data.llmSchema.request.tool_choice. name
data.llmSchema.response. error
data.llmSchema.response.error. heliconeMessage
data.llmSchema.response. model
data.llmSchema.response. messages
data.llmSchema.response.messages. _type
Available options:
function
,
functionCall
,
image
,
message
,
autoInput
,
contentArray
data.llmSchema.response.messages. contentArray
data.llmSchema.response.messages. idx
data.llmSchema.response.messages. image_url
data.llmSchema.response.messages. timestamp
data.llmSchema.response.messages. tool_call_id
data.llmSchema.response.messages. tool_calls
data.llmSchema.response.messages. content
data.llmSchema.response.messages. name
data.llmSchema.response.messages. role
data.llmSchema.response.messages. id
Construct a type with a set of properties K of type T
Construct a type with a set of properties K of type T
Construct a type with a set of properties K of type T