Get Execution Status

Sprint 3

Get execution status by execution ID.

Endpoint

GET /api/v1/prompt-executions/{execution_id}

Headers

Header	Required	Description
Authorization	Yes	Bearer <access_token>

Path Parameters

Parameter	Type	Required	Description
execution_id	integer	Yes	Execution ID

Response

Success (200)

{
  "success": true,
  "data": {
    "execution_id": 1,
    "prompt_id": 5,
    "status": "completed",
    "ai_processing_status": "completed",
    "query_execution_status": "completed",
    "started_at": "2024-12-01T10:00:00Z",
    "ai_processing_started_at": "2024-12-01T10:00:00Z",
    "ai_processing_completed_at": "2024-12-01T10:00:05Z",
    "ai_response_time_ms": 5000,
    "query_execution_started_at": "2024-12-01T10:00:05Z",
    "query_execution_completed_at": "2024-12-01T10:00:10Z",
    "query_execution_duration_ms": 5000,
    "total_duration_ms": 10000,
    "completed_at": "2024-12-01T10:00:10Z",
    "generated_query_id": 10,
    "generated_query_text": "SELECT region, SUM(sales) FROM sales_data GROUP BY region",
    "rows_returned": 5,
    "result_preview": [
      {"region": "North", "total_sales": 150000}
    ],
    "error_message": null,
    "error_code": null,
    "ai_metadata": {
      "model": "gpt-4",
      "confidence": 0.95,
      "tokens_used": 150
    },
    "progress_percentage": 100
  },
  "message": "Execution status retrieved successfully"
}

Error Codes

Status	Code	Description
401	UNAUTHORIZED	Invalid or missing authentication token
404	NOT_FOUND	Execution not found

Features

• Detailed execution status
• AI processing status tracking
• Query execution status tracking
• Progress percentage
• Result preview
• Error information
• Organization-scoped access control

Status Values

• processing: Execution in progress
• completed: Execution completed successfully
• failed: Execution failed

Example

curl -X GET "https://api.rivergen.com/api/v1/prompt-executions/1" \
  -H "Authorization: Bearer <access_token>"

Related Endpoints

• Execute Prompt - Execute new prompt
• Get Execution History - Get execution history for a prompt