Executes a GAQ and returns the result as an Arrow stream.
curl --request POST \
--url http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq \
--header 'Content-Type: application/json' \
--data '
{
"cubeName": "<string>",
"measures": [
"<string>"
],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": {
"values": {}
},
"notInConditions": {
"values": {}
}
},
"timeout": 123
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq"
payload = {
"cubeName": "<string>",
"measures": ["<string>"],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": { "values": {} },
"notInConditions": { "values": {} }
},
"timeout": 123
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({
cubeName: '<string>',
measures: ['<string>'],
branch: '<string>',
context: {},
coordinates: {},
filter: {isInConditions: {values: {}}, notInConditions: {values: {}}},
timeout: 123
})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_PORT => "9090",
CURLOPT_URL => "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq",
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([
'cubeName' => '<string>',
'measures' => [
'<string>'
],
'branch' => '<string>',
'context' => [
],
'coordinates' => [
],
'filter' => [
'isInConditions' => [
'values' => [
]
],
'notInConditions' => [
'values' => [
]
]
],
'timeout' => 123
]),
CURLOPT_HTTPHEADER => [
"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 := "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq"
payload := strings.NewReader("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}")
req, _ := http.NewRequest("POST", url, payload)
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("http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq")
.header("Content-Type", "application/json")
.body("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}"
response = http.request(request)
puts response.read_bodyExecutes a gaq and returns the result as an arrow stream
POST
/
activeviam
/
pivot
/
rest
/
v10
/
cube
/
query
/
gaq
Executes a GAQ and returns the result as an Arrow stream.
curl --request POST \
--url http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq \
--header 'Content-Type: application/json' \
--data '
{
"cubeName": "<string>",
"measures": [
"<string>"
],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": {
"values": {}
},
"notInConditions": {
"values": {}
}
},
"timeout": 123
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq"
payload = {
"cubeName": "<string>",
"measures": ["<string>"],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": { "values": {} },
"notInConditions": { "values": {} }
},
"timeout": 123
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({
cubeName: '<string>',
measures: ['<string>'],
branch: '<string>',
context: {},
coordinates: {},
filter: {isInConditions: {values: {}}, notInConditions: {values: {}}},
timeout: 123
})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_PORT => "9090",
CURLOPT_URL => "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq",
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([
'cubeName' => '<string>',
'measures' => [
'<string>'
],
'branch' => '<string>',
'context' => [
],
'coordinates' => [
],
'filter' => [
'isInConditions' => [
'values' => [
]
],
'notInConditions' => [
'values' => [
]
]
],
'timeout' => 123
]),
CURLOPT_HTTPHEADER => [
"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 := "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq"
payload := strings.NewReader("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}")
req, _ := http.NewRequest("POST", url, payload)
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("http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq")
.header("Content-Type", "application/json")
.body("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}"
response = http.request(request)
puts response.read_bodyBody
application/json
Additional context values to configure query execution. Supported context values include:
queriesTimeLimit: Query timeout in seconds (e.g., "30")queriesResultLimit: Maximum number of cells to return (e.g., "10000")
Context values are applied during query execution and reset after the query completes.
Show child attributes
Show child attributes
The coordinates for the query, mapping level descriptions to level members.
Use null or the wildcard string as the value to express a wildcard (all members) for a given level. The wildcard string defaults to [*] and can be configured via the activepivot.location.wildcard system property. For example: {"Currency@Currency@Currency": ["[*]"]}.
Show child attributes
Show child attributes
Response
200 - application/vnd.apache.arrow.stream
Successful execution of the GAQ.
Was this page helpful?