cURL
curl --request POST \
--url https://api.helicone.ai/v1/request/query-clickhouse \
--header 'Authorization: <api-key>' \
--header 'Content-Type: application/json' \
--data '
{
"filter": {
"values": {},
"response": {
"body_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"body_model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"body_completion": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request": {
"prompt": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"auth_hash": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"org_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"modelOverride": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"path": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"feedback": {
"id": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"rating": {
"equals": true
},
"response_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request_response_rmt": {
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"latency": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"provider": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"time_to_first_token": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"response_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"organization_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"job_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"threat": {
"equals": true
},
"request_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_read_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_write_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"target_url": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"properties": {},
"search_properties": {},
"scores": {},
"scores_column": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"response_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cache_enabled": {
"equals": true
},
"cache_reference_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cached": {
"equals": true
},
"assets": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"helicone-score-feedback": {
"equals": true
},
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_version": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_referrer": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"is_passthrough_billing": {
"equals": true
}
},
"sessions_request_response_rmt": {
"session_session_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_session_name": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_total_cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_requests": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_latest_request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_tag": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"properties": {}
},
"offset": 123,
"limit": 123,
"sort": {
"random": true,
"properties": {},
"values": {}
},
"isCached": true,
"includeInputs": true,
"isPartOfExperiment": true,
"isScored": true
}
'import requests
url = "https://api.helicone.ai/v1/request/query-clickhouse"
payload = {
"filter": {
"values": {},
"response": {
"body_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"body_model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"body_completion": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request": {
"prompt": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"auth_hash": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"org_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"modelOverride": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"path": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"feedback": {
"id": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"rating": { "equals": True },
"response_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request_response_rmt": {
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"latency": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"provider": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"time_to_first_token": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"response_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"organization_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"job_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"threat": { "equals": True },
"request_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_read_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_write_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"target_url": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"properties": {},
"search_properties": {},
"scores": {},
"scores_column": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"response_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cache_enabled": { "equals": True },
"cache_reference_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cached": { "equals": True },
"assets": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"helicone-score-feedback": { "equals": True },
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_version": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_referrer": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"is_passthrough_billing": { "equals": True }
},
"sessions_request_response_rmt": {
"session_session_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_session_name": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_total_cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_requests": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_latest_request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_tag": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"properties": {}
},
"offset": 123,
"limit": 123,
"sort": {
"random": True,
"properties": {},
"values": {}
},
"isCached": True,
"includeInputs": True,
"isPartOfExperiment": True,
"isScored": True
}
headers = {
"Authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
filter: {
values: {},
response: {
body_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
body_model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
body_completion: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
status: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
request: {
prompt: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
created_at: {
equals: '<string>',
gte: '<string>',
lte: '<string>',
lt: '<string>',
gt: '<string>'
},
user_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
auth_hash: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
org_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
node_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
modelOverride: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
path: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
country_code: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
prompt_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
feedback: {
id: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
created_at: {
equals: '<string>',
gte: '<string>',
lte: '<string>',
lt: '<string>',
gt: '<string>'
},
rating: {equals: true},
response_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
request_response_rmt: {
country_code: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
latency: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
cost: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
provider: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
time_to_first_token: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
status: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
request_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
response_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
user_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
organization_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
node_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
job_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
threat: {equals: true},
request_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
prompt_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
completion_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
prompt_cache_read_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
prompt_cache_write_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
total_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
target_url: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
properties: {},
search_properties: {},
scores: {},
scores_column: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
request_body: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
response_body: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
cache_enabled: {equals: true},
cache_reference_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
cached: {equals: true},
assets: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
'helicone-score-feedback': {equals: true},
prompt_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
prompt_version: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
request_referrer: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
is_passthrough_billing: {equals: true}
},
sessions_request_response_rmt: {
session_session_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
session_session_name: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
session_total_cost: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_total_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_prompt_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_completion_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_total_requests: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
session_latest_request_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
session_tag: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
properties: {}
},
offset: 123,
limit: 123,
sort: {random: true, properties: {}, values: {}},
isCached: true,
includeInputs: true,
isPartOfExperiment: true,
isScored: true
})
};
fetch('https://api.helicone.ai/v1/request/query-clickhouse', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.helicone.ai/v1/request/query-clickhouse",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'filter' => [
'values' => [
],
'response' => [
'body_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'body_model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'body_completion' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'status' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'request' => [
'prompt' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'created_at' => [
'equals' => '<string>',
'gte' => '<string>',
'lte' => '<string>',
'lt' => '<string>',
'gt' => '<string>'
],
'user_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'auth_hash' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'org_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'node_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'modelOverride' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'path' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'country_code' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'prompt_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'feedback' => [
'id' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'created_at' => [
'equals' => '<string>',
'gte' => '<string>',
'lte' => '<string>',
'lt' => '<string>',
'gt' => '<string>'
],
'rating' => [
'equals' => true
],
'response_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'request_response_rmt' => [
'country_code' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'latency' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'cost' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'provider' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'time_to_first_token' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'status' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'request_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'response_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'user_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'organization_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'node_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'job_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'threat' => [
'equals' => true
],
'request_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'prompt_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'completion_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'prompt_cache_read_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'prompt_cache_write_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'total_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'target_url' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'properties' => [
],
'search_properties' => [
],
'scores' => [
],
'scores_column' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'request_body' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'response_body' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'cache_enabled' => [
'equals' => true
],
'cache_reference_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'cached' => [
'equals' => true
],
'assets' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'helicone-score-feedback' => [
'equals' => true
],
'prompt_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'prompt_version' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'request_referrer' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'is_passthrough_billing' => [
'equals' => true
]
],
'sessions_request_response_rmt' => [
'session_session_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'session_session_name' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'session_total_cost' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_total_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_prompt_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_completion_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_total_requests' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'session_latest_request_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'session_tag' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'properties' => [
]
],
'offset' => 123,
'limit' => 123,
'sort' => [
'random' => true,
'properties' => [
],
'values' => [
]
],
'isCached' => true,
'includeInputs' => true,
'isPartOfExperiment' => true,
'isScored' => true
]),
CURLOPT_HTTPHEADER => [
"Authorization: <api-key>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.helicone.ai/v1/request/query-clickhouse"
payload := strings.NewReader("{\n \"filter\": {\n \"values\": {},\n \"response\": {\n \"body_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"body_model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"body_completion\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request\": {\n \"prompt\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"auth_hash\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"org_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"modelOverride\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"path\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"feedback\": {\n \"id\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"rating\": {\n \"equals\": true\n },\n \"response_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request_response_rmt\": {\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"latency\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"provider\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"time_to_first_token\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"response_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"organization_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"job_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"threat\": {\n \"equals\": true\n },\n \"request_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_read_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_write_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"target_url\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"properties\": {},\n \"search_properties\": {},\n \"scores\": {},\n \"scores_column\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"response_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cache_enabled\": {\n \"equals\": true\n },\n \"cache_reference_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cached\": {\n \"equals\": true\n },\n \"assets\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"helicone-score-feedback\": {\n \"equals\": true\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_version\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_referrer\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"is_passthrough_billing\": {\n \"equals\": true\n }\n },\n \"sessions_request_response_rmt\": {\n \"session_session_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_session_name\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_total_cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_requests\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_latest_request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_tag\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"properties\": {}\n },\n \"offset\": 123,\n \"limit\": 123,\n \"sort\": {\n \"random\": true,\n \"properties\": {},\n \"values\": {}\n },\n \"isCached\": true,\n \"includeInputs\": true,\n \"isPartOfExperiment\": true,\n \"isScored\": true\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.helicone.ai/v1/request/query-clickhouse")
.header("Authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"filter\": {\n \"values\": {},\n \"response\": {\n \"body_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"body_model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"body_completion\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request\": {\n \"prompt\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"auth_hash\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"org_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"modelOverride\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"path\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"feedback\": {\n \"id\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"rating\": {\n \"equals\": true\n },\n \"response_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request_response_rmt\": {\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"latency\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"provider\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"time_to_first_token\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"response_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"organization_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"job_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"threat\": {\n \"equals\": true\n },\n \"request_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_read_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_write_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"target_url\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"properties\": {},\n \"search_properties\": {},\n \"scores\": {},\n \"scores_column\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"response_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cache_enabled\": {\n \"equals\": true\n },\n \"cache_reference_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cached\": {\n \"equals\": true\n },\n \"assets\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"helicone-score-feedback\": {\n \"equals\": true\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_version\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_referrer\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"is_passthrough_billing\": {\n \"equals\": true\n }\n },\n \"sessions_request_response_rmt\": {\n \"session_session_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_session_name\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_total_cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_requests\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_latest_request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_tag\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"properties\": {}\n },\n \"offset\": 123,\n \"limit\": 123,\n \"sort\": {\n \"random\": true,\n \"properties\": {},\n \"values\": {}\n },\n \"isCached\": true,\n \"includeInputs\": true,\n \"isPartOfExperiment\": true,\n \"isScored\": true\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.helicone.ai/v1/request/query-clickhouse")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"filter\": {\n \"values\": {},\n \"response\": {\n \"body_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"body_model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"body_completion\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request\": {\n \"prompt\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"auth_hash\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"org_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"modelOverride\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"path\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"feedback\": {\n \"id\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"rating\": {\n \"equals\": true\n },\n \"response_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request_response_rmt\": {\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"latency\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"provider\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"time_to_first_token\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"response_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"organization_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"job_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"threat\": {\n \"equals\": true\n },\n \"request_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_read_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_write_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"target_url\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"properties\": {},\n \"search_properties\": {},\n \"scores\": {},\n \"scores_column\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"response_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cache_enabled\": {\n \"equals\": true\n },\n \"cache_reference_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cached\": {\n \"equals\": true\n },\n \"assets\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"helicone-score-feedback\": {\n \"equals\": true\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_version\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_referrer\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"is_passthrough_billing\": {\n \"equals\": true\n }\n },\n \"sessions_request_response_rmt\": {\n \"session_session_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_session_name\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_total_cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_requests\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_latest_request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_tag\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"properties\": {}\n },\n \"offset\": 123,\n \"limit\": 123,\n \"sort\": {\n \"random\": true,\n \"properties\": {},\n \"values\": {}\n },\n \"isCached\": true,\n \"includeInputs\": true,\n \"isPartOfExperiment\": true,\n \"isScored\": true\n}"
response = http.request(request)
puts response.read_body{
"filter": {},
"isCached": false,
"limit": 10,
"offset": 0,
"sort": {
"created_at": "desc"
},
"isScored": false,
"isPartOfExperiment": false
}Request
Get Requests
Retrieve all requests visible in the request table at Helicone.
POST
/
v1
/
request
/
query-clickhouse
cURL
curl --request POST \
--url https://api.helicone.ai/v1/request/query-clickhouse \
--header 'Authorization: <api-key>' \
--header 'Content-Type: application/json' \
--data '
{
"filter": {
"values": {},
"response": {
"body_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"body_model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"body_completion": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request": {
"prompt": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"auth_hash": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"org_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"modelOverride": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"path": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"feedback": {
"id": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"rating": {
"equals": true
},
"response_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request_response_rmt": {
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"latency": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"provider": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"time_to_first_token": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"response_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"organization_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"job_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"threat": {
"equals": true
},
"request_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_read_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_write_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"target_url": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"properties": {},
"search_properties": {},
"scores": {},
"scores_column": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"response_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cache_enabled": {
"equals": true
},
"cache_reference_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cached": {
"equals": true
},
"assets": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"helicone-score-feedback": {
"equals": true
},
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_version": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_referrer": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"is_passthrough_billing": {
"equals": true
}
},
"sessions_request_response_rmt": {
"session_session_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_session_name": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_total_cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_requests": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_latest_request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_tag": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"properties": {}
},
"offset": 123,
"limit": 123,
"sort": {
"random": true,
"properties": {},
"values": {}
},
"isCached": true,
"includeInputs": true,
"isPartOfExperiment": true,
"isScored": true
}
'import requests
url = "https://api.helicone.ai/v1/request/query-clickhouse"
payload = {
"filter": {
"values": {},
"response": {
"body_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"body_model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"body_completion": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request": {
"prompt": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"auth_hash": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"org_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"modelOverride": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"path": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"feedback": {
"id": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"created_at": {
"equals": "<string>",
"gte": "<string>",
"lte": "<string>",
"lt": "<string>",
"gt": "<string>"
},
"rating": { "equals": True },
"response_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"request_response_rmt": {
"country_code": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"latency": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"provider": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"time_to_first_token": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"status": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"response_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"model": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"user_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"organization_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"node_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"job_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"threat": { "equals": True },
"request_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_read_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"prompt_cache_write_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"target_url": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"properties": {},
"search_properties": {},
"scores": {},
"scores_column": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"response_body": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cache_enabled": { "equals": True },
"cache_reference_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"cached": { "equals": True },
"assets": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"helicone-score-feedback": { "equals": True },
"prompt_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"prompt_version": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"request_referrer": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"is_passthrough_billing": { "equals": True }
},
"sessions_request_response_rmt": {
"session_session_id": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_session_name": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
},
"session_total_cost": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_prompt_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_completion_tokens": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_total_requests": {
"not-equals": 123,
"equals": 123,
"gte": 123,
"lte": 123,
"lt": 123,
"gt": 123
},
"session_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_latest_request_created_at": {
"equals": "2023-11-07T05:31:56Z",
"gte": "2023-11-07T05:31:56Z",
"lte": "2023-11-07T05:31:56Z",
"lt": "2023-11-07T05:31:56Z",
"gt": "2023-11-07T05:31:56Z"
},
"session_tag": {
"not-equals": "<string>",
"equals": "<string>",
"like": "<string>",
"ilike": "<string>",
"contains": "<string>",
"not-contains": "<string>"
}
},
"properties": {}
},
"offset": 123,
"limit": 123,
"sort": {
"random": True,
"properties": {},
"values": {}
},
"isCached": True,
"includeInputs": True,
"isPartOfExperiment": True,
"isScored": True
}
headers = {
"Authorization": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
filter: {
values: {},
response: {
body_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
body_model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
body_completion: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
status: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
request: {
prompt: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
created_at: {
equals: '<string>',
gte: '<string>',
lte: '<string>',
lt: '<string>',
gt: '<string>'
},
user_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
auth_hash: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
org_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
node_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
modelOverride: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
path: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
country_code: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
prompt_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
feedback: {
id: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
created_at: {
equals: '<string>',
gte: '<string>',
lte: '<string>',
lt: '<string>',
gt: '<string>'
},
rating: {equals: true},
response_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
request_response_rmt: {
country_code: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
latency: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
cost: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
provider: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
time_to_first_token: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
status: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
request_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
response_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
model: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
user_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
organization_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
node_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
job_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
threat: {equals: true},
request_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
prompt_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
completion_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
prompt_cache_read_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
prompt_cache_write_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
total_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
target_url: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
properties: {},
search_properties: {},
scores: {},
scores_column: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
request_body: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
response_body: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
cache_enabled: {equals: true},
cache_reference_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
cached: {equals: true},
assets: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
'helicone-score-feedback': {equals: true},
prompt_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
prompt_version: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
request_referrer: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
is_passthrough_billing: {equals: true}
},
sessions_request_response_rmt: {
session_session_id: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
session_session_name: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
},
session_total_cost: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_total_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_prompt_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_completion_tokens: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_total_requests: {'not-equals': 123, equals: 123, gte: 123, lte: 123, lt: 123, gt: 123},
session_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
session_latest_request_created_at: {
equals: '2023-11-07T05:31:56Z',
gte: '2023-11-07T05:31:56Z',
lte: '2023-11-07T05:31:56Z',
lt: '2023-11-07T05:31:56Z',
gt: '2023-11-07T05:31:56Z'
},
session_tag: {
'not-equals': '<string>',
equals: '<string>',
like: '<string>',
ilike: '<string>',
contains: '<string>',
'not-contains': '<string>'
}
},
properties: {}
},
offset: 123,
limit: 123,
sort: {random: true, properties: {}, values: {}},
isCached: true,
includeInputs: true,
isPartOfExperiment: true,
isScored: true
})
};
fetch('https://api.helicone.ai/v1/request/query-clickhouse', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.helicone.ai/v1/request/query-clickhouse",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'filter' => [
'values' => [
],
'response' => [
'body_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'body_model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'body_completion' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'status' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'request' => [
'prompt' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'created_at' => [
'equals' => '<string>',
'gte' => '<string>',
'lte' => '<string>',
'lt' => '<string>',
'gt' => '<string>'
],
'user_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'auth_hash' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'org_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'node_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'modelOverride' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'path' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'country_code' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'prompt_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'feedback' => [
'id' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'created_at' => [
'equals' => '<string>',
'gte' => '<string>',
'lte' => '<string>',
'lt' => '<string>',
'gt' => '<string>'
],
'rating' => [
'equals' => true
],
'response_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'request_response_rmt' => [
'country_code' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'latency' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'cost' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'provider' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'time_to_first_token' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'status' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'request_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'response_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'model' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'user_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'organization_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'node_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'job_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'threat' => [
'equals' => true
],
'request_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'prompt_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'completion_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'prompt_cache_read_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'prompt_cache_write_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'total_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'target_url' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'properties' => [
],
'search_properties' => [
],
'scores' => [
],
'scores_column' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'request_body' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'response_body' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'cache_enabled' => [
'equals' => true
],
'cache_reference_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'cached' => [
'equals' => true
],
'assets' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'helicone-score-feedback' => [
'equals' => true
],
'prompt_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'prompt_version' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'request_referrer' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'is_passthrough_billing' => [
'equals' => true
]
],
'sessions_request_response_rmt' => [
'session_session_id' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'session_session_name' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
],
'session_total_cost' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_total_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_prompt_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_completion_tokens' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_total_requests' => [
'not-equals' => 123,
'equals' => 123,
'gte' => 123,
'lte' => 123,
'lt' => 123,
'gt' => 123
],
'session_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'session_latest_request_created_at' => [
'equals' => '2023-11-07T05:31:56Z',
'gte' => '2023-11-07T05:31:56Z',
'lte' => '2023-11-07T05:31:56Z',
'lt' => '2023-11-07T05:31:56Z',
'gt' => '2023-11-07T05:31:56Z'
],
'session_tag' => [
'not-equals' => '<string>',
'equals' => '<string>',
'like' => '<string>',
'ilike' => '<string>',
'contains' => '<string>',
'not-contains' => '<string>'
]
],
'properties' => [
]
],
'offset' => 123,
'limit' => 123,
'sort' => [
'random' => true,
'properties' => [
],
'values' => [
]
],
'isCached' => true,
'includeInputs' => true,
'isPartOfExperiment' => true,
'isScored' => true
]),
CURLOPT_HTTPHEADER => [
"Authorization: <api-key>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.helicone.ai/v1/request/query-clickhouse"
payload := strings.NewReader("{\n \"filter\": {\n \"values\": {},\n \"response\": {\n \"body_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"body_model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"body_completion\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request\": {\n \"prompt\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"auth_hash\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"org_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"modelOverride\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"path\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"feedback\": {\n \"id\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"rating\": {\n \"equals\": true\n },\n \"response_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request_response_rmt\": {\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"latency\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"provider\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"time_to_first_token\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"response_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"organization_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"job_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"threat\": {\n \"equals\": true\n },\n \"request_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_read_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_write_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"target_url\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"properties\": {},\n \"search_properties\": {},\n \"scores\": {},\n \"scores_column\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"response_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cache_enabled\": {\n \"equals\": true\n },\n \"cache_reference_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cached\": {\n \"equals\": true\n },\n \"assets\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"helicone-score-feedback\": {\n \"equals\": true\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_version\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_referrer\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"is_passthrough_billing\": {\n \"equals\": true\n }\n },\n \"sessions_request_response_rmt\": {\n \"session_session_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_session_name\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_total_cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_requests\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_latest_request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_tag\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"properties\": {}\n },\n \"offset\": 123,\n \"limit\": 123,\n \"sort\": {\n \"random\": true,\n \"properties\": {},\n \"values\": {}\n },\n \"isCached\": true,\n \"includeInputs\": true,\n \"isPartOfExperiment\": true,\n \"isScored\": true\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Authorization", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.helicone.ai/v1/request/query-clickhouse")
.header("Authorization", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"filter\": {\n \"values\": {},\n \"response\": {\n \"body_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"body_model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"body_completion\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request\": {\n \"prompt\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"auth_hash\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"org_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"modelOverride\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"path\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"feedback\": {\n \"id\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"rating\": {\n \"equals\": true\n },\n \"response_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request_response_rmt\": {\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"latency\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"provider\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"time_to_first_token\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"response_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"organization_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"job_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"threat\": {\n \"equals\": true\n },\n \"request_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_read_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_write_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"target_url\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"properties\": {},\n \"search_properties\": {},\n \"scores\": {},\n \"scores_column\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"response_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cache_enabled\": {\n \"equals\": true\n },\n \"cache_reference_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cached\": {\n \"equals\": true\n },\n \"assets\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"helicone-score-feedback\": {\n \"equals\": true\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_version\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_referrer\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"is_passthrough_billing\": {\n \"equals\": true\n }\n },\n \"sessions_request_response_rmt\": {\n \"session_session_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_session_name\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_total_cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_requests\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_latest_request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_tag\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"properties\": {}\n },\n \"offset\": 123,\n \"limit\": 123,\n \"sort\": {\n \"random\": true,\n \"properties\": {},\n \"values\": {}\n },\n \"isCached\": true,\n \"includeInputs\": true,\n \"isPartOfExperiment\": true,\n \"isScored\": true\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.helicone.ai/v1/request/query-clickhouse")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"filter\": {\n \"values\": {},\n \"response\": {\n \"body_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"body_model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"body_completion\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request\": {\n \"prompt\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"auth_hash\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"org_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"modelOverride\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"path\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"feedback\": {\n \"id\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"created_at\": {\n \"equals\": \"<string>\",\n \"gte\": \"<string>\",\n \"lte\": \"<string>\",\n \"lt\": \"<string>\",\n \"gt\": \"<string>\"\n },\n \"rating\": {\n \"equals\": true\n },\n \"response_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"request_response_rmt\": {\n \"country_code\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"latency\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"provider\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"time_to_first_token\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"status\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"response_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"model\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"user_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"organization_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"node_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"job_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"threat\": {\n \"equals\": true\n },\n \"request_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_read_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"prompt_cache_write_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"target_url\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"properties\": {},\n \"search_properties\": {},\n \"scores\": {},\n \"scores_column\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"response_body\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cache_enabled\": {\n \"equals\": true\n },\n \"cache_reference_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"cached\": {\n \"equals\": true\n },\n \"assets\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"helicone-score-feedback\": {\n \"equals\": true\n },\n \"prompt_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"prompt_version\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"request_referrer\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"is_passthrough_billing\": {\n \"equals\": true\n }\n },\n \"sessions_request_response_rmt\": {\n \"session_session_id\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_session_name\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n },\n \"session_total_cost\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_prompt_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_completion_tokens\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_total_requests\": {\n \"not-equals\": 123,\n \"equals\": 123,\n \"gte\": 123,\n \"lte\": 123,\n \"lt\": 123,\n \"gt\": 123\n },\n \"session_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_latest_request_created_at\": {\n \"equals\": \"2023-11-07T05:31:56Z\",\n \"gte\": \"2023-11-07T05:31:56Z\",\n \"lte\": \"2023-11-07T05:31:56Z\",\n \"lt\": \"2023-11-07T05:31:56Z\",\n \"gt\": \"2023-11-07T05:31:56Z\"\n },\n \"session_tag\": {\n \"not-equals\": \"<string>\",\n \"equals\": \"<string>\",\n \"like\": \"<string>\",\n \"ilike\": \"<string>\",\n \"contains\": \"<string>\",\n \"not-contains\": \"<string>\"\n }\n },\n \"properties\": {}\n },\n \"offset\": 123,\n \"limit\": 123,\n \"sort\": {\n \"random\": true,\n \"properties\": {},\n \"values\": {}\n },\n \"isCached\": true,\n \"includeInputs\": true,\n \"isPartOfExperiment\": true,\n \"isScored\": true\n}"
response = http.request(request)
puts response.read_body{
"filter": {},
"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.NPM Package (Recommended)
Use our CLI tool:
npx @helicone/export - No installation required!Python Example
See how to query requests using our Python SDK.
TypeScript Example
Learn to fetch requests with TypeScript/JavaScript.
Quick Start with NPM
The easiest way to export data is using our CLI tool:# Export with npx (no installation required)
HELICONE_API_KEY="your-api-key" npx @helicone/export --start-date 2024-01-01 --limit 10000 --include-body
# With property filter
HELICONE_API_KEY="your-api-key" npx @helicone/export --property appname=MyApp --format csv --include-body
# With date range and full bodies
HELICONE_API_KEY="your-api-key" npx @helicone/export --start-date 2024-08-01 --end-date 2024-08-31 --include-body
# Export from EU region
HELICONE_API_KEY="your-eu-api-key" npx @helicone/export --region eu --limit 10000 --include-body
- ✅ Auto-recovery from crashes with checkpoint system
- ✅ Retry logic with exponential backoff
- ✅ Progress tracking with ETA
- ✅ Multiple output formats (JSON, JSONL, CSV)
- ✅ Region support (US and EU)
Premade examples 👇
| Filter | Description |
|---|---|
| Get Request by User | Get all the requests made by a user |
Filter Structure
Common Mistake: When filtering by custom properties, you MUST wrap them in a See the Filtering by Properties section below for complete examples.
request_response_rmt object. Forgetting this wrapper will return empty results {"data":[],"error":null} even when data exists.// ❌ WRONG - Missing request_response_rmt wrapper
{
"filter": {
"properties": {
"ticket-id": { "equals": "..." }
}
}
}
// ✅ CORRECT - Properties wrapped in request_response_rmt
{
"filter": {
"request_response_rmt": {
"properties": {
"ticket-id": { "equals": "..." }
}
}
}
}
Important: Filters use an AST (Abstract Syntax Tree) structure where each condition must be a separate leaf node. You cannot combine multiple conditions in a single
request_response_rmt object.TypeScript Types
export interface FilterBranch {
left: FilterNode;
operator: "or" | "and";
right: FilterNode;
}
export type FilterLeaf = {
request_response_rmt: {
[field: string]: {
[operator: string]: any;
};
};
};
export type FilterNode = FilterLeaf | FilterBranch | "all";
Simple Filter (Single Condition)
{
"filter": {
"request_response_rmt": {
"model": {
"contains": "gpt-4"
}
}
}
}
Complex Filter (Multiple Conditions)
Each condition is a separate leaf, connected withand/or operators:
{
"filter": {
"left": {
"request_response_rmt": {
"model": {
"contains": "gpt-4"
}
}
},
"operator": "and",
"right": {
"request_response_rmt": {
"user_id": {
"equals": "abc@email.com"
}
}
}
}
}
Match All Requests (No Filter)
{
"filter": "all"
}
Filtering by Date Range
Date ranges use inclusive bounds - both
gte (greater than or equal) and lte (less than or equal) include the specified timestamps.{
"filter": {
"request_response_rmt": {
"request_created_at": {
"gte": "2024-01-01T00:00:00Z"
}
}
}
}
Important: Each date condition must be a separate leaf! Don’t put both
gte and lte in the same object.{
"filter": {
"left": {
"request_response_rmt": {
"request_created_at": {
"gte": "2024-01-01T00:00:00Z"
}
}
},
"operator": "and",
"right": {
"request_response_rmt": {
"request_created_at": {
"lte": "2024-12-31T23:59:59Z"
}
}
}
}
}
gte- Greater than or equal (start date, inclusive)lte- Less than or equal (end date, inclusive)gt- Greater than (exclusive)lt- Less than (exclusive)equals- Exact timestamp match
Filtering by Properties
Important: When filtering by custom properties, you must nest the
properties filter inside a request_response_rmt object.{
"filter": {
"request_response_rmt": {
"properties": {
"environment": {
"equals": "production"
}
}
}
}
}
{
"filter": {
"left": {
"request_response_rmt": {
"model": {
"equals": "gpt-4"
}
}
},
"operator": "and",
"right": {
"request_response_rmt": {
"properties": {
"environment": {
"equals": "production"
}
}
}
}
}
}
Complete Example: Date Range + Property Filter
This example shows how to combine a date range with a property filter:{
"filter": {
"left": {
"left": {
"request_response_rmt": {
"request_created_at": {
"gte": "2024-08-01T00:00:00Z"
}
}
},
"operator": "and",
"right": {
"request_response_rmt": {
"request_created_at": {
"lte": "2024-08-31T23:59:59Z"
}
}
}
},
"operator": "and",
"right": {
"request_response_rmt": {
"properties": {
"appname": {
"equals": "LlamaCoder"
}
}
}
}
},
"limit": 100,
"offset": 0
}
Available Filter Operators
Different fields support different operators: Text fields (model, user_id, provider, etc.):
equals/not-equalslike/ilike(case-insensitive)contains/not-contains
status, latency, cost, etc.):
equals/not-equalsgte/lte/gt/lt
request_created_at, response_created_at):
equalsgte/lte/gt/lt
Troubleshooting
Getting Empty Results {"data":[],"error":null}
If you’re getting empty results when you know data exists, check these common issues:
1. Missing request_response_rmt wrapper for properties
❌ WRONG - Properties without wrapper
❌ WRONG - Properties without wrapper
curl --request POST \
--url https://api.helicone.ai/v1/request/query-clickhouse \
--header "Content-Type: application/json" \
--header "authorization: Bearer $HELICONE_API_KEY" \
--data '{
"filter": {
"properties": {
"ticket-id": {
"equals": "ba9bf8b3-c04f-41ad-9362-37f8feff7e57"
}
}
}
}'
✅ CORRECT - Properties with request_response_rmt wrapper
✅ CORRECT - Properties with request_response_rmt wrapper
curl --request POST \
--url https://api.helicone.ai/v1/request/query-clickhouse \
--header "Content-Type: application/json" \
--header "authorization: Bearer $HELICONE_API_KEY" \
--data '{
"filter": {
"request_response_rmt": {
"properties": {
"ticket-id": {
"equals": "ba9bf8b3-c04f-41ad-9362-37f8feff7e57"
}
}
}
}
}'
/query-clickhouse) requires request_response_rmt wrapper for ALL filters including properties. If you’re using the legacy /query endpoint, the filter structure is different - see Get Requests (Legacy).
3. Wrong region
Make sure you’re using the correct regional endpoint:
- US:
https://api.helicone.ai/v1/request/query-clickhouse - EU:
https://eu.api.helicone.ai/v1/request/query-clickhouse
Authorizations
Bearer token authentication. Format: 'Bearer YOUR_API_KEY'
Body
application/json
From T, pick a set of properties whose keys are in the union K
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Was this page helpful?
⌘I