Sign in
upload

Analyze spreadsheet columns with AI

Detects whether a file is ERP or BOM and suggests column mappings based on headers and sample rows.

post/upload/analyze

Request body

force_file_typestring

ForceFileType optionally overrides AI auto-detection ("erp" or "bom"). When set, the file is classified as that type and only that type's column mappings are populated. Empty means auto-detect.

headersstring[]

Response

OK

confidencenumber

Confidence is a value between 0 and 1 indicating how confident the AI is.

file_typestring

FileType is "erp", "bom", or "unknown".

reasoningstring

Reasoning explains why the AI chose this classification.

suggested_levelsinteger[]

SuggestedLevels contains the computed hierarchy levels for sample rows when hierarchy_type is "teamcenter_traversal". Index aligns with sample_rows.

Changes