Data Transformation - MindBridge Documentation

Documentation Index

Fetch the complete documentation index at: /llms.txt

Use this file to discover all available pages before exploring further.

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.

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