Singlestore Query Rows Example

{
  "title": "Query Data Rows Example",
  "description": "Example request and response for querying data using the SingleStore Data API",
  "request": {
    "method": "POST",
    "url": "https://{workspace-host}/api/v2/query/rows",
    "headers": {
      "Authorization": "Bearer your-api-key-here",
      "Content-Type": "application/json"
    },
    "body": {
      "sql": "SELECT id, customer_id, amount, created_at FROM orders WHERE created_at >= ? ORDER BY created_at DESC LIMIT 10",
      "database": "production",
      "args": ["2026-05-01 00:00:00"]
    }
  },
  "response": {
    "status": 200,
    "body": {
      "results": [
        {
          "columns": [
            {"name": "id", "dataType": "BIGINT"},
            {"name": "customer_id", "dataType": "BIGINT"},
            {"name": "amount", "dataType": "DECIMAL"},
            {"name": "created_at", "dataType": "DATETIME"}
          ],
          "rows": [
            {"id": 1042, "customer_id": 789, "amount": 149.99, "created_at": "2026-05-02T10:30:00Z"},
            {"id": 1041, "customer_id": 456, "amount": 89.50, "created_at": "2026-05-02T09:15:00Z"}
          ]
        }
      ]
    }
  }
}