Database
Run Query Async
Run a query as in Roe AI workspace asynchronously. Returns the query task ID which can be used to check status and get results.
POST
/
v1
/
database
/
query
/
async
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);
}
}
"123e4567-e89b-12d3-a456-426614174000"
Authorizations
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Body
Response
200
application/json
Query task ID
The response is of type string
.
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);
}
}
"123e4567-e89b-12d3-a456-426614174000"