Merge 2 Json files

spuri5

I have 2 different JSON files which I want to merge as shown below: I also attached a screenshot of the JSON files.

Could you please help me with the solution

Thank you!

Input 1

{
"Name": "John",
"Birth": "Japan",
"Date": "25",
},
{
"Name": "Sam",
"Birth": "India",
"Date": "29",
}

Input 2:

"contactDetails":{
"Email": "john@yahoo.com",
"Phone": "123-999-1111",
"Home": "Kings"},
"contactDetails":{
"Email": "sam@yahoo.com",
"Phone": "123-999-2222",
"Home": "Queens"}   

Final Output:

"contactDetails":{
"Email": "john@yahoo.com",
"Phone": "123-999-1111",
"Home": "Kings"},
"contactDetails":{
"Email": "sam@yahoo.com",
"Phone": "123-999-2222",
"Home": "Queens"}

Input 1

Input 2

Final Output

IraWatt

Hey @spuri5,

Thanks for adding the primary Key as suggested by @apathetichell. I also added square brackets on both your inputs as it needed to be an array not 2 separate JSON objects for it to be valid JSON:

The output of the workflow is this:

{"Birth":"Japan",
"Date":"25",
"Name":"John",
"Primary Key":"1",
"contactDetails":{"Email":"john@yahoo.com","Home":"Kings","Phone":"123-999-1111"}},
{"Birth":"India",
"Date":"29",
"Name":"Sam",
"Primary Key":"2",
"contactDetails":{"Email":"sam@yahoo.com","Home":"Queens","Phone":"123-999-2222"}}

Very interesting problem, I've not used the JSON tools too much. If you have any queries on the workflow please ask. If the workflow solves the problem please give a green tick  

All the best,

Ira 

JSON.yxmd