OutputSpec

Describes the output format when transforming from one file format to another

formatFileFormat (string)required

Supported file formats

Possible values: [CSV, FIXED_WIDTH, XML, JSON, NACHA, ISO20022, SWIFT_MT, DELIMITED, CUSTOM]

Example: DELIMITED

delimiterstring

Field delimiter for delimited output formats

Example: ,

encodingstring

Default value: UTF-8

Example: UTF-8

hasHeaderboolean

Whether to write a header row

Default value: false

fieldMappings object[]

Field-level mapping and transformation rules

Array [

sourceFieldstringrequired

Name of the field in the input spec

Example: account_number

targetFieldstringrequired

Name of the field in the output spec

Example: accountNo

transformationstring

Optional SpEL expression to transform the value

Example: #value.substring(0, 9)

]

OutputSpec

{
  "format": "DELIMITED",
  "delimiter": ",",
  "encoding": "UTF-8",
  "hasHeader": false,
  "fieldMappings": [
    {
      "sourceField": "account_number",
      "targetField": "accountNo",
      "transformation": "#value.substring(0, 9)"
    }
  ]
}