Skip to main content
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
}

Query Parameters

​
worksheet_id
string
​
organization_id
string<uuid>

Body

​
query
string
required
Minimum length: 1
​
worksheet_id
string<uuid> | null
​
use_admin
boolean
default:false

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
​
creator
object