Deserialize of JSON response

Business Central/NAV Developers Forum
1

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@dummy.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”: “”,

2

Hi @Abdel_DAHMANI,

In NAV 2016, you can use codeunit 1237 that converts a Json to XML and stores it in XML Buffer table.

If you want to do it manually, you have to use the “Newtonsoft.Json” DotNet DLL library, that is incluided in NAV in this version (look at the codeunit 1237 to see how to use it).

In NAV 2018, you will find an specific JSON Buffer, and some example on how to use the NewtonSoft.Json DotNet library in this table.