XML to JSON Transformation

[abubakar]

Hello @Roland , i want to know more about this, i have used the value mapper → serialize xml, but my data is not transformed

[Roland]

Hey, Could this be what you are looking for?

How to map with Serialize: XML

Use Case Basically, Alumio uses the JSON data type in every transformer. While some systems sometimes only accept XML, you can convert the JSON data into XML by using the Value Mapper transformer and the Serialize: XML mapper. [DjV90-mA-ruNhDjYGmxIRO6neMbd62E1GQ] Guide 1. Set attributes to an element Please have a look at the below XML data. <?xml version="1.0"?> <data attr1="value 1" attr2="value 2"> <content>this is content</content> </data> In order to get the above output, please…

[abubakar]

mine does not get transformed to json, this is from the incoming configuration

[Roland]

Oh are you trying to get from XML to JSON?
Then you’d need to deserialize.

How to map with Deserialize

Table Of Contents Use case Guide Video guide Use case Deserialization of data can be defined as the process of transforming a string into a data object of a distinct type. The following data types are supported by the Alumio Deserialize mapper- JSON, XML, cXML, and YAML. For instance, let’s imagine a scenario where XML data is retrieved as a string and you have to convert it into an object. With Alumio, it is possible to use this data as entity data. Guide Here’s an easy guide for you. …

[abubakar]

Okay let try this then

[abubakar]

thank you @Roland , one more thing, i am getting this error message now : xmlns: URI fashionmaster is not absolute

[abubakar]

Here is the xml : https://codebeautify.org/xmltojson/y23e7d624

[Gugi]

Hi @abubakar

Is “fashionmaster” the actual xmlns for the DataTable root element?

An xmlns (XML Namespace) should be identified by URI reference (Namespaces in XML 1.0 (Third Edition)).

I tried to put the XML file in a Postman Mock server and updated the xmlns of the DataTable element to an URI, i.e., https://www.fashionmaster.co.uk and Alumio can decode the XML.

[abubakar]

Thank you, your solution is correct

[Roland]

@abubakar
You can select the answer that turned out to be the solution.
1.

2.

This will also help others in the future.

[abubakar]

thanks for that, i have done that