Hello my friends.
How do I convert a json with this structure:
[
{
"sale_id": 868401,
"date_payment": "2016-11-28 17:30:12",
"sale_total": 699,
"product_id": 100483,
"product_name": "iPhone 13",
"client_id": 100584,
"client_name": "Brian Park",
"client_email": "[email protected]"
},
{
"sale_id": 606932,
"date_payment": "2017-02-01 19:30:18",
"product_id": 550309,
"product_name": "MacBook Air M1",
"sale_total": 999,
"client_id": 100584,
"client_name": "Brian Park",
"client_email": "[email protected]"
},
{
"sale_id": 909330,
"date_payment": "2018-02-01 19:30:18",
"product_id": 304592,
"product_name": "iPad Air",
"sale_total": 599,
"client_id": 100584,
"client_name": "Brian Park",
"client_email": "[email protected]"
},
{
"sale_id": 909330,
"date_payment": "2018-02-01 19:30:18",
"sale_total": 699,
"product_id": 100483,
"product_name": "iPhone 13",
"client_id": 67593,
"client_name": "Darren Walker",
"client_email": "[email protected]"
}
]
for this structure?
[
{
"client_id":100584,
"client_name":"Brian Park",
"client_email":"[email protected]",
"products":[
{
"product_id":100483,
"product_name":"iPhone 13"
},
{
"product_id":550309,
"product_name":"MacBook Air M1"
},
{
"product_id":304592,
"product_name":"iPad Air"
}
]
},
{
"client_id":67593,
"client_name":"Darren Walker",
"client_email":"[email protected]",
"products":[
{
"product_id":100483,
"product_name":"iPhone 13"
}
]
}
]
I need to unify in a list all the products purchased by the customer.
Can someone help me?
thanks a lot