Create Merge File Job

Merge 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