Database
Query Result
Get the results of a query task.
GET
/
v1
/
database
/
query
/
{query_task_id}
/
result
using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Threading.Tasks;
class Program
{
static async Task Main(string[] args)
{
string queryTaskId = "YOUR_QUERY_TASK_ID"; // Replace with your query task ID
string token = "YOUR_API_TOKEN"; // Replace with your API token
string url = $"https://api.roe-ai.com/v1/database/query/{queryTaskId}/result/";
using var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token);
HttpResponseMessage response = await client.GetAsync(url);
string responseBody = await response.Content.ReadAsStringAsync();
Console.WriteLine(responseBody);
}
}
{
"query_task_id": "123e4567-e89b-12d3-a456-426614174000",
"results": [
{
"query_id": "123e4567-e89b-12d3-a456-426614174000",
"query": "SELECT * FROM example",
"summary": {
"read_rows": 3,
"read_bytes": 123,
"written_rows": 0,
"written_bytes": 0,
"total_rows_to_read": 3,
"result_rows": 3,
"result_bytes": 123,
"elapsed_ns": 1000000,
"query_id": "123e4567-e89b-12d3-a456-426614174000"
},
"row_count": 3,
"column_names": [
"name",
"file",
"created_at"
],
"column_types": [
"String",
"String",
"DateTime"
],
"result_rows": [
[
"example1.pdf",
"file_123e4567-e89b-12d3-a456-426614174001",
"2024-04-29 21:11:17+00:00"
],
[
"example2.png",
"file_123e4567-e89b-12d3-a456-426614174002",
"2024-04-29 21:11:18+00:00"
],
[
"example3.mp4",
"file_123e4567-e89b-12d3-a456-426614174003",
"2024-04-29 21:11:19+00:00"
]
],
"start_timestamp": 1719852303.0115254,
"end_timestamp": 1719852303.0204659
}
]
}
Authorizations
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Path Parameters
Response
200
application/json
Query results
The response is of type object
.
using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Threading.Tasks;
class Program
{
static async Task Main(string[] args)
{
string queryTaskId = "YOUR_QUERY_TASK_ID"; // Replace with your query task ID
string token = "YOUR_API_TOKEN"; // Replace with your API token
string url = $"https://api.roe-ai.com/v1/database/query/{queryTaskId}/result/";
using var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token);
HttpResponseMessage response = await client.GetAsync(url);
string responseBody = await response.Content.ReadAsStringAsync();
Console.WriteLine(responseBody);
}
}
{
"query_task_id": "123e4567-e89b-12d3-a456-426614174000",
"results": [
{
"query_id": "123e4567-e89b-12d3-a456-426614174000",
"query": "SELECT * FROM example",
"summary": {
"read_rows": 3,
"read_bytes": 123,
"written_rows": 0,
"written_bytes": 0,
"total_rows_to_read": 3,
"result_rows": 3,
"result_bytes": 123,
"elapsed_ns": 1000000,
"query_id": "123e4567-e89b-12d3-a456-426614174000"
},
"row_count": 3,
"column_names": [
"name",
"file",
"created_at"
],
"column_types": [
"String",
"String",
"DateTime"
],
"result_rows": [
[
"example1.pdf",
"file_123e4567-e89b-12d3-a456-426614174001",
"2024-04-29 21:11:17+00:00"
],
[
"example2.png",
"file_123e4567-e89b-12d3-a456-426614174002",
"2024-04-29 21:11:18+00:00"
],
[
"example3.mp4",
"file_123e4567-e89b-12d3-a456-426614174003",
"2024-04-29 21:11:19+00:00"
]
],
"start_timestamp": 1719852303.0115254,
"end_timestamp": 1719852303.0204659
}
]
}