How to capture values in a JSON String.

shanabeywicrema

Hello there,

Is there any way that I can copy JSON value and insert into dynamics nav table,
Here is the sample JSON response. I am doing this in Dynamics NAV 2013. Initially I copied values using SELECTSTR but is there any proper way to do this.
{
"result": {
"addresses": [
{
"city": "8888",
"address1": "*******",
"postalCode": "***",
"type": "BT",
"companyName1": "Z*****.",
"recordId": "BT",
"state": "NV",
"locationNumber": "**T",
"dunsNumber": "*T"
},
{
"country": "US",
"address2": "********",
"city": "New York",
"address1": "***************,
"postalCode": "**",
"type": "RE",
"companyName1": "***",
"recordId": "RE",
"state": "NY",
"locationNumber": "6*0",
"dunsNumber": "6*"
},

],


Thanks

Juhl

Use Json.net

ftornero

In Dynamics NAV 2013 there is not functions to deal with JSON but you can get the ones in NAV 2016 and adapt it to NAV 2013.

You need to get the add-in Newtonsoft.Json from the NAV 2016 version too and copy in the add-in folder of the NAV 2013 version.

These are the objects.

Type   	   ID	       Name	
Table	    1235	XML Structure	       
Codeunit	 1235	XML Buffer Writer	
Codeunit	 1237	Get Json Structure

And here there is a link to a zip file with the objects in NAV 2013, a report using the JSON data you posted, a file with the jason data and the add-in in the Json folder.

https://www.dropbox.com/s/9tehsgomd5ms7o8/json_datos_2013.zip?dl=1

Regards.

ftornero

Hello @shanabeywicrema ,

Did you copy the Json fiolder in the zip file inside the Add-ins folder of the service ?

Usually this:

 C:\Program Files\Microsoft Dynamics NAV\70\Service\Add-ins

Regards

ftornero

Hello @shanabeywicrema ,

The problem is that your Json data don't have a root item



Maybe the best way is to wrap the Request.responseText with a root Item, something like this:

GenerateStructureFromText('{data:{' + Request.responseText +'}',TempXMLBuf,True);

Regards

ftornero

Sorry but you need double quotes for the new root item

GenerateStructureFromText('{"data":{' + Request.responseText +'}',TempXMLBuf,True);

Juhl

Use Json.net

ftornero

In Dynamics NAV 2013 there is not functions to deal with JSON but you can get the ones in NAV 2016 and adapt it to NAV 2013.

You need to get the add-in Newtonsoft.Json from the NAV 2016 version too and copy in the add-in folder of the NAV 2013 version.

These are the objects.

Type   	   ID	       Name	
Table	    1235	XML Structure	       
Codeunit	 1235	XML Buffer Writer	
Codeunit	 1237	Get Json Structure

And here there is a link to a zip file with the objects in NAV 2013, a report using the JSON data you posted, a file with the jason data and the add-in in the Json folder.

https://www.dropbox.com/s/9tehsgomd5ms7o8/json_datos_2013.zip?dl=1

Regards.

shanabeywicrema

Hello ftornero ,
Thank you so much for you effort. It is really worth. After all I got following error. Do you know where I missed. ?

Microsoft Dynamics NAV

---

This message is for C/AL programmers: Cannot create an instance of the following .NET Framework object: assembly Newtonsoft.Json, Version=7.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, type Newtonsoft.Json.JsonConvert.

---

OK

---

ftornero

Hello @shanabeywicrema ,

Did you copy the Json fiolder in the zip file inside the Add-ins folder of the service ?

Usually this:

 C:\Program Files\Microsoft Dynamics NAV\70\Service\Add-ins

Regards

shanabeywicrema

I just copied into program 86. Not it is working, Thank you so much my problem has solved.

shanabeywicrema

Hi, Is there any way that we can pass text or bigtext instead of file ?

ftornero

Yes @shanabeywicrema you need to modify the codeunit 1237 to deal with Text, something like this:



You should duplicate the previous functions, change the names and parameters and then call the function GenerateStructureFromText with the Text var where is the JSON data.

Regards.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

shanabeywicrema

Hello @ftornero
I have done as your code. But When I pass the request, I am getting this error. Could you please guide me where I wrong .

Microsoft Dynamics NAV

---

A call to Newtonsoft.Json.JsonConvert.DeserializeXmlNode failed with this message: JSON root object has multiple properties. The root object must have a single property in order to create a valid XML document. Consider specifing a DeserializeRootElementName. Path 'message', line 1, position 15538.

---

OK

---

ftornero

Hello @shanabeywicrema,

Looks like the problem is with the Json text.

Could you post how are you filling the text variable with the json data and the real json data ?

Regards.

shanabeywicrema

Hello @ftornero ,
I just call the rest web-service and call the relevant function,then I will get the response, Same response I will pass into GenerateStructureFromText

Request := RequestClass.XMLHTTPRequestClass;
Request.open('GET',MySetup."APIEndpoint"+'documents/order/'+ID,FALSE,'','');
Request.setRequestHeader('Content-Type',ContentType);
Request.setRequestHeader('sessionId',UserSessionID);
Request.send('');
IF Request.status = 200 THEN BEGIN
GenerateStructureFromText(Request.responseText,TempXMLBuf,True);
END;

I use message to check the response text. I am getting the data.

ftornero

Hello @shanabeywicrema ,

The problem is that your Json data don't have a root item



Maybe the best way is to wrap the Request.responseText with a root Item, something like this:

GenerateStructureFromText('{data:{' + Request.responseText +'}',TempXMLBuf,True);

Regards

ftornero

Sorry but you need double quotes for the new root item

GenerateStructureFromText('{"data":{' + Request.responseText +'}',TempXMLBuf,True);

ftornero

Sorry again @shanabeywicrema,

The right call is this one:

GenerateStructureFromText('{"data":' + Request.responseText +'}',TempXMLBuf,True);

You need to remove the second curly brace.

Regards.

rsruchineeraj

Hi @ftornero,
It's really working for me. Thanks a lot!