file_to_data_transform
Read-onlyIdempotent
Step 2: carry out EXACTLY the mapping you send (normally the proposal of file_to_data_inspect, corrected). Returns the rows as JSON, the same as CSV text, an error report per row (JSON and CSV), counts, and fileSha256, mappingSha256 and resultSha256 — the same file and mapping always give the same result, so a lost call is simply repeated and compared. It never corrects silently: leading zeros and long ids stay as written, a number is read only under the mapping's decimal mark, an ambiguous date stays unconverted with an issue, a missing value stays null. Large results are paged (offset / limit / page.nextOffset). Free, no account, nothing is stored; over a limit is a refusal that names the limit, never a partial result.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows in this page. Default 100; an answer never carries more than about 400 kB of rows, so a page may be shorter than asked. | |
| sheet | No | XLSX only: the sheet's name exactly as written, or its position starting at 0. Default: the first sheet. | |
| offset | No | First row of the page, starting at 0. Use page.nextOffset of the previous answer. | |
| content | No | The file's TEXT, for CSV / delimited text / JSON / NDJSON. Give this OR contentBase64. At most 3 MiB. | |
| mapping | Yes | THE EXPLICIT MAPPING to carry out — normally `proposedMapping` from file_to_data_inspect, corrected where needed: { "targetSchemaId" | "targetSchema", "fields": [{ "target", "source", "sourceIndex"?, "decimalMark"?: "." | ",", "dateFormat"?: "YMD" | "DMY" | "MDY" | "excel_serial" }] }. A number is read ONLY under decimalMark, a date ONLY under dateFormat. | |
| 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. |