I have a CSV data looks like this :
ps.csv
id|firstName|lastName|address|extId|extName
001|Kapil|Parames|address01|AA01|AA
002|David|Vuitton|address01|AA02|AA
002|David|Vuitton|address02|BB02|BB
003|Jean|Paul|address01|AA03|AA
And i need an output JSON to look like this :
[
{
"id": "001",
"firstName": "Kapil",
"lastName": "Parames",
"address": [{
"address": "address01"
}],
"ext": [{
"extId": "AA01",
"extName": "AA"
}]
},
{
"id": "002",
"firstName": "David",
"lastName": "Vuitton",
"address": [{
"address": "address01"
},
{
"address": "address02"
}
],
"ext": [{
"extId": "AA02",
"extName": "AA"
},
{
"extId": "BB02",
"extName": "BB"
}
]
},
{
"id": "003",
"firstName": "Jean",
"lastName": "Paul",
"address": [{
"address": "address01"
}],
"ext": [{
"extId": "AA03",
"extName": "AA"
}]
}
]
I can convert it to JSON. But the problem is i would like to add "address" and "extId", "extName" into multi level array if the person already exists in the list.
My Answer:
"id": "001",
"firstName": "Kapil",
"lastName": "Parames",
"address": "address01",
"external": {
"extId": "AA01",
"extName": "AA"
}
},
{
"id": "002",
"firstName": "David",
"lastName": "Vuitton",
"address": "address01",
"external": {
"extId": "AA02",
"extName": "AA"
}
},
{
"id": "002",
"firstName": "David",
"lastName": "Vuitton",
"address": "address02",
"external": {
"extId": "BB02",
"extName": "BB"
}
},
{
"id": "003",
"firstName": "Jean",
"lastName": "Paul",
"address": "address01",
"external": {
"extId": "AA03",
"extName": "AA"
}
}
]
Rate this post
4 of 5 based on 1009 votesComments