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

How to disable enable action on page dynamically on user selection in Business central

  Disable / Enable Action  on Page with some Value. I came up to an requirement of enabling and disabling action coming on business central page and that should be on basis of some value i.e. I have list page of variants and i want to disable my action (Xyz) on that page if user has selected some variant named as Abc and if not then it should be enable likewise. Note : I used the property "Enabled" of actions in business central and acquired my need by binding it to some boolean variable that is having value true or false on some condition. And doing that whole story in page trigger  onaftergetcurrrecord() that is the trigger which is fired every time when user does some selection on list.  Here is the code snippet of my page extension. Code example : pageextension   50143  VariantListPageExt  extends  "Item Variants" {      layout     {          // Add ...
Read more

How to get Hours, Minutes or seconds from Time Data Type in Business Central | AL Code | NAV

 Format Time Data Type To Hours, Minutes or Seconds So we have Time suppose System Current Time in Time data type as follows and what we need is to get only hours minute or seconds out of the Time value that is formatting it into some text expression like.                                           22 hours 34 minutes 5 seconds  or whatever you are getting in other planets but i have same solution for you aliens.👽    var                  MySysTime:  Time ; begin MySysTime := Time; Message('Regular Time printing as : %1', MySysTime ); //Formatting into parts separtely                        message('Current hours %...
Read more