curl --request GET \
  --url https://app.datafold.com/api/v1/dma/v2/projects/{project_id}/translate/jobs/{job_id} \
  --header 'Authorization: <api-key>'

{
  "status": "needs_confirmation",
  "task_id": "<string>",
  "translated_models": [
    {
      "asset_id": "<string>",
      "asset_name": "<string>",
      "translation_status": "no_translation_attempts",
      "datadiff_id": 123,
      "failure_summary": {
        "error_message": "<string>",
        "problem": "<string>",
        "reason": "max_iterations",
        "solution": "<string>",
        "location": "<string>"
      },
      "source_filename": "<string>",
      "source_sql": "<string>",
      "target_sql": "<string>"
    }
  ]
}