Need help with duplicate JSON data into MySQL using PHP

Cody4

Below is the JSON data in url, but i need only records with DateInvoice till the Year. Within URL there is a lot of duplicate data that also carries same vehicle info. Is there a way I can pull only the DateInvoice one?? I able to pull the records but showing lots of duplicates in mysql cause of one vehicle listed in more than once. Any help is highly appreciated. Here is an example.

"DateInvoiced": "2001-03-10T10:55:46-05:00",
"DateOpened": "2001-03-10T09:40:32-05:00",
"Lines": [
{
"Category": {
"Id": "",
"Name": ""
},
"Description": "INSTALL PASTIME GPS ",
"IsDeclined": false,
"LineType": 25,
"LineTypeName": "LaborLine",
"PartNumber": "",
"TotalSale": 65.00
},
{
"Category": {
"Id": "",
"Name": ""
},
"Description": "DETAILING)",
"IsDeclined": false,
"LineType": 25,
"LineTypeName": "LaborLine",
"PartNumber": "",
"TotalSale": 100.00
},
{
"Category": {
"Id": "",
"Name": ""
},
"Description": "GPS - PASSTIME)",
"IsDeclined": false,
"LineType": 20,
"LineTypeName": "PartLine",
"PartNumber": "GPS",
"TotalSale": 125.00
}
],
"LocationId": "dummy",
"MileageIn": 53033,
"MileageOut": 0,
"Modified": "2001-04-09T10:22:44-05:00",
"RepairOrderNumber": "1000",
"TotalSaleAmount": 290.00,
"Vehicle": {
"Color": "RED",
"CurrentMileage": 53033,
"CustomerId": "2",
"Id": "1190",
"LastVisit": "2017-03-24T10:55:46-05:00",
"License": "",
"LicenseState": "CO",
"Make": "Pontiac",
"Model": "Vibe ",
"UnitNumber": "12222",
"VIN": "1ABCDEFGH456789",
"Year": "2009" // I needing data until here but there is a duplicate data of same car within the file and I can only capture but can't edit as it is in URL
}
},

Duplicate data of same car

},
      {
        "Color": "RED",
        "CurrentMileage": 53033,
        "CustomerId": "2",
        "Id": "1190",
        "LastVisit": "2017-03-24T10:55:46-05:00",
        "License": "",
        "LicenseState": "CO",
        "Make": "Pontiac",
        "Model": "Vibe ",
        "UnitNumber": "12222",
        "VIN": "1ABCDEFGH456789",
        "Year": "2009"
      },

NogDog

It's difficult to come up with a specific answer without really understanding the applicable business rules you want to apply, but in general, you can load the json data into an array via json_decode() (use the optional second argument to make it an array of arrays if you don't want to mess with a mixture of arrays and objects). Then you might iterate through that array for the sub-arrays of interest, and put their data into a new array that just has the records/fields you want. (I.e. you may need to apply a test to each iteration to see if it's a thing you already have, and then decide if you skip it or instead use its data to replace the data you already have.)