POST
/
v1
/
database
/
query
/
async
/
csharp
using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Text.Json;
using System.Threading.Tasks;

class Program
{
    static async Task Main(string[] args)
    {
        string token = "YOUR_API_TOKEN"; // Replace with your API token
        string url = "https://api.roe-ai.com/v1/database/query/async/";
        
        // Create payload
        var payload = new
        {
            query = "YOUR_SQL_QUERY", // Replace with your SQL query
            organization_id = "3c90c3cc-0d44-4b50-8888-8dd25736052a"
        };
        
        string jsonPayload = JsonSerializer.Serialize(payload);
        
        using var client = new HttpClient();
        client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token);
        
        // Create request content
        var content = new StringContent(jsonPayload, Encoding.UTF8, "application/json");
        
        // Send request
        HttpResponseMessage response = await client.PostAsync(url, content);
        string responseBody = await response.Content.ReadAsStringAsync();
        
        Console.WriteLine(responseBody);
    }
}
{
  "query": "SELECT * FROM users LIMIT 10",
  "worksheet_id": "123e4567-e89b-12d3-a456-426614174000",
  "use_admin": false
}

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

organization_id
string<uuid>

Organization ID. This is required for access control. It can be provided via query or request body depending on the endpoint.

Body

Serializer for creating worksheet queries.

query
string
required
Minimum length: 1
worksheet_id
string<uuid> | null

Worksheet ID to associate with the query

use_admin
boolean
default:false

Whether to use admin privileges

Response

id
string<uuid>
required
created_at
string<date-time>
required
updated_at
string<date-time>
required
finished_at
string<date-time> | null
required
query
string
required
query_task_id
string | null
required
query_task_status
string | null
required
error
string | null
required
ai_summary
string | null
required
worksheet
object
organization
object

Simple organization serializer for nested use.

creator
object