Best Of

Sorry but you need double quotes for the new root item

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

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

Is the NAV servicetier the only application that initiates changes in the database?

in the parameter for signed function pDocNo, use the type variant. replied you on DUG as well

The errror is actually telling you that your table extension to G/L Entry exist.
If you have delete the tableextension on purpose the you could run the powershell command:
Sync-NAVApp -ServerInstance $ServerIns -Name ''XXX -Mode Clean
The Mode "Clean" delete table on you extension Name XXX.

If you do not want to delete the table extension you should change the GUID for your extension

It surely is advisable to tackle this sooner or later, but even the current version 13 of Business Central still offers the DataType Automation, as long as you stick to the on-premises release, and in the SaaS world neither (.NET or COM) can be used anyhow.

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

Use Json.net

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.