GET
/
v1
/
database
/
query
/
{worksheet_query_id}
/
result
/
csharp
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);
    }
}
{
  "worksheet_query_id": "123e4567-e89b-12d3-a456-426614174000",
  "status": "SUCCESS",
  "results": [
    {
      "query_id": "123e4567-e89b-12d3-a456-426614174000",
      "query": "SELECT * FROM files LIMIT 3",
      "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_123",
          "2024-04-29 21:11:17+00:00"
        ],
        [
          "example2.png",
          "file_456",
          "2024-04-29 21:11:18+00:00"
        ],
        [
          "example3.mp4",
          "file_789",
          "2024-04-29 21:11:19+00:00"
        ]
      ],
      "start_timestamp": 1719852303.0115254,
      "end_timestamp": 1719852303.0204659
    }
  ],
  "error": null
}

Authorizations

​
Authorization
string
header
required

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

Path Parameters

​
worksheet_query_id
string
required

Response

200
application/json

Query results

The response is of type object.