curl --request POST \
--url https://partner.peaka.studio/api/v1/data/projects/{projectId}/queries/execute \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"from": [
{
"catalogName": "peaka",
"schemaName": "query",
"tableName": "samplequery"
}
]
}'
{
"columns": [
{
"catalogId": "2",
"catalogName": "peaka",
"schemaName": "query",
"tableName": "samplequery",
"columnName": "amount"
}
],
"data": [
[
{
"name": "amount",
"displayName": "amount",
"dataType": "bigint",
"value": "75",
"order": 0
}
],
[
{
"name": "amount",
"displayName": "amount",
"dataType": "bigint",
"value": "75",
"order": 0
}
],
[
{
"name": "amount",
"displayName": "amount",
"dataType": "bigint",
"value": "75",
"order": 0
}
]
]
}
curl --request POST \
--url https://partner.peaka.studio/api/v1/data/projects/{projectId}/queries/execute \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
"from": [
{
"catalogName": "peaka",
"schemaName": "query",
"tableName": "samplequery"
}
]
}'
{
"columns": [
{
"catalogId": "2",
"catalogName": "peaka",
"schemaName": "query",
"tableName": "samplequery",
"columnName": "amount"
}
],
"data": [
[
{
"name": "amount",
"displayName": "amount",
"dataType": "bigint",
"value": "75",
"order": 0
}
],
[
{
"name": "amount",
"displayName": "amount",
"dataType": "bigint",
"value": "75",
"order": 0
}
],
[
{
"name": "amount",
"displayName": "amount",
"dataType": "bigint",
"value": "75",
"order": 0
}
]
]
}
Use the Authorization header with the value 'Bearer <apiKey>' to authenticate. Partner API Keys have full access; Project API Keys are limited to their project scope. Learn more: https://docs.peaka.com/api-reference/authentication
Execute Query Request
The body is of type object
.
Query Result
Represents the result of a query.