Run SQL Query

curl -X POST "https://app.rybbit.io/api/organizations/org_123/analytics/query" \
  -H "Authorization: Bearer your_api_key_here" \
  -H "Content-Type: application/json" \
  -d '{
    "query": "SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = '\''pageview'\'' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10",
    "siteId": 123
  }'

const response = await fetch(
  'https://app.rybbit.io/api/organizations/org_123/analytics/query',
  {
    method: 'POST',
    headers: {
      'Authorization': 'Bearer your_api_key_here',
      'Content-Type': 'application/json'
    },
    body: JSON.stringify({
      query: 'SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = \'pageview\' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10',
      siteId: 123
    })
  }
);

const data = await response.json();

import requests

response = requests.post(
    'https://app.rybbit.io/api/organizations/org_123/analytics/query',
    json={
        'query': 'SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = \'pageview\' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10',
        'siteId': 123
    },
    headers={
        'Authorization': 'Bearer your_api_key_here'
    }
)

data = response.json()

$body = [
    'query' => 'SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = \'pageview\' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10',
    'siteId' => 123
];

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://app.rybbit.io/api/organizations/org_123/analytics/query');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'POST');
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($body));
curl_setopt($ch, CURLOPT_HTTPHEADER, [
    'Authorization: Bearer your_api_key_here',
    'Content-Type: application/json'
]);

$response = curl_exec($ch);
curl_close($ch);

$data = json_decode($response, true);

require 'net/http'
require 'json'

uri = URI('https://app.rybbit.io/api/organizations/org_123/analytics/query')
request = Net::HTTP::Post.new(uri)
request['Authorization'] = 'Bearer your_api_key_here'
request['Content-Type'] = 'application/json'
request.body = {
  query: 'SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = \'pageview\' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10',
  siteId: 123
}.to_json

response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: true) do |http|
  http.request(request)
end

data = JSON.parse(response.body)

body := map[string]interface{}{
    "query": "SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = 'pageview' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10",
    "siteId": 123,
}
jsonBody, _ := json.Marshal(body)

req, _ := http.NewRequest("POST", "https://app.rybbit.io/api/organizations/org_123/analytics/query", bytes.NewBuffer(jsonBody))
req.Header.Set("Authorization", "Bearer your_api_key_here")
req.Header.Set("Content-Type", "application/json")

client := &http.Client{}
resp, _ := client.Do(req)
defer resp.Body.Close()

var data map[string]interface{}
json.NewDecoder(resp.Body).Decode(&data)

let body = serde_json::json!({
  "query": "SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = 'pageview' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10",
  "siteId": 123
});

let client = reqwest::Client::new();
let res = client
    .post("https://app.rybbit.io/api/organizations/org_123/analytics/query")
    .header("Authorization", "Bearer your_api_key_here")
    .json(&body)
    .send()
    .await?;

let data: serde_json::Value = res.json().await?;

String json = """
{
  "query": "SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = 'pageview' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10",
  "siteId": 123
}
""";

HttpClient client = HttpClient.newHttpClient();
HttpRequest request = HttpRequest.newBuilder()
    .uri(URI.create("https://app.rybbit.io/api/organizations/org_123/analytics/query"))
    .header("Authorization", "Bearer your_api_key_here")
    .header("Content-Type", "application/json")
    .POST(HttpRequest.BodyPublishers.ofString(json))
    .build();

HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString());

var body = new
{
    query = "SELECT pathname, count() AS pageviews FROM scoped_events WHERE type = 'pageview' AND timestamp >= now() - INTERVAL 7 DAY GROUP BY pathname ORDER BY pageviews DESC LIMIT 10",
    siteId = 123
};

using var client = new HttpClient();
client.DefaultRequestHeaders.Add("Authorization", "Bearer your_api_key_here");

var content = new StringContent(
    JsonSerializer.Serialize(body),
    Encoding.UTF8,
    "application/json");

var response = await client.PostAsync("https://app.rybbit.io/api/organizations/org_123/analytics/query", content);
var data = await response.Content.ReadAsStringAsync();