Creating Nested Json for REST API
Hello All,
In my use case, I have a nested JSON as an input, I want to do some transformation before I create a nested JSON which I am going to post it in a REST API,
InPut JSON:
[
{
“Customer”: {
“Name”: Sam
“City”: “Chicago”,
“Email":""abc@ggg.com”
“accounts”: [
{
“accountId”: 3567361088,
“accountBalance”: 9453.563,
“created”: “2014-09-21”
},
{
“accountId”: 12345,
“accountBalance”: 9444.563,
“created”: “2014-09-21”
}
]
}
}
]
Output JSON:
[
{
“Customer_Entry”: {
“Name”: Sam
“accounts_details”: [
{
“acc_Id”: 3567361088,
“acc_Balance”: 9453.563,
},
{
“acc_Id”: 12345,
“acc_Balance”: 9444.563,
}
]
}
}
]
The challenge is after the transformation, I retain few keys including the nested keys and also renamed them into different values. What’s the best way to design the pipeline for this case.
Thanks in Advance.
Hello and welcome @Senthilnaga91,
You can achieve the needed transformations by using two Mapper Snaps like in the picture below.
In the first Mapper we’re mapping the Account Details array:
And, in the second one we’re mapping the Customer Entry object:
Also you can refer to the sample pipeline attached below.
sl-comm-nested-json-api_2023_05_30.slp (5.5 KB)
Let me know if this helps you.
Regards,
Aleksandar.
