file_to_data_inspect
Step 1 of turning a business file into data: hand in a supplier price list, a customer import or an order file (CSV or other delimited text, XLSX, JSON, NDJSON; at most 3 MiB, 50,000 rows, 200 columns). Returns the recognised columns and types, a PROPOSED mapping to a built-in target schema (supplier_price_list, customer_import, order_lines) or to your own, each line with a confidence and a reason, the issues found so far, and the limits with how much the file used. The proposal is deterministic arithmetic over headers (EN/NL/FR/DE/ES) and column types — no AI — and nothing is carried out until you send it to file_to_data_transform. Free, no account, nothing is stored; formulas and macros are never executed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | XLSX only: the sheet's name exactly as written, or its position starting at 0. Default: the first sheet. | |
| content | No | The file's TEXT, for CSV / delimited text / JSON / NDJSON. Give this OR contentBase64. At most 3 MiB. | |
| fileName | No | The file's name, e.g. "prices.csv". Only its extension is used (.csv .tsv .txt .xlsx .xlsm .json .ndjson); it is never stored or logged. | |
| headerRow | No | The row number of the header row, counted from 1. Default: the first row that holds anything. | |
| targetSchema | No | Your own target schema: { "id"?, "title"?, "fields": [{ "name", "type", "required"?, "description"?, "synonyms"? }] } with type one of string, identifier, integer, decimal, date, boolean, email. | |
| contentBase64 | No | The file's BYTES, base64-encoded — required for .xlsx, fine for any format. Give this OR content. At most 3 MiB of file. | |
| targetSchemaId | No | A built-in target schema: supplier_price_list, customer_import or order_lines. Give this OR targetSchema. |