Forum Discussion

mohit3's avatar
mohit3
New Contributor
3 years ago

Getting issue in creating JSON

Need to convert the below source JSON to target JSON
Source :
“Header”:
{
“Customfield”:
{
“ABPER”:“202303”,
“ABKRS”:“SL”
}
}

Target :
“Header”:
{
“Customfield”:
{
“fieldname” :“ABPER”,
“fieldvalue” : “202303”
},
{
“fieldname” :“ABKRS”,
“fieldvalue” : “SL”
}
}
@dmiller @rsramkoski can you please in converting the json to the above given format.

expression_language
pipeline
transform

1 Reply

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    3 years ago

    Hello @mohit3,

    You can try with the following expression in a Mapper Snap:

    sl.range(0,$Header.Customfield.entries().length).map( (x,ind) => {"fieldname":$Header.Customfield.entries()[ind][0], "fieldvalue":$Header.Customfield.entries()[ind][1]})

    Here is a sample pipeline:
    –sl-comm-json-transform_2023_07_05.slp (3.7 KB)

    Let me know if this helps you.

    Regards,
    Aleksandar.