Execute Agent Insights free-form SQL

POST/v1/internal/analytics-queries/projects/{projectId}Execute Agent Insights free-form SQL

Runs Ollie-generated read-only SQL bounded to the caller's workspace and the requested project. Returns 501 when the Agent Insights toggle is off.

Parameters

projectIdstring · uuidpathrequired

Request body

application/json

objectAnalyticsQueryRequest

querystringrequired

Read-only ClickHouse SQL. Must return exactly one column named `result` produced via toJSONString(...)

minLength 1

Example request

{
  "query": "string"
}

Responses

objectAnalyticsQueryResponse

resultsarray of object

Show child attributes

Example response

{
  "results": [
    {}
  ]
}

objectErrorMessage

codeinteger · int32

detailsstring

messagestring

Example response

{
  "code": 0,
  "details": "string",
  "message": "string"
}

objectErrorMessage

codeinteger · int32

detailsstring

messagestring

Example response

{
  "code": 0,
  "details": "string",
  "message": "string"
}

Examples

projectIdrequiredpath parameter

curl -X POST 'http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000' \
  -H 'Content-Type: application/json' \
  -d '{"query":"string"}'

const response = await fetch('http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000', {
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({"query":"string"}),
});
const data = await response.json();

const response = await fetch('http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: "{\"query\":\"string\"}" });
console.log(await response.json());

import requests

response = requests.request(
    "POST",
    "http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000",
    headers={"Content-Type": "application/json"},
    data='{"query":"string"}',
)
print(response.json())

package main

import (
	"context"
	"net/http"
	"strings"
)

func main() {
	ctx := context.Background()
	body := strings.NewReader(`{"query":"string"}`)
	req, err := http.NewRequestWithContext(ctx, "POST", "http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000", body)
	if err != nil {
		panic(err)
	}
	req.Header.Set("Content-Type", "application/json")
	resp, err := http.DefaultClient.Do(req)
	if err != nil {
		panic(err)
	}
	defer resp.Body.Close()
}

<?php
$request = curl_init("http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000");
curl_setopt($request, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($request, CURLOPT_POSTFIELDS, "{\"query\":\"string\"}");
curl_setopt($request, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);
$response = curl_exec($request);
curl_close($request);

var request = HttpRequest.newBuilder(URI.create("http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000"))
    .method("POST", HttpRequest.BodyPublishers.noBody())
    .header("Content-Type", "application/json")
    .method("POST", HttpRequest.BodyPublishers.ofString("{\"query\":\"string\"}"))
    .build();
var response = HttpClient.newHttpClient().send(request, HttpResponse.BodyHandlers.ofString());

require 'net/http'

uri = URI("http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000")
request = Net::HTTPGenericRequest.new("POST", true, true, uri)
request['Content-Type'] = 'application/json'
request.body = "{\"query\":\"string\"}"
response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: true) { |http| http.request(request) }

using var client = new HttpClient();
using var request = new HttpRequestMessage(HttpMethod.Post, "http://localhost:5173/api/v1/internal/analytics-queries/projects/00000000-0000-0000-0000-000000000000");
request.Content = new StringContent("{\"query\":\"string\"}", Encoding.UTF8, "application/json");
using var response = await client.SendAsync(request);

{
  "results": [
    {}
  ]
}

{
  "code": 0,
  "details": "string",
  "message": "string"
}

{
  "code": 0,
  "details": "string",
  "message": "string"
}