import_excel_to_import_set
Upload and parse one .xlsx worksheet, create an Import Set, insert its staging rows, and optionally request a Transform Map run (transform start is not verified). Requires WRITE_ENABLED=true.
Instructions
Upload and parse one .xlsx worksheet, create an Import Set, insert its staging rows, and optionally request a Transform Map run (transform start is not verified). Requires WRITE_ENABLED=true. The original workbook is attached to the Import Set for auditability; formulas and sys_* columns are rejected.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_name | Yes | Original .xlsx file name | |
| sheet_name | No | Optional worksheet name (default: first worksheet) | |
| staging_table | Yes | Existing Import Set staging table (must extend sys_import_set_row) to receive parsed rows | |
| column_mapping | No | Optional mapping of Excel header to staging-table column, e.g. { "CVE": "u_cve" } | |
| content_base64 | Yes | Base64-encoded .xlsx content (maximum 10 MiB compressed; ZIP expansion limits apply) | |
| import_set_label | No | Optional Import Set label | |
| transform_map_sys_id | No | Optional Transform Map sys_id; a run is requested after rows are inserted (transform start is not verified) |