curl --request PUT \
  --url https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/extraction/{extraction_id} \
  --header 'Content-Type: application/json' \
  --data @- <<EOF
{
  "id": 6422272,
  "title": "extracted transcripts config",
  "extractionMode": "ADVANCED",
  "elementType": "COLUMN",
  "elementId": "767e6bc2-b4db-4c35-9733-ff4a638772b1",
  "storeExtractedData": true,
  "scheduleType": "MANUAL",
  "schedule": {
    "cronExpression": ""
  },
  "outputConfiguration": {
    "createNewWorkbook": false,
    "title": "extracted transcripts",
    "tableId": "5722991e-c826-460b-902f-ccf241f4bc80"
  },
  "inputTableId": "5a408388-4c83-4007-8921-f5b7c72509f2",
  "primaryKeyColumnId": [
    "acd7f6ee-3c93-4f13-a854-d476aa8f8cbd"
  ],
  "columnConfiguration": [
    {
      "name": "title",
      "description": "A descriptive title for the transcript (e.g., 'Meeting with John Doe', 'Interview on AI').",
      "uiMetadata": {
        "title": "Title"
      },
      "id": "d86ed28b-8642-430e-8070-3512419aee3e",
      "uiDataType": "SINGLE_LINE_TEXT"
    },
    {
      "name": "segments",
      "description": "An ordered list of speech segments, each typically from a single speaker.",
      "uiMetadata": {
        "title": "Segments"
      },
      "id": "d6882086-f833-4519-a6b4-0f1c7c620ff9",
      "uiDataType": "JSON"
    },
    {
      "name": "source_url",
      "description": "Optional URL to the original audio or video source file.",
      "uiMetadata": {
        "title": "Source Url"
      },
      "id": "84ebd7e8-ba2f-4d2d-8a1f-9e07fe4b143b",
      "uiDataType": "SINGLE_LINE_TEXT"
    },
    {
      "name": "transcript_id",
      "description": "A unique identifier for this specific transcript.",
      "uiMetadata": {
        "title": "Transcript Id"
      },
      "id": "48402e60-2bfa-4c55-b021-beff3040863f",
      "uiDataType": "SINGLE_LINE_TEXT"
    },
    {
      "name": "duration_seconds",
      "description": "The total duration of the transcribed audio/video in seconds.",
      "uiMetadata": {
        "title": "Duration Seconds"
      },
      "id": "5524d94b-33a3-443b-839c-93e3c0f0fd57",
      "uiDataType": "NUMBER"
    }
  ],
  "advancedSchema": {
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "title": {
        "type": "string",
        "description": "A descriptive title for the transcript (e.g., 'Meeting with John Doe', 'Interview on AI')."
      },
      "segments": {
        "type": "array",
        "description": "An ordered list of speech segments, each typically from a single speaker.",
        "items": {
          "type": "object",
          "properties": {
            "segmentssegmentssegmentstext": {
              "type": "string",
              "description": "The full transcribed text for this speech segment."
            },
            "segmentssegmentssegmentsspeaker": {
              "type": "string",
              "description": "Identifier or name of the speaker for this segment (e.g., 'Speaker 1', 'John Doe')."
            },
            "segmentssegmentssegmentsconfidence": {
              "type": "number",
              "description": "Overall confidence score for the accuracy of this segment's transcription (0.0 to 1.0)."
            },
            "segmentssegmentssegmentssegment_id": {
              "type": "string",
              "description": "A unique identifier for this specific speech segment within the transcript."
            },
            "segmentssegmentssegmentsend_time_seconds": {
              "type": "number",
              "description": "The end time of the segment in seconds from the beginning of the audio/video."
            },
            "segmentssegmentssegmentsstart_time_seconds": {
              "type": "number",
              "description": "The start time of the segment in seconds from the beginning of the audio/video."
            }
          },
          "required": [
            "segmentssegmentssegmentstext",
            "segmentssegmentssegmentsspeaker",
            "segmentssegmentssegmentsconfidence",
            "segmentssegmentssegmentssegment_id",
            "segmentssegmentssegmentsend_time_seconds",
            "segmentssegmentssegmentsstart_time_seconds"
          ]
        }
      },
      "source_url": {
        "type": "string",
        "description": "Optional URL to the original audio or video source file."
      },
      "transcript_id": {
        "type": "string",
        "description": "A unique identifier for this specific transcript."
      },
      "duration_seconds": {
        "type": "number",
        "description": "The total duration of the transcribed audio/video in seconds."
      }
    },
    "required": [
      "title",
      "segments",
      "source_url",
      "transcript_id",
      "duration_seconds"
    ]
  }
}
EOF