Options

Deserialize a complex JSON response in Dynamics Nav 2016

Abdel1978Abdel1978 Member Posts: 10
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": "",

JSON.pdf 126.4K

Answers

  • Options
    SanderDkSanderDk Member Posts: 500
    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.

    1tjxmku3pp7k.png
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
Sign In or Register to comment.