Enhanced JSON Output

    This transform loops over the fields defined as Group Key and serializes JSON output accordingly. Because of this it is extremely important that the input transform data will be sorted by the group key to prevent generation errors.

    General tab allows to specify type of transform operation, output json structure, transform output file. This file will be used to dump all generated json.

    Output File

    OptionDescription

    Filename

    full path to output file

    Append

    If not checked new file will be created every time transform is running. If file with specified name already existed - it will be replaced by a new one. If checked - new json output will be appended at the end of existing file. Or if existing file is not exists - it will be created as in previous case.

    Split JSON after n rows

    If this number N is larger than zero, split the resulting JSON file into multiple parts of N rows.

    Create Parent folder

    Usually file name contains some path folder as a parent folder. If parent folder does not exists and this option is checked - parent folder will be created as a new folder. Otherwise - file not be found and transform will fail.

    Do not open create at start

    If not checked - file (and in some cases parent folder) will be created/opened to write during pipeline initialization. If checked - file and parent folder will be created only after transform will get any first input data.

    Extension

    Output file extension. Default value is ‘js’

    Encoding

    Output file encoding

    Include date in filename?

    If checked - output file name will contains File name value + current date. This may help to generate unique output files.

    Include time in filename

    If checked - output file name will contains file creation time. Same as for ‘Include date in filename’ option

    Show filename(s) button

    Add file to result filenames?

    If checked - created output file path will be accessible form transform result

    This tab is used to map input transform fields key used to properly generate output json values

    Fields Tab

    This tab is used to map input transform fields to output json values

    OptionDescription

    Fieldname

    Input transform field name. Use ‘Get Fields’ button to discover available input fields

    Element name

    Json element name as a key. For example “A”:”B” - A is a element name, B is actual input value mapped for this Element name.

    JSON Fragment

    If the value is set to Y the value contained in the filed is a JSON chunk and will be treated accordingly

    Remove if Blank

    If the value is set to Y and value in incoming field is null the related attribute will be omitted from JSON output

    As an example suppose we have, as input, a flow with the following fields and values

    Option

    Assigned Value

    Operation

    Write To File

    JSON Block Name

    result

    Output Value

    lvl1Detail

    Pritty Print JSON

    Checked

    Filename

    Set to a convenient filename for JSON output

    Tab Group Key - Configuration

    Field Name

    Element Name

    JSON Fragment

    Remove If Blank

    field3

    N

    N

    field3

    N

    N

    Output file result