Deserialize a complex JSON response in Dynamics Nav 2016

Abdel1978

Hi every one,
Please I need your help.
When I send REST request from Dynamics Nav 2016 I receive a JSON as response.
My question is how te deserialize this JSON in order to keep only "ClientList" because I need this list to update Customer data in Navision.
Thank you for help

JSNO request is like (See attached file):

{
"ClientList": [{
"CliId": 121093,
"CliDMSId": "631035",
"CliTitle": "",
"CliFamName": "EPIE LAURENT",
"CliFirName": "",
"CliAddr1": "19 all\u00E9e du CLOSE gagneur",
"CliAddr2": "",
"CliPC": "93160",
"CliCity": "NOISY LE GRAND",
"CliHomePhone": "01 81 80 30 00",
"CliCellPhone": "",
"CliWorkPhone": "01 81 80 30 00",
"CliFax": "",
"CliEmail": "julien@3dsoft.fr",
"CliAccountType": "",
"CliState": "",
"CliCountry": "",
"CliTags": "",
"CliDoNotText": 0,
"CliDoNotEmail": 0,
"CliDoNotPhone": 0,
"CliCashPayment": 0,
"CliLocked": 0,
"CliLanguage": "",
"ProviderCliId": "39049",
"CliActive": 1,
"CliVehicleList": [],
"ContactList": []
}, {
"CliId": 112174,
"CliDMSId": "853027",
"CliTitle": "",
"CliFamName": "FEILLANT CHRISTELLE",
"CliFirName": "",
"CliAddr1": "19 all\u00E9e du CLOSE gagneur",
"CliAddr2": "",
"CliPC": "93160",
"CliCity": "NOISY LE GRAND",
"CliHomePhone": "01 81 80 30 00",
"CliCellPhone": "07 71 44 61 59",
"CliWorkPhone": "01 81 80 30 00",
"CliFax": "",
"CliEmail": "",
"CliAccountType": "",
"CliState": "",
"CliCountry": "",
"CliTags": "",
"CliDoNotText": 0,
"CliDoNotEmail": 0,
"CliDoNotPhone": 0,
"CliCashPayment": 0,
"CliLocked": 0,
"CliLanguage": "",
"ProviderCliId": "39048",
"CliActive": 1,
"CliVehicleList": [],
"ContactList": []
}],
"VehicleList": [{
"VehId": 197253,
"CliId": 122021,
"CliDMSId": "616916",
"VehVIN": "WVWZZZ1KZ7B077540",
"VehRegNum": "AK274PN",
"VehMake": "VOLKSWAGEN",
"VehModel": "GOLF",
"VehType": "",
"VehKm": "",
"VehPower": "",
"VehTaxPower": "",
"VehSeats": "",
"VehRegDate": "2010-03-23",
"VehYear": "2010",
"VehColor": "",
"VehPaint": "",
"VehUsedCarNum": "",
"VehEngineNum": "",
"VehFuelLevel": "",
"VehState": "",
"VehActive": 1,
"VehModelCode": "",
"VehStockNum": "",
"VehAdvisor": "",
"VehTags": "",
"ProviderCliId": "",
"ProviderVehId": "",
"LoanerAvailabilityList": []
}],
"RendezVousList": [{
"RdvId": 1892,
"RdvType": 2,

"WorkLineList": [{
"WorkLineNumber": 1030,
"WorkLaborCode": "",
"WorkDescription": "Vitrage",
"WorkComment": "",
"WorkWarranty": 0,
"WorkTechCode": "",

SanderDk

I have multiple time had great succes with downgrade the Json buffer table from NAV 2018 to both NAV 2015 and NAV 2016.
Then you can use the Microsoft default object to import the json file.