curl --request PUT \
  --url https://api.csvbox.io/1.1/sheet/{sheet_license_key} \
  --header 'Accept: <accept>' \
  --header 'Content-Type: <content-type>' \
  --header 'x-csvbox-api-key: <api-key>' \
  --header 'x-csvbox-secret-api-key: <api-key>' \
  --data @- <<EOF
{
  "title": "Updated Sheet",
  "webhooks": [
    {
      "import_complete": {
        "url": "https://example.com/webhook",
        "send_copy": false,
        "custom_headers": [
          {
            "key": "Content-Type",
            "value": "application/json"
          }
        ]
      }
    }
  ],
  "destinations": [
    {
      "type": "webhook",
      "isActive": true,
      "settings": {
        "method": "POST",
        "url": "https://example.com/api/import",
        "post_data_format": "JSON",
        "rows_per_chunk": 100,
        "request_type": "parallel",
        "server_side_validation": true,
        "allow_resubmit": "all_rows",
        "custom_headers": [
          {
            "key": "Content-Type",
            "value": "application/json"
          }
        ]
      }
    }
  ],
  "sheet_columns": [
    {
      "column_name": "col1",
      "display_label": "Col1 - Text",
      "info_hint": "What is your highest educational degree",
      "matching_keywords": "degree, education",
      "type": "text",
      "validators": {
        "min_length": 2,
        "max_length": 50
      },
      "default_value": "",
      "required": false,
      "position": 5
    },
    {
      "column_name": "col2",
      "display_label": "col2 - Number",
      "info_hint": "Years of work experience",
      "type": "number",
      "validators": {
        "min_value": 1,
        "max_value": 100
      },
      "required": false,
      "position": 6
    },
    {
      "column_name": "col4",
      "display_label": "col4 - Email",
      "type": "email",
      "required": false,
      "position": 7
    },
    {
      "column_name": "col5",
      "display_label": "col5 - Date",
      "type": "date",
      "validators": {
        "format": "YYYY-MM-DD"
      },
      "required": false,
      "position": 8
    }
  ],
  "steps": {
    "file_upload": {
      "types": [
        ".csv"
      ],
      "title": "File Upload",
      "help": "Upload your CSV file",
      "sample_file_url": "",
      "size_mb": 200,
      "validation_msg": "upto 200mb allowed",
      "copy_paste": true,
      "copy_delimiter": "comma",
      "show_upload": true,
      "worksheet_select": true,
      "description_option": true,
      "lang": "en",
      "excel_date_format": "custom",
      "excel_date_custom": "DD-MM-YYYY",
      "hide_cancel": false,
      "split": true,
      "split_rows": 1000,
      "split_confirm": "no",
      "extract_types": [
        "pdf",
        "images"
      ],
      "page_limit": 10,
      "accept_raw_value": false,
      "skip_min_rows": 2,
      "skip_max_rows": 1000,
      "skip_min_cols": 2,
      "skip_max_cols": 20
    },
    "select_header": {
      "skip": true,
      "help": "Select header row",
      "default_row": "2",
      "encoding_option": true,
      "encoding": "windows-1252",
      "row_column_switch": false
    },
    "map_columns": {
      "skip": true,
      "help": "Map columns",
      "mapping_mode": "template_fields",
      "bulk_cols_dd": false,
      "accept_unmapped": true,
      "accept_unmapped_select": true,
      "allow_zero_template": true,
      "ignore_cols": true,
      "ignore_cols_default": true,
      "user_keywords": false
    },
    "verify_data": {
      "skip": true,
      "help": "Verify data",
      "row_display_mode": "invalid",
      "export_option": true,
      "search_option": false,
      "ai_transform": true,
      "allow_new_rows": false,
      "rows_display": 25,
      "allow_invalid": true,
      "invalid_confirmation": false,
      "max_rows": 600,
      "allow_upload_if_max": false,
      "max_rows_msg": "maaaaaax",
      "min_rows": 2,
      "min_rows_msg": "miiiiin"
    },
    "results": {
      "close_mode": "close_on_success",
      "redirect_url": "",
      "success_type": "static",
      "success_text": "Import successful",
      "success_method": "get",
      "success_url": "",
      "success_headers": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "failed_type": "static",
      "failed_text": "Failure",
      "failed_method": "get",
      "failed_url": "",
      "failed_headers": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "show_resubmit": false,
      "show_error_text": false
    }
  },
  "security_settings": {
    "region": "us",
    "domains": [
      "example.com"
    ],
    "import_url_upload": true,
    "s3_upload": true
  },
  "virtual_columns": [
    {
      "column_name": "full_name",
      "js_code": "const a = csvbox.row['col1'] || ''; const b = csvbox.row['col2'] || ''; return (a + ' ' + b).trim();",
      "active": true,
      "dependencies": [],
      "_delete": false
    }
  ],
  "validation_functions": [
    {
      "function_name": "check_email",
      "scope": "column",
      "columns": [
        "col4"
      ],
      "js_code": "const rows = csvbox.column['col4'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf('@') === -1) { errs.push({ row_id: i + 1, column: 'col4', message: 'Not a valid email' }); } } return errs;",
      "active": true
    },
    {
      "function_name": "check_date",
      "scope": "column",
      "columns": [
        "col5"
      ],
      "js_code": "const rows = csvbox.column['col5'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || '').trim(); if (raw === '') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format('YYYY-MM-DD') !== raw) { errs.push({ row_id: i + 1, column: 'col5', message: 'Use YYYY-MM-DD, e.g. 2024-01-31' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date cannot be in the future' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date must be 1900 or later' }); } } return errs;",
      "dependencies": [
        {
          "url": "https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js",
          "globals": [
            "dayjs"
          ]
        }
      ],
      "active": true
    }
  ],
  "data_transforms": [
    {
      "transform_name": "uppercase_country",
      "scope": "column",
      "run_at": "before_validation",
      "columns": [
        "col1"
      ],
      "dynamic_columns": [
        "region"
      ],
      "js_code": "for (let i = 0; i < csvbox.column['col1'].length; i++) { csvbox.column['col1'][i] = String(csvbox.column['col1'][i]).toUpperCase(); } return csvbox;",
      "active": true,
      "dependencies": [],
      "_delete": false
    }
  ],
  "pdf_metadata_config": [
    {
      "name": "Author",
      "source": "native"
    },
    {
      "name": "Invoice Number",
      "source": "document-kv"
    },
    {
      "name": "processed_by",
      "source": "static",
      "value": "AP Team"
    },
    {
      "name": "invoice_date",
      "source": "line-match",
      "value": "Invoice Date:"
    }
  ]
}
EOF

import requests

url = "https://api.csvbox.io/1.1/sheet/{sheet_license_key}"

payload = {
    "title": "Updated Sheet",
    "webhooks": [{ "import_complete": {
                "url": "https://example.com/webhook",
                "send_copy": False,
                "custom_headers": [
                    {
                        "key": "Content-Type",
                        "value": "application/json"
                    }
                ]
            } }],
    "destinations": [
        {
            "type": "webhook",
            "isActive": True,
            "settings": {
                "method": "POST",
                "url": "https://example.com/api/import",
                "post_data_format": "JSON",
                "rows_per_chunk": 100,
                "request_type": "parallel",
                "server_side_validation": True,
                "allow_resubmit": "all_rows",
                "custom_headers": [
                    {
                        "key": "Content-Type",
                        "value": "application/json"
                    }
                ]
            }
        }
    ],
    "sheet_columns": [
        {
            "column_name": "col1",
            "display_label": "Col1 - Text",
            "info_hint": "What is your highest educational degree",
            "matching_keywords": "degree, education",
            "type": "text",
            "validators": {
                "min_length": 2,
                "max_length": 50
            },
            "default_value": "",
            "required": False,
            "position": 5
        },
        {
            "column_name": "col2",
            "display_label": "col2 - Number",
            "info_hint": "Years of work experience",
            "type": "number",
            "validators": {
                "min_value": 1,
                "max_value": 100
            },
            "required": False,
            "position": 6
        },
        {
            "column_name": "col4",
            "display_label": "col4 - Email",
            "type": "email",
            "required": False,
            "position": 7
        },
        {
            "column_name": "col5",
            "display_label": "col5 - Date",
            "type": "date",
            "validators": { "format": "YYYY-MM-DD" },
            "required": False,
            "position": 8
        }
    ],
    "steps": {
        "file_upload": {
            "types": [".csv"],
            "title": "File Upload",
            "help": "Upload your CSV file",
            "sample_file_url": "",
            "size_mb": 200,
            "validation_msg": "upto 200mb allowed",
            "copy_paste": True,
            "copy_delimiter": "comma",
            "show_upload": True,
            "worksheet_select": True,
            "description_option": True,
            "lang": "en",
            "excel_date_format": "custom",
            "excel_date_custom": "DD-MM-YYYY",
            "hide_cancel": False,
            "split": True,
            "split_rows": 1000,
            "split_confirm": "no",
            "extract_types": ["pdf", "images"],
            "page_limit": 10,
            "accept_raw_value": False,
            "skip_min_rows": 2,
            "skip_max_rows": 1000,
            "skip_min_cols": 2,
            "skip_max_cols": 20
        },
        "select_header": {
            "skip": True,
            "help": "Select header row",
            "default_row": "2",
            "encoding_option": True,
            "encoding": "windows-1252",
            "row_column_switch": False
        },
        "map_columns": {
            "skip": True,
            "help": "Map columns",
            "mapping_mode": "template_fields",
            "bulk_cols_dd": False,
            "accept_unmapped": True,
            "accept_unmapped_select": True,
            "allow_zero_template": True,
            "ignore_cols": True,
            "ignore_cols_default": True,
            "user_keywords": False
        },
        "verify_data": {
            "skip": True,
            "help": "Verify data",
            "row_display_mode": "invalid",
            "export_option": True,
            "search_option": False,
            "ai_transform": True,
            "allow_new_rows": False,
            "rows_display": 25,
            "allow_invalid": True,
            "invalid_confirmation": False,
            "max_rows": 600,
            "allow_upload_if_max": False,
            "max_rows_msg": "maaaaaax",
            "min_rows": 2,
            "min_rows_msg": "miiiiin"
        },
        "results": {
            "close_mode": "close_on_success",
            "redirect_url": "",
            "success_type": "static",
            "success_text": "Import successful",
            "success_method": "get",
            "success_url": "",
            "success_headers": [
                {
                    "key": "Content-Type",
                    "value": "application/json"
                }
            ],
            "failed_type": "static",
            "failed_text": "Failure",
            "failed_method": "get",
            "failed_url": "",
            "failed_headers": [
                {
                    "key": "Content-Type",
                    "value": "application/json"
                }
            ],
            "show_resubmit": False,
            "show_error_text": False
        }
    },
    "security_settings": {
        "region": "us",
        "domains": ["example.com"],
        "import_url_upload": True,
        "s3_upload": True
    },
    "virtual_columns": [
        {
            "column_name": "full_name",
            "js_code": "const a = csvbox.row['col1'] || ''; const b = csvbox.row['col2'] || ''; return (a + ' ' + b).trim();",
            "active": True,
            "dependencies": [],
            "_delete": False
        }
    ],
    "validation_functions": [
        {
            "function_name": "check_email",
            "scope": "column",
            "columns": ["col4"],
            "js_code": "const rows = csvbox.column['col4'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf('@') === -1) { errs.push({ row_id: i + 1, column: 'col4', message: 'Not a valid email' }); } } return errs;",
            "active": True
        },
        {
            "function_name": "check_date",
            "scope": "column",
            "columns": ["col5"],
            "js_code": "const rows = csvbox.column['col5'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || '').trim(); if (raw === '') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format('YYYY-MM-DD') !== raw) { errs.push({ row_id: i + 1, column: 'col5', message: 'Use YYYY-MM-DD, e.g. 2024-01-31' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date cannot be in the future' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date must be 1900 or later' }); } } return errs;",
            "dependencies": [
                {
                    "url": "https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js",
                    "globals": ["dayjs"]
                }
            ],
            "active": True
        }
    ],
    "data_transforms": [
        {
            "transform_name": "uppercase_country",
            "scope": "column",
            "run_at": "before_validation",
            "columns": ["col1"],
            "dynamic_columns": ["region"],
            "js_code": "for (let i = 0; i < csvbox.column['col1'].length; i++) { csvbox.column['col1'][i] = String(csvbox.column['col1'][i]).toUpperCase(); } return csvbox;",
            "active": True,
            "dependencies": [],
            "_delete": False
        }
    ],
    "pdf_metadata_config": [
        {
            "name": "Author",
            "source": "native"
        },
        {
            "name": "Invoice Number",
            "source": "document-kv"
        },
        {
            "name": "processed_by",
            "source": "static",
            "value": "AP Team"
        },
        {
            "name": "invoice_date",
            "source": "line-match",
            "value": "Invoice Date:"
        }
    ]
}
headers = {
    "Accept": "<accept>",
    "Content-Type": "<content-type>",
    "x-csvbox-api-key": "<api-key>",
    "x-csvbox-secret-api-key": "<api-key>"
}

response = requests.put(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'PUT',
  headers: {
    Accept: '<accept>',
    'Content-Type': '<content-type>',
    'x-csvbox-api-key': '<api-key>',
    'x-csvbox-secret-api-key': '<api-key>'
  },
  body: JSON.stringify({
    title: 'Updated Sheet',
    webhooks: [
      {
        import_complete: {
          url: 'https://example.com/webhook',
          send_copy: false,
          custom_headers: [{key: 'Content-Type', value: 'application/json'}]
        }
      }
    ],
    destinations: [
      {
        type: 'webhook',
        isActive: true,
        settings: {
          method: 'POST',
          url: 'https://example.com/api/import',
          post_data_format: 'JSON',
          rows_per_chunk: 100,
          request_type: 'parallel',
          server_side_validation: true,
          allow_resubmit: 'all_rows',
          custom_headers: [{key: 'Content-Type', value: 'application/json'}]
        }
      }
    ],
    sheet_columns: [
      {
        column_name: 'col1',
        display_label: 'Col1 - Text',
        info_hint: 'What is your highest educational degree',
        matching_keywords: 'degree, education',
        type: 'text',
        validators: {min_length: 2, max_length: 50},
        default_value: '',
        required: false,
        position: 5
      },
      {
        column_name: 'col2',
        display_label: 'col2 - Number',
        info_hint: 'Years of work experience',
        type: 'number',
        validators: {min_value: 1, max_value: 100},
        required: false,
        position: 6
      },
      {
        column_name: 'col4',
        display_label: 'col4 - Email',
        type: 'email',
        required: false,
        position: 7
      },
      {
        column_name: 'col5',
        display_label: 'col5 - Date',
        type: 'date',
        validators: {format: 'YYYY-MM-DD'},
        required: false,
        position: 8
      }
    ],
    steps: {
      file_upload: {
        types: ['.csv'],
        title: 'File Upload',
        help: 'Upload your CSV file',
        sample_file_url: '',
        size_mb: 200,
        validation_msg: 'upto 200mb allowed',
        copy_paste: true,
        copy_delimiter: 'comma',
        show_upload: true,
        worksheet_select: true,
        description_option: true,
        lang: 'en',
        excel_date_format: 'custom',
        excel_date_custom: 'DD-MM-YYYY',
        hide_cancel: false,
        split: true,
        split_rows: 1000,
        split_confirm: 'no',
        extract_types: ['pdf', 'images'],
        page_limit: 10,
        accept_raw_value: false,
        skip_min_rows: 2,
        skip_max_rows: 1000,
        skip_min_cols: 2,
        skip_max_cols: 20
      },
      select_header: {
        skip: true,
        help: 'Select header row',
        default_row: '2',
        encoding_option: true,
        encoding: 'windows-1252',
        row_column_switch: false
      },
      map_columns: {
        skip: true,
        help: 'Map columns',
        mapping_mode: 'template_fields',
        bulk_cols_dd: false,
        accept_unmapped: true,
        accept_unmapped_select: true,
        allow_zero_template: true,
        ignore_cols: true,
        ignore_cols_default: true,
        user_keywords: false
      },
      verify_data: {
        skip: true,
        help: 'Verify data',
        row_display_mode: 'invalid',
        export_option: true,
        search_option: false,
        ai_transform: true,
        allow_new_rows: false,
        rows_display: 25,
        allow_invalid: true,
        invalid_confirmation: false,
        max_rows: 600,
        allow_upload_if_max: false,
        max_rows_msg: 'maaaaaax',
        min_rows: 2,
        min_rows_msg: 'miiiiin'
      },
      results: {
        close_mode: 'close_on_success',
        redirect_url: '',
        success_type: 'static',
        success_text: 'Import successful',
        success_method: 'get',
        success_url: '',
        success_headers: [{key: 'Content-Type', value: 'application/json'}],
        failed_type: 'static',
        failed_text: 'Failure',
        failed_method: 'get',
        failed_url: '',
        failed_headers: [{key: 'Content-Type', value: 'application/json'}],
        show_resubmit: false,
        show_error_text: false
      }
    },
    security_settings: {
      region: 'us',
      domains: ['example.com'],
      import_url_upload: true,
      s3_upload: true
    },
    virtual_columns: [
      {
        column_name: 'full_name',
        js_code: 'const a = csvbox.row[\'col1\'] || \'\'; const b = csvbox.row[\'col2\'] || \'\'; return (a + \' \' + b).trim();',
        active: true,
        dependencies: [],
        _delete: false
      }
    ],
    validation_functions: [
      {
        function_name: 'check_email',
        scope: 'column',
        columns: ['col4'],
        js_code: 'const rows = csvbox.column[\'col4\'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf(\'@\') === -1) { errs.push({ row_id: i + 1, column: \'col4\', message: \'Not a valid email\' }); } } return errs;',
        active: true
      },
      {
        function_name: 'check_date',
        scope: 'column',
        columns: ['col5'],
        js_code: 'const rows = csvbox.column[\'col5\'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || \'\').trim(); if (raw === \'\') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format(\'YYYY-MM-DD\') !== raw) { errs.push({ row_id: i + 1, column: \'col5\', message: \'Use YYYY-MM-DD, e.g. 2024-01-31\' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: \'col5\', message: \'Date cannot be in the future\' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: \'col5\', message: \'Date must be 1900 or later\' }); } } return errs;',
        dependencies: [
          {
            url: 'https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js',
            globals: ['dayjs']
          }
        ],
        active: true
      }
    ],
    data_transforms: [
      {
        transform_name: 'uppercase_country',
        scope: 'column',
        run_at: 'before_validation',
        columns: ['col1'],
        dynamic_columns: ['region'],
        js_code: 'for (let i = 0; i < csvbox.column[\'col1\'].length; i++) { csvbox.column[\'col1\'][i] = String(csvbox.column[\'col1\'][i]).toUpperCase(); } return csvbox;',
        active: true,
        dependencies: [],
        _delete: false
      }
    ],
    pdf_metadata_config: [
      {name: 'Author', source: 'native'},
      {name: 'Invoice Number', source: 'document-kv'},
      {name: 'processed_by', source: 'static', value: 'AP Team'},
      {name: 'invoice_date', source: 'line-match', value: 'Invoice Date:'}
    ]
  })
};

fetch('https://api.csvbox.io/1.1/sheet/{sheet_license_key}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.csvbox.io/1.1/sheet/{sheet_license_key}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => json_encode([
    'title' => 'Updated Sheet',
    'webhooks' => [
        [
                'import_complete' => [
                                'url' => 'https://example.com/webhook',
                                'send_copy' => false,
                                'custom_headers' => [
                                                                [
                                                                                                                                'key' => 'Content-Type',
                                                                                                                                'value' => 'application/json'
                                                                ]
                                ]
                ]
        ]
    ],
    'destinations' => [
        [
                'type' => 'webhook',
                'isActive' => true,
                'settings' => [
                                'method' => 'POST',
                                'url' => 'https://example.com/api/import',
                                'post_data_format' => 'JSON',
                                'rows_per_chunk' => 100,
                                'request_type' => 'parallel',
                                'server_side_validation' => true,
                                'allow_resubmit' => 'all_rows',
                                'custom_headers' => [
                                                                [
                                                                                                                                'key' => 'Content-Type',
                                                                                                                                'value' => 'application/json'
                                                                ]
                                ]
                ]
        ]
    ],
    'sheet_columns' => [
        [
                'column_name' => 'col1',
                'display_label' => 'Col1 - Text',
                'info_hint' => 'What is your highest educational degree',
                'matching_keywords' => 'degree, education',
                'type' => 'text',
                'validators' => [
                                'min_length' => 2,
                                'max_length' => 50
                ],
                'default_value' => '',
                'required' => false,
                'position' => 5
        ],
        [
                'column_name' => 'col2',
                'display_label' => 'col2 - Number',
                'info_hint' => 'Years of work experience',
                'type' => 'number',
                'validators' => [
                                'min_value' => 1,
                                'max_value' => 100
                ],
                'required' => false,
                'position' => 6
        ],
        [
                'column_name' => 'col4',
                'display_label' => 'col4 - Email',
                'type' => 'email',
                'required' => false,
                'position' => 7
        ],
        [
                'column_name' => 'col5',
                'display_label' => 'col5 - Date',
                'type' => 'date',
                'validators' => [
                                'format' => 'YYYY-MM-DD'
                ],
                'required' => false,
                'position' => 8
        ]
    ],
    'steps' => [
        'file_upload' => [
                'types' => [
                                '.csv'
                ],
                'title' => 'File Upload',
                'help' => 'Upload your CSV file',
                'sample_file_url' => '',
                'size_mb' => 200,
                'validation_msg' => 'upto 200mb allowed',
                'copy_paste' => true,
                'copy_delimiter' => 'comma',
                'show_upload' => true,
                'worksheet_select' => true,
                'description_option' => true,
                'lang' => 'en',
                'excel_date_format' => 'custom',
                'excel_date_custom' => 'DD-MM-YYYY',
                'hide_cancel' => false,
                'split' => true,
                'split_rows' => 1000,
                'split_confirm' => 'no',
                'extract_types' => [
                                'pdf',
                                'images'
                ],
                'page_limit' => 10,
                'accept_raw_value' => false,
                'skip_min_rows' => 2,
                'skip_max_rows' => 1000,
                'skip_min_cols' => 2,
                'skip_max_cols' => 20
        ],
        'select_header' => [
                'skip' => true,
                'help' => 'Select header row',
                'default_row' => '2',
                'encoding_option' => true,
                'encoding' => 'windows-1252',
                'row_column_switch' => false
        ],
        'map_columns' => [
                'skip' => true,
                'help' => 'Map columns',
                'mapping_mode' => 'template_fields',
                'bulk_cols_dd' => false,
                'accept_unmapped' => true,
                'accept_unmapped_select' => true,
                'allow_zero_template' => true,
                'ignore_cols' => true,
                'ignore_cols_default' => true,
                'user_keywords' => false
        ],
        'verify_data' => [
                'skip' => true,
                'help' => 'Verify data',
                'row_display_mode' => 'invalid',
                'export_option' => true,
                'search_option' => false,
                'ai_transform' => true,
                'allow_new_rows' => false,
                'rows_display' => 25,
                'allow_invalid' => true,
                'invalid_confirmation' => false,
                'max_rows' => 600,
                'allow_upload_if_max' => false,
                'max_rows_msg' => 'maaaaaax',
                'min_rows' => 2,
                'min_rows_msg' => 'miiiiin'
        ],
        'results' => [
                'close_mode' => 'close_on_success',
                'redirect_url' => '',
                'success_type' => 'static',
                'success_text' => 'Import successful',
                'success_method' => 'get',
                'success_url' => '',
                'success_headers' => [
                                [
                                                                'key' => 'Content-Type',
                                                                'value' => 'application/json'
                                ]
                ],
                'failed_type' => 'static',
                'failed_text' => 'Failure',
                'failed_method' => 'get',
                'failed_url' => '',
                'failed_headers' => [
                                [
                                                                'key' => 'Content-Type',
                                                                'value' => 'application/json'
                                ]
                ],
                'show_resubmit' => false,
                'show_error_text' => false
        ]
    ],
    'security_settings' => [
        'region' => 'us',
        'domains' => [
                'example.com'
        ],
        'import_url_upload' => true,
        's3_upload' => true
    ],
    'virtual_columns' => [
        [
                'column_name' => 'full_name',
                'js_code' => 'const a = csvbox.row[\'col1\'] || \'\'; const b = csvbox.row[\'col2\'] || \'\'; return (a + \' \' + b).trim();',
                'active' => true,
                'dependencies' => [
                                
                ],
                '_delete' => false
        ]
    ],
    'validation_functions' => [
        [
                'function_name' => 'check_email',
                'scope' => 'column',
                'columns' => [
                                'col4'
                ],
                'js_code' => 'const rows = csvbox.column[\'col4\'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf(\'@\') === -1) { errs.push({ row_id: i + 1, column: \'col4\', message: \'Not a valid email\' }); } } return errs;',
                'active' => true
        ],
        [
                'function_name' => 'check_date',
                'scope' => 'column',
                'columns' => [
                                'col5'
                ],
                'js_code' => 'const rows = csvbox.column[\'col5\'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || \'\').trim(); if (raw === \'\') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format(\'YYYY-MM-DD\') !== raw) { errs.push({ row_id: i + 1, column: \'col5\', message: \'Use YYYY-MM-DD, e.g. 2024-01-31\' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: \'col5\', message: \'Date cannot be in the future\' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: \'col5\', message: \'Date must be 1900 or later\' }); } } return errs;',
                'dependencies' => [
                                [
                                                                'url' => 'https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js',
                                                                'globals' => [
                                                                                                                                'dayjs'
                                                                ]
                                ]
                ],
                'active' => true
        ]
    ],
    'data_transforms' => [
        [
                'transform_name' => 'uppercase_country',
                'scope' => 'column',
                'run_at' => 'before_validation',
                'columns' => [
                                'col1'
                ],
                'dynamic_columns' => [
                                'region'
                ],
                'js_code' => 'for (let i = 0; i < csvbox.column[\'col1\'].length; i++) { csvbox.column[\'col1\'][i] = String(csvbox.column[\'col1\'][i]).toUpperCase(); } return csvbox;',
                'active' => true,
                'dependencies' => [
                                
                ],
                '_delete' => false
        ]
    ],
    'pdf_metadata_config' => [
        [
                'name' => 'Author',
                'source' => 'native'
        ],
        [
                'name' => 'Invoice Number',
                'source' => 'document-kv'
        ],
        [
                'name' => 'processed_by',
                'source' => 'static',
                'value' => 'AP Team'
        ],
        [
                'name' => 'invoice_date',
                'source' => 'line-match',
                'value' => 'Invoice Date:'
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Accept: <accept>",
    "Content-Type: <content-type>",
    "x-csvbox-api-key: <api-key>",
    "x-csvbox-secret-api-key: <api-key>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.csvbox.io/1.1/sheet/{sheet_license_key}"

	payload := strings.NewReader("{\n  \"title\": \"Updated Sheet\",\n  \"webhooks\": [\n    {\n      \"import_complete\": {\n        \"url\": \"https://example.com/webhook\",\n        \"send_copy\": false,\n        \"custom_headers\": [\n          {\n            \"key\": \"Content-Type\",\n            \"value\": \"application/json\"\n          }\n        ]\n      }\n    }\n  ],\n  \"destinations\": [\n    {\n      \"type\": \"webhook\",\n      \"isActive\": true,\n      \"settings\": {\n        \"method\": \"POST\",\n        \"url\": \"https://example.com/api/import\",\n        \"post_data_format\": \"JSON\",\n        \"rows_per_chunk\": 100,\n        \"request_type\": \"parallel\",\n        \"server_side_validation\": true,\n        \"allow_resubmit\": \"all_rows\",\n        \"custom_headers\": [\n          {\n            \"key\": \"Content-Type\",\n            \"value\": \"application/json\"\n          }\n        ]\n      }\n    }\n  ],\n  \"sheet_columns\": [\n    {\n      \"column_name\": \"col1\",\n      \"display_label\": \"Col1 - Text\",\n      \"info_hint\": \"What is your highest educational degree\",\n      \"matching_keywords\": \"degree, education\",\n      \"type\": \"text\",\n      \"validators\": {\n        \"min_length\": 2,\n        \"max_length\": 50\n      },\n      \"default_value\": \"\",\n      \"required\": false,\n      \"position\": 5\n    },\n    {\n      \"column_name\": \"col2\",\n      \"display_label\": \"col2 - Number\",\n      \"info_hint\": \"Years of work experience\",\n      \"type\": \"number\",\n      \"validators\": {\n        \"min_value\": 1,\n        \"max_value\": 100\n      },\n      \"required\": false,\n      \"position\": 6\n    },\n    {\n      \"column_name\": \"col4\",\n      \"display_label\": \"col4 - Email\",\n      \"type\": \"email\",\n      \"required\": false,\n      \"position\": 7\n    },\n    {\n      \"column_name\": \"col5\",\n      \"display_label\": \"col5 - Date\",\n      \"type\": \"date\",\n      \"validators\": {\n        \"format\": \"YYYY-MM-DD\"\n      },\n      \"required\": false,\n      \"position\": 8\n    }\n  ],\n  \"steps\": {\n    \"file_upload\": {\n      \"types\": [\n        \".csv\"\n      ],\n      \"title\": \"File Upload\",\n      \"help\": \"Upload your CSV file\",\n      \"sample_file_url\": \"\",\n      \"size_mb\": 200,\n      \"validation_msg\": \"upto 200mb allowed\",\n      \"copy_paste\": true,\n      \"copy_delimiter\": \"comma\",\n      \"show_upload\": true,\n      \"worksheet_select\": true,\n      \"description_option\": true,\n      \"lang\": \"en\",\n      \"excel_date_format\": \"custom\",\n      \"excel_date_custom\": \"DD-MM-YYYY\",\n      \"hide_cancel\": false,\n      \"split\": true,\n      \"split_rows\": 1000,\n      \"split_confirm\": \"no\",\n      \"extract_types\": [\n        \"pdf\",\n        \"images\"\n      ],\n      \"page_limit\": 10,\n      \"accept_raw_value\": false,\n      \"skip_min_rows\": 2,\n      \"skip_max_rows\": 1000,\n      \"skip_min_cols\": 2,\n      \"skip_max_cols\": 20\n    },\n    \"select_header\": {\n      \"skip\": true,\n      \"help\": \"Select header row\",\n      \"default_row\": \"2\",\n      \"encoding_option\": true,\n      \"encoding\": \"windows-1252\",\n      \"row_column_switch\": false\n    },\n    \"map_columns\": {\n      \"skip\": true,\n      \"help\": \"Map columns\",\n      \"mapping_mode\": \"template_fields\",\n      \"bulk_cols_dd\": false,\n      \"accept_unmapped\": true,\n      \"accept_unmapped_select\": true,\n      \"allow_zero_template\": true,\n      \"ignore_cols\": true,\n      \"ignore_cols_default\": true,\n      \"user_keywords\": false\n    },\n    \"verify_data\": {\n      \"skip\": true,\n      \"help\": \"Verify data\",\n      \"row_display_mode\": \"invalid\",\n      \"export_option\": true,\n      \"search_option\": false,\n      \"ai_transform\": true,\n      \"allow_new_rows\": false,\n      \"rows_display\": 25,\n      \"allow_invalid\": true,\n      \"invalid_confirmation\": false,\n      \"max_rows\": 600,\n      \"allow_upload_if_max\": false,\n      \"max_rows_msg\": \"maaaaaax\",\n      \"min_rows\": 2,\n      \"min_rows_msg\": \"miiiiin\"\n    },\n    \"results\": {\n      \"close_mode\": \"close_on_success\",\n      \"redirect_url\": \"\",\n      \"success_type\": \"static\",\n      \"success_text\": \"Import successful\",\n      \"success_method\": \"get\",\n      \"success_url\": \"\",\n      \"success_headers\": [\n        {\n          \"key\": \"Content-Type\",\n          \"value\": \"application/json\"\n        }\n      ],\n      \"failed_type\": \"static\",\n      \"failed_text\": \"Failure\",\n      \"failed_method\": \"get\",\n      \"failed_url\": \"\",\n      \"failed_headers\": [\n        {\n          \"key\": \"Content-Type\",\n          \"value\": \"application/json\"\n        }\n      ],\n      \"show_resubmit\": false,\n      \"show_error_text\": false\n    }\n  },\n  \"security_settings\": {\n    \"region\": \"us\",\n    \"domains\": [\n      \"example.com\"\n    ],\n    \"import_url_upload\": true,\n    \"s3_upload\": true\n  },\n  \"virtual_columns\": [\n    {\n      \"column_name\": \"full_name\",\n      \"js_code\": \"const a = csvbox.row['col1'] || ''; const b = csvbox.row['col2'] || ''; return (a + ' ' + b).trim();\",\n      \"active\": true,\n      \"dependencies\": [],\n      \"_delete\": false\n    }\n  ],\n  \"validation_functions\": [\n    {\n      \"function_name\": \"check_email\",\n      \"scope\": \"column\",\n      \"columns\": [\n        \"col4\"\n      ],\n      \"js_code\": \"const rows = csvbox.column['col4'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf('@') === -1) { errs.push({ row_id: i + 1, column: 'col4', message: 'Not a valid email' }); } } return errs;\",\n      \"active\": true\n    },\n    {\n      \"function_name\": \"check_date\",\n      \"scope\": \"column\",\n      \"columns\": [\n        \"col5\"\n      ],\n      \"js_code\": \"const rows = csvbox.column['col5'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || '').trim(); if (raw === '') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format('YYYY-MM-DD') !== raw) { errs.push({ row_id: i + 1, column: 'col5', message: 'Use YYYY-MM-DD, e.g. 2024-01-31' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date cannot be in the future' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date must be 1900 or later' }); } } return errs;\",\n      \"dependencies\": [\n        {\n          \"url\": \"https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js\",\n          \"globals\": [\n            \"dayjs\"\n          ]\n        }\n      ],\n      \"active\": true\n    }\n  ],\n  \"data_transforms\": [\n    {\n      \"transform_name\": \"uppercase_country\",\n      \"scope\": \"column\",\n      \"run_at\": \"before_validation\",\n      \"columns\": [\n        \"col1\"\n      ],\n      \"dynamic_columns\": [\n        \"region\"\n      ],\n      \"js_code\": \"for (let i = 0; i < csvbox.column['col1'].length; i++) { csvbox.column['col1'][i] = String(csvbox.column['col1'][i]).toUpperCase(); } return csvbox;\",\n      \"active\": true,\n      \"dependencies\": [],\n      \"_delete\": false\n    }\n  ],\n  \"pdf_metadata_config\": [\n    {\n      \"name\": \"Author\",\n      \"source\": \"native\"\n    },\n    {\n      \"name\": \"Invoice Number\",\n      \"source\": \"document-kv\"\n    },\n    {\n      \"name\": \"processed_by\",\n      \"source\": \"static\",\n      \"value\": \"AP Team\"\n    },\n    {\n      \"name\": \"invoice_date\",\n      \"source\": \"line-match\",\n      \"value\": \"Invoice Date:\"\n    }\n  ]\n}")

	req, _ := http.NewRequest("PUT", url, payload)

	req.Header.Add("Accept", "<accept>")
	req.Header.Add("Content-Type", "<content-type>")
	req.Header.Add("x-csvbox-api-key", "<api-key>")
	req.Header.Add("x-csvbox-secret-api-key", "<api-key>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.put("https://api.csvbox.io/1.1/sheet/{sheet_license_key}")
  .header("Accept", "<accept>")
  .header("Content-Type", "<content-type>")
  .header("x-csvbox-api-key", "<api-key>")
  .header("x-csvbox-secret-api-key", "<api-key>")
  .body("{\n  \"title\": \"Updated Sheet\",\n  \"webhooks\": [\n    {\n      \"import_complete\": {\n        \"url\": \"https://example.com/webhook\",\n        \"send_copy\": false,\n        \"custom_headers\": [\n          {\n            \"key\": \"Content-Type\",\n            \"value\": \"application/json\"\n          }\n        ]\n      }\n    }\n  ],\n  \"destinations\": [\n    {\n      \"type\": \"webhook\",\n      \"isActive\": true,\n      \"settings\": {\n        \"method\": \"POST\",\n        \"url\": \"https://example.com/api/import\",\n        \"post_data_format\": \"JSON\",\n        \"rows_per_chunk\": 100,\n        \"request_type\": \"parallel\",\n        \"server_side_validation\": true,\n        \"allow_resubmit\": \"all_rows\",\n        \"custom_headers\": [\n          {\n            \"key\": \"Content-Type\",\n            \"value\": \"application/json\"\n          }\n        ]\n      }\n    }\n  ],\n  \"sheet_columns\": [\n    {\n      \"column_name\": \"col1\",\n      \"display_label\": \"Col1 - Text\",\n      \"info_hint\": \"What is your highest educational degree\",\n      \"matching_keywords\": \"degree, education\",\n      \"type\": \"text\",\n      \"validators\": {\n        \"min_length\": 2,\n        \"max_length\": 50\n      },\n      \"default_value\": \"\",\n      \"required\": false,\n      \"position\": 5\n    },\n    {\n      \"column_name\": \"col2\",\n      \"display_label\": \"col2 - Number\",\n      \"info_hint\": \"Years of work experience\",\n      \"type\": \"number\",\n      \"validators\": {\n        \"min_value\": 1,\n        \"max_value\": 100\n      },\n      \"required\": false,\n      \"position\": 6\n    },\n    {\n      \"column_name\": \"col4\",\n      \"display_label\": \"col4 - Email\",\n      \"type\": \"email\",\n      \"required\": false,\n      \"position\": 7\n    },\n    {\n      \"column_name\": \"col5\",\n      \"display_label\": \"col5 - Date\",\n      \"type\": \"date\",\n      \"validators\": {\n        \"format\": \"YYYY-MM-DD\"\n      },\n      \"required\": false,\n      \"position\": 8\n    }\n  ],\n  \"steps\": {\n    \"file_upload\": {\n      \"types\": [\n        \".csv\"\n      ],\n      \"title\": \"File Upload\",\n      \"help\": \"Upload your CSV file\",\n      \"sample_file_url\": \"\",\n      \"size_mb\": 200,\n      \"validation_msg\": \"upto 200mb allowed\",\n      \"copy_paste\": true,\n      \"copy_delimiter\": \"comma\",\n      \"show_upload\": true,\n      \"worksheet_select\": true,\n      \"description_option\": true,\n      \"lang\": \"en\",\n      \"excel_date_format\": \"custom\",\n      \"excel_date_custom\": \"DD-MM-YYYY\",\n      \"hide_cancel\": false,\n      \"split\": true,\n      \"split_rows\": 1000,\n      \"split_confirm\": \"no\",\n      \"extract_types\": [\n        \"pdf\",\n        \"images\"\n      ],\n      \"page_limit\": 10,\n      \"accept_raw_value\": false,\n      \"skip_min_rows\": 2,\n      \"skip_max_rows\": 1000,\n      \"skip_min_cols\": 2,\n      \"skip_max_cols\": 20\n    },\n    \"select_header\": {\n      \"skip\": true,\n      \"help\": \"Select header row\",\n      \"default_row\": \"2\",\n      \"encoding_option\": true,\n      \"encoding\": \"windows-1252\",\n      \"row_column_switch\": false\n    },\n    \"map_columns\": {\n      \"skip\": true,\n      \"help\": \"Map columns\",\n      \"mapping_mode\": \"template_fields\",\n      \"bulk_cols_dd\": false,\n      \"accept_unmapped\": true,\n      \"accept_unmapped_select\": true,\n      \"allow_zero_template\": true,\n      \"ignore_cols\": true,\n      \"ignore_cols_default\": true,\n      \"user_keywords\": false\n    },\n    \"verify_data\": {\n      \"skip\": true,\n      \"help\": \"Verify data\",\n      \"row_display_mode\": \"invalid\",\n      \"export_option\": true,\n      \"search_option\": false,\n      \"ai_transform\": true,\n      \"allow_new_rows\": false,\n      \"rows_display\": 25,\n      \"allow_invalid\": true,\n      \"invalid_confirmation\": false,\n      \"max_rows\": 600,\n      \"allow_upload_if_max\": false,\n      \"max_rows_msg\": \"maaaaaax\",\n      \"min_rows\": 2,\n      \"min_rows_msg\": \"miiiiin\"\n    },\n    \"results\": {\n      \"close_mode\": \"close_on_success\",\n      \"redirect_url\": \"\",\n      \"success_type\": \"static\",\n      \"success_text\": \"Import successful\",\n      \"success_method\": \"get\",\n      \"success_url\": \"\",\n      \"success_headers\": [\n        {\n          \"key\": \"Content-Type\",\n          \"value\": \"application/json\"\n        }\n      ],\n      \"failed_type\": \"static\",\n      \"failed_text\": \"Failure\",\n      \"failed_method\": \"get\",\n      \"failed_url\": \"\",\n      \"failed_headers\": [\n        {\n          \"key\": \"Content-Type\",\n          \"value\": \"application/json\"\n        }\n      ],\n      \"show_resubmit\": false,\n      \"show_error_text\": false\n    }\n  },\n  \"security_settings\": {\n    \"region\": \"us\",\n    \"domains\": [\n      \"example.com\"\n    ],\n    \"import_url_upload\": true,\n    \"s3_upload\": true\n  },\n  \"virtual_columns\": [\n    {\n      \"column_name\": \"full_name\",\n      \"js_code\": \"const a = csvbox.row['col1'] || ''; const b = csvbox.row['col2'] || ''; return (a + ' ' + b).trim();\",\n      \"active\": true,\n      \"dependencies\": [],\n      \"_delete\": false\n    }\n  ],\n  \"validation_functions\": [\n    {\n      \"function_name\": \"check_email\",\n      \"scope\": \"column\",\n      \"columns\": [\n        \"col4\"\n      ],\n      \"js_code\": \"const rows = csvbox.column['col4'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf('@') === -1) { errs.push({ row_id: i + 1, column: 'col4', message: 'Not a valid email' }); } } return errs;\",\n      \"active\": true\n    },\n    {\n      \"function_name\": \"check_date\",\n      \"scope\": \"column\",\n      \"columns\": [\n        \"col5\"\n      ],\n      \"js_code\": \"const rows = csvbox.column['col5'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || '').trim(); if (raw === '') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format('YYYY-MM-DD') !== raw) { errs.push({ row_id: i + 1, column: 'col5', message: 'Use YYYY-MM-DD, e.g. 2024-01-31' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date cannot be in the future' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date must be 1900 or later' }); } } return errs;\",\n      \"dependencies\": [\n        {\n          \"url\": \"https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js\",\n          \"globals\": [\n            \"dayjs\"\n          ]\n        }\n      ],\n      \"active\": true\n    }\n  ],\n  \"data_transforms\": [\n    {\n      \"transform_name\": \"uppercase_country\",\n      \"scope\": \"column\",\n      \"run_at\": \"before_validation\",\n      \"columns\": [\n        \"col1\"\n      ],\n      \"dynamic_columns\": [\n        \"region\"\n      ],\n      \"js_code\": \"for (let i = 0; i < csvbox.column['col1'].length; i++) { csvbox.column['col1'][i] = String(csvbox.column['col1'][i]).toUpperCase(); } return csvbox;\",\n      \"active\": true,\n      \"dependencies\": [],\n      \"_delete\": false\n    }\n  ],\n  \"pdf_metadata_config\": [\n    {\n      \"name\": \"Author\",\n      \"source\": \"native\"\n    },\n    {\n      \"name\": \"Invoice Number\",\n      \"source\": \"document-kv\"\n    },\n    {\n      \"name\": \"processed_by\",\n      \"source\": \"static\",\n      \"value\": \"AP Team\"\n    },\n    {\n      \"name\": \"invoice_date\",\n      \"source\": \"line-match\",\n      \"value\": \"Invoice Date:\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.csvbox.io/1.1/sheet/{sheet_license_key}")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Put.new(url)
request["Accept"] = '<accept>'
request["Content-Type"] = '<content-type>'
request["x-csvbox-api-key"] = '<api-key>'
request["x-csvbox-secret-api-key"] = '<api-key>'
request.body = "{\n  \"title\": \"Updated Sheet\",\n  \"webhooks\": [\n    {\n      \"import_complete\": {\n        \"url\": \"https://example.com/webhook\",\n        \"send_copy\": false,\n        \"custom_headers\": [\n          {\n            \"key\": \"Content-Type\",\n            \"value\": \"application/json\"\n          }\n        ]\n      }\n    }\n  ],\n  \"destinations\": [\n    {\n      \"type\": \"webhook\",\n      \"isActive\": true,\n      \"settings\": {\n        \"method\": \"POST\",\n        \"url\": \"https://example.com/api/import\",\n        \"post_data_format\": \"JSON\",\n        \"rows_per_chunk\": 100,\n        \"request_type\": \"parallel\",\n        \"server_side_validation\": true,\n        \"allow_resubmit\": \"all_rows\",\n        \"custom_headers\": [\n          {\n            \"key\": \"Content-Type\",\n            \"value\": \"application/json\"\n          }\n        ]\n      }\n    }\n  ],\n  \"sheet_columns\": [\n    {\n      \"column_name\": \"col1\",\n      \"display_label\": \"Col1 - Text\",\n      \"info_hint\": \"What is your highest educational degree\",\n      \"matching_keywords\": \"degree, education\",\n      \"type\": \"text\",\n      \"validators\": {\n        \"min_length\": 2,\n        \"max_length\": 50\n      },\n      \"default_value\": \"\",\n      \"required\": false,\n      \"position\": 5\n    },\n    {\n      \"column_name\": \"col2\",\n      \"display_label\": \"col2 - Number\",\n      \"info_hint\": \"Years of work experience\",\n      \"type\": \"number\",\n      \"validators\": {\n        \"min_value\": 1,\n        \"max_value\": 100\n      },\n      \"required\": false,\n      \"position\": 6\n    },\n    {\n      \"column_name\": \"col4\",\n      \"display_label\": \"col4 - Email\",\n      \"type\": \"email\",\n      \"required\": false,\n      \"position\": 7\n    },\n    {\n      \"column_name\": \"col5\",\n      \"display_label\": \"col5 - Date\",\n      \"type\": \"date\",\n      \"validators\": {\n        \"format\": \"YYYY-MM-DD\"\n      },\n      \"required\": false,\n      \"position\": 8\n    }\n  ],\n  \"steps\": {\n    \"file_upload\": {\n      \"types\": [\n        \".csv\"\n      ],\n      \"title\": \"File Upload\",\n      \"help\": \"Upload your CSV file\",\n      \"sample_file_url\": \"\",\n      \"size_mb\": 200,\n      \"validation_msg\": \"upto 200mb allowed\",\n      \"copy_paste\": true,\n      \"copy_delimiter\": \"comma\",\n      \"show_upload\": true,\n      \"worksheet_select\": true,\n      \"description_option\": true,\n      \"lang\": \"en\",\n      \"excel_date_format\": \"custom\",\n      \"excel_date_custom\": \"DD-MM-YYYY\",\n      \"hide_cancel\": false,\n      \"split\": true,\n      \"split_rows\": 1000,\n      \"split_confirm\": \"no\",\n      \"extract_types\": [\n        \"pdf\",\n        \"images\"\n      ],\n      \"page_limit\": 10,\n      \"accept_raw_value\": false,\n      \"skip_min_rows\": 2,\n      \"skip_max_rows\": 1000,\n      \"skip_min_cols\": 2,\n      \"skip_max_cols\": 20\n    },\n    \"select_header\": {\n      \"skip\": true,\n      \"help\": \"Select header row\",\n      \"default_row\": \"2\",\n      \"encoding_option\": true,\n      \"encoding\": \"windows-1252\",\n      \"row_column_switch\": false\n    },\n    \"map_columns\": {\n      \"skip\": true,\n      \"help\": \"Map columns\",\n      \"mapping_mode\": \"template_fields\",\n      \"bulk_cols_dd\": false,\n      \"accept_unmapped\": true,\n      \"accept_unmapped_select\": true,\n      \"allow_zero_template\": true,\n      \"ignore_cols\": true,\n      \"ignore_cols_default\": true,\n      \"user_keywords\": false\n    },\n    \"verify_data\": {\n      \"skip\": true,\n      \"help\": \"Verify data\",\n      \"row_display_mode\": \"invalid\",\n      \"export_option\": true,\n      \"search_option\": false,\n      \"ai_transform\": true,\n      \"allow_new_rows\": false,\n      \"rows_display\": 25,\n      \"allow_invalid\": true,\n      \"invalid_confirmation\": false,\n      \"max_rows\": 600,\n      \"allow_upload_if_max\": false,\n      \"max_rows_msg\": \"maaaaaax\",\n      \"min_rows\": 2,\n      \"min_rows_msg\": \"miiiiin\"\n    },\n    \"results\": {\n      \"close_mode\": \"close_on_success\",\n      \"redirect_url\": \"\",\n      \"success_type\": \"static\",\n      \"success_text\": \"Import successful\",\n      \"success_method\": \"get\",\n      \"success_url\": \"\",\n      \"success_headers\": [\n        {\n          \"key\": \"Content-Type\",\n          \"value\": \"application/json\"\n        }\n      ],\n      \"failed_type\": \"static\",\n      \"failed_text\": \"Failure\",\n      \"failed_method\": \"get\",\n      \"failed_url\": \"\",\n      \"failed_headers\": [\n        {\n          \"key\": \"Content-Type\",\n          \"value\": \"application/json\"\n        }\n      ],\n      \"show_resubmit\": false,\n      \"show_error_text\": false\n    }\n  },\n  \"security_settings\": {\n    \"region\": \"us\",\n    \"domains\": [\n      \"example.com\"\n    ],\n    \"import_url_upload\": true,\n    \"s3_upload\": true\n  },\n  \"virtual_columns\": [\n    {\n      \"column_name\": \"full_name\",\n      \"js_code\": \"const a = csvbox.row['col1'] || ''; const b = csvbox.row['col2'] || ''; return (a + ' ' + b).trim();\",\n      \"active\": true,\n      \"dependencies\": [],\n      \"_delete\": false\n    }\n  ],\n  \"validation_functions\": [\n    {\n      \"function_name\": \"check_email\",\n      \"scope\": \"column\",\n      \"columns\": [\n        \"col4\"\n      ],\n      \"js_code\": \"const rows = csvbox.column['col4'] || []; const errs = []; for (let i = 0; i < rows.length; i++) { if (String(rows[i]).indexOf('@') === -1) { errs.push({ row_id: i + 1, column: 'col4', message: 'Not a valid email' }); } } return errs;\",\n      \"active\": true\n    },\n    {\n      \"function_name\": \"check_date\",\n      \"scope\": \"column\",\n      \"columns\": [\n        \"col5\"\n      ],\n      \"js_code\": \"const rows = csvbox.column['col5'] || []; const errs = []; const today = dayjs(); for (let i = 0; i < rows.length; i++) { const raw = String(rows[i] || '').trim(); if (raw === '') { continue; } const d = dayjs(raw); if (!d.isValid() || d.format('YYYY-MM-DD') !== raw) { errs.push({ row_id: i + 1, column: 'col5', message: 'Use YYYY-MM-DD, e.g. 2024-01-31' }); } else if (d.isAfter(today)) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date cannot be in the future' }); } else if (d.year() < 1900) { errs.push({ row_id: i + 1, column: 'col5', message: 'Date must be 1900 or later' }); } } return errs;\",\n      \"dependencies\": [\n        {\n          \"url\": \"https://cdn.jsdelivr.net/npm/dayjs@1.11.10/dayjs.min.js\",\n          \"globals\": [\n            \"dayjs\"\n          ]\n        }\n      ],\n      \"active\": true\n    }\n  ],\n  \"data_transforms\": [\n    {\n      \"transform_name\": \"uppercase_country\",\n      \"scope\": \"column\",\n      \"run_at\": \"before_validation\",\n      \"columns\": [\n        \"col1\"\n      ],\n      \"dynamic_columns\": [\n        \"region\"\n      ],\n      \"js_code\": \"for (let i = 0; i < csvbox.column['col1'].length; i++) { csvbox.column['col1'][i] = String(csvbox.column['col1'][i]).toUpperCase(); } return csvbox;\",\n      \"active\": true,\n      \"dependencies\": [],\n      \"_delete\": false\n    }\n  ],\n  \"pdf_metadata_config\": [\n    {\n      \"name\": \"Author\",\n      \"source\": \"native\"\n    },\n    {\n      \"name\": \"Invoice Number\",\n      \"source\": \"document-kv\"\n    },\n    {\n      \"name\": \"processed_by\",\n      \"source\": \"static\",\n      \"value\": \"AP Team\"\n    },\n    {\n      \"name\": \"invoice_date\",\n      \"source\": \"line-match\",\n      \"value\": \"Invoice Date:\"\n    }\n  ]\n}"

response = http.request(request)
puts response.read_body

{
  "status": "Sheet Created Successfully",
  "data": {
    "sheet_license_key": "<string>",
    "title": "<string>",
    "virtual_columns": [
      {
        "column_name": "full_name",
        "result": "created"
      }
    ],
    "validation_functions": [
      {
        "function_name": "check_email",
        "result": "updated"
      }
    ],
    "data_transforms": [
      {
        "transform_name": "uppercase_country",
        "result": "unchanged"
      }
    ]
  }
}

{
  "status": "Sheet Creation Failed",
  "errors": {
    "virtual_columns.0.js_code": [
      {
        "code": "js_disallowed_global",
        "message": "Disallowed global `fetch`. Snippets may only reference the `csvbox` argument, standard built-ins, and globals declared in this item's dependencies.",
        "identifier": "fetch",
        "line": 1,
        "column": 7
      }
    ]
  }
}

{
  "status": "Sheet Creation Failed",
  "errors": {
    "virtual_columns.0.js_code": [
      {
        "code": "js_disallowed_global",
        "message": "Disallowed global `fetch`. Snippets may only reference the `csvbox` argument, standard built-ins, and globals declared in this item's dependencies.",
        "identifier": "fetch",
        "line": 1,
        "column": 7
      }
    ]
  }
}

{
  "status": "Sheet Creation Failed",
  "errors": {
    "virtual_columns.0.js_code": [
      {
        "code": "js_disallowed_global",
        "message": "Disallowed global `fetch`. Snippets may only reference the `csvbox` argument, standard built-ins, and globals declared in this item's dependencies.",
        "identifier": "fetch",
        "line": 1,
        "column": 7
      }
    ]
  }
}

{
  "status": "Sheet Creation Failed",
  "errors": {
    "virtual_columns.0.js_code": [
      {
        "code": "js_disallowed_global",
        "message": "Disallowed global `fetch`. Snippets may only reference the `csvbox` argument, standard built-ins, and globals declared in this item's dependencies.",
        "identifier": "fetch",
        "line": 1,
        "column": 7
      }
    ]
  }
}

{
  "status": "Sheet Creation Failed",
  "errors": {
    "virtual_columns.0.js_code": [
      {
        "code": "js_disallowed_global",
        "message": "Disallowed global `fetch`. Snippets may only reference the `csvbox` argument, standard built-ins, and globals declared in this item's dependencies.",
        "identifier": "fetch",
        "line": 1,
        "column": 7
      }
    ]
  }
}