cancel
Showing results for 
Search instead for 
Did you mean: 

Getting issue in creating JSON

mohit3
New Contributor

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.

1 REPLY 1

Aleksandar_A
Contributor III

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]})

image

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.