Reading json data in Business Central

 Read JsonObject In Buisness Central AL Code

The following code is an example of how to read properties from a JsonObject. It is reading properties of the Json Object .

* Also reading text into json object as a bonus to our readers 👽

Scenario:

We are having simple Json value in a text type variable as an text and then reading out in a json object for having key and value properties so we can show it here how we are finding the key and value pair.


    var
     jsontext : text;
     jsonobj : JsonObject;
      JOrderNoToken: JsonToken;


    begin

        jsontext := '{"name": "test2908"}';

//  reading text value in json object

      jsonobj.readfrom(responseText);

         //  Now finding key and his value from json object created above

     jsonobj.Get('name', JOrderNoToken);

        Message('Name is %1', JOrderNoToken.AsValue().AsCode());

end;



Result will be :

Name is test2908

    

Comments

Post a Comment

Popular posts from this blog

Consume Rest API in Business Central Code with Basic Auth

 Rest API Call With Basic Auth | Woo Commerce Rest API So i was working on some requirement of pushing products directly form Microrosft Business Central  to E-Commerce side i.e WOO-Commerce. so what we need is to consume the woo side API's into our AL code (BC SIDE) that requires the basic auth in case of https authentication. Here is a glimpse of code for understanding or picking some approach for the others seeking something like that in Business Central.   action( UnixTimestamp )             {                 ApplicationArea = All;                  trigger  OnAction ()                  var            ...
Read more

How To do Hashing HMAC RSA 1 algorithm or cryptography in Microsoft Business Central | AL Code

HMAC RSA-1 Hashing In AL code | Cryptography Management in Business Central | O AUTH 1.0 Signature Making in Business Central I came up to an requirement of consuming Rest api with O Auth 1.0 authentication in Business Central AL Code and ended up on a point where i have to do some hashing with some defined algorithm to make signature key for my request...  ðŸ˜’ Don't be upset with my story simple is that just do cryptography just by passing your text and password and algorithm of your choice. Read more for the available functions available as cryptography management Code Unit in BC | AL action( hash )  { ApplicationArea = All;     trigger  OnAction ()       var      CryptographyManagement:  Codeunit  "Cryptography Management";      HashAlgorithmType:  Option  MD5,SHA1,SHA256,SHA384,SHA512;   begin      Message ( 'Decrypt %1' ,...
Read more