Data Transformation
Data Transformation
The data transformation endpoint is a collection of data manipulation techniques that can be performed on file manager files. These
transformations can be applied to one or more files, and typically generate new files based on specified input configurations.
Previous
Create Merge File JobMerge data from the first sheet of multiple file manager files, then generate a new file with all source data on a single sheet.
Preferred field (new): `mappings` — a list of objects, each with a `fileManagerFileId` and a `columns` array that defines how its columns map into the merged output positions.
Example (`mappings`):
```
{
"mappings": [
{"fileManagerFileId": "1234567890abcdef12345678", "columns": [0, 1, 2, 3, 4]},
{"fileManagerFileId": "2345678901bcdefa23456789", "columns": [1, 0, 2, 4, 3]}
]
}
```
Deprecated (legacy) field: `fileColumnMappings` — a map from `fileManagerFileId` to its columns array. It is still accepted for backward compatibility but will be removed in a future version.
Example (`fileColumnMappings`):
```
{
"fileColumnMappings": {
"1234567890abcdef12345678": [0, 1, 2, 3, 4],
"2345678901bcdefa23456789": [1, 0, 2, 4, 3]
}
}
```
The first mapping entry (in either format) is the master/template file and its columns array defines the output column positions. Columns are numbered from left to right, with the leftmost in a file being position 0. Each subsequent entry defines, for each output column, which column index to use from that file, allowing flexible mapping and positioning in the merged result.
### Permissions
- `api.file-manager.write`
Next