MDrivenWiki
Log in

Import xml and JSon with MDriven

From MDrivenWiki

I have discussed the selfVM.JsonToObjects a bit in this article. Now another very similar function is introduced – the selfVM.XmlToObjects.

Suppose you have a use case where you receive xml data – and you want to turn this data objects in your model for further processing.

I will walk through this with a mock sample.

I have this xml:

<?xml version='1.0' standalone='no'?>
 <root>
  <person id='1'>
    <name>Alan</name>
    <url>http://www.google.com</url>
  </person>  <person id='2'>
    <name>Louis</name>
    <url>http://www.yahoo.com</url>
  </person>
 </root> 

I add a Text attribute to a class

Import xml and JSon with MDrive 01.png

Now I expose this attribute in a ViewModel so that I can paste in the sample Xml and get it into play:

Import xml and JSon with MDriven 02.png

Running the model I create an object and  paste in xml in the XmlInput attribute.

Import xml and JSon with MDriven 10.png

Where should the information end up? I add a new class for this:

Import xml and JSon with MDriven 03.png

Notice that I have added an attribute RawJSon : String – this is totally optional – but if the this exact attribute exists on the class used as a target in selfVM.XmlToObjects or selfVM.JsonToObjects

then the handled JSon is assigned here (the imported Xml is first converted to JSon – then JsonToObjects handles the objects ) – and that might be good for developing purposes or whatever.

Now we can add an action to call the selfVM.XmlToObjects :

Import xml and JSon with MDriven 04.png

The expression for the button action is:

vNewImportFile:=selfVM.XmlToObjects(  ImportFile , self.XmlInput)

This means:

  • use this Xml data: self.XmlInput
  • Create an object of class ImportFile as root
  • Assign the resulting object of ImportFile class to the variable vNewImportFile

Running in the prototyper gives us:

Import xml and JSon with MDriven 05.png

The Json looks like this:

{
  "?xml": {
    "@version": "1.0",    "@standalone": "no"
  },
  "root": {
    "person": [
      {
        "@id": "1",
        "name": "Alan",
        "url": "http://www.google.com"
      },
      {
        "@id": "2",
        "name": "Louis",
        "url": "http://www.yahoo.com"
      }
    ]
  }
 }

What we want to pay extra attention to in this JSon are things that can be used as associations and things that can be used as attributes. 

Import xml and JSon with MDriven 06.png

The red “root” looks like single link, the green “person” is a multilink, the blue ones are attributes on the objects that end up in the person association.

This tells me that I can do this:

Import xml and JSon with MDriven 07.png

Note that if the logic finds things in the input that it cannot find in your classes – it just silently continues. And if your classes has more attributes or associations than what you have in the JSon data – that is fine as well. Also note that your classes may have any name – it is the associations and attributes that are matched to understand data.

We can add UI to see the imported things:

Import xml and JSon with MDriven 08.png

Running in the prototyper I can see my xml is imported as objects in my model:

Import xml and JSon with MDriven 09.png

Mission accomplished.