Converting XML values to JSON aaray

Ani

5y980Learn iOS Programming

Hi,

I have below xml which has to be converted to JSON array using xslt. Please help me

Input xml

123

MGR

employee,supervisior,manager

123 TEST LANE

BOSTON

USA

07723

USA

789 WORK LANE

California

USA

90210

Expected JSON

{

"employee":[

{

"empid":"123",

"empdesignation":"MGR",

"emprole": [

"employee,supervisior,manager"

"address":{

"addressLine1":"123 TEST LANE",

"addressLine2":"AddressLine2",

"cityName":"BOSTON",

"countryName":"USA",

"postalCode":"07723"

}

"company":[

{

"companylocationid":"2",

"companylocation":"USA",

"address":{

"addressLine1":"789 WORK LANE",

"addressLine2":"AddressLine2",

"cityName":"California",

"countryName":"USA",

"postalCode":"90210"

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sagar Pardeshi5y ago
ref :
https://www.newtonsoft.com/json/help/html/ConvertXmlToJsonForceArray.htm
Jignesh Kumar5y ago
Hi Ani,

Please find below link which will help you to convert XML to Json and Json To XML,

https://www.c-sharpcorner.com/blogs/how-to-convert-json-into-xml-or-xml-into-json
Ani5y ago
Hi Arkadeep

I am getting below response
{
"test": {
"employee": [
{
"empid": [
"123",
"MGR",
"employee,supervisior,manager",
{
"addressLine1": [
"123 TEST LANE",
"",
"BOSTON",
"USA",
"07723"
]
}
]
},
{
"companylocationid": [
"2",
"USA",
{
"addressLine1": [
"789 WORK LANE",
"",
"California",
"USA",
"90210"
]
}
]
}
]
}
}

which is not the expected format and I have changed the code of child elements to greater than or equal to <xsl:when test="count(*[name()=$childName]) >= 1"> but it still didn't work. Please help me
Rijwan Ansari5y ago
Try this way
string xml = @"'1.0' standalone='no'?>

  '1'>
  Alan
  http://www.google.com

  '2'>
  Louis
  http://www.yahoo.com

";

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);

string json = JsonConvert.SerializeXmlNode(doc);
Arkadeep De5y ago
refer to the below URL. This should resolve ur issue.

http://www.bizcoder.com/convert-xml-to-json-using-xslt

XML -
<Customers>
    <Customer Id="99">
        <Name>BobName>
        <Age>39Age>
        <Address>
            <Street>10 Idle LaneStreet>
            <City>YucksvilleCity>
            <PostalCode>xxxyyyPostalCode>
        Address>
    Customer>
    <Customer Id="101">
        <Name>BillName>
        <Age>39Age>
        <Address>
            <Street>10 Idle LaneStreet>
            <City>YucksvilleCity>
            <PostalCode>xxxyyyPostalCode>
        Address>
    Customer>

Customers>
XSLT -
xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text"/>

    <xsl:template match="/">{
        <xsl:apply-templates select="*"/>}
    xsl:template>


    <xsl:template match="*">
        "<xsl:value-of select="name()"/>" : <xsl:call-template name="Properties"/>
    xsl:template>


    <xsl:template match="*" mode="ArrayElement">
        <xsl:call-template name="Properties"/>
    xsl:template>


    <xsl:template name="Properties">
        <xsl:variable name="childName" select="name(*[1])"/>
        <xsl:choose>
            <xsl:when test="not(*|@*)">"<xsl:value-of select="."/>"xsl:when>
            <xsl:when test="count(*[name()=$childName]) > 1">{ "<xsl:value-of select="$childName"/>" :[<xsl:apply-templates select="*" mode="ArrayElement"/>] }xsl:when>
            <xsl:otherwise>{
                <xsl:apply-templates select="@*"/>
                <xsl:apply-templates select="*"/>
    }xsl:otherwise>
        xsl:choose>
        <xsl:if test="following-sibling::*">,xsl:if>
    xsl:template>


    <xsl:template match="@*">"<xsl:value-of select="name()"/>" : "<xsl:value-of select="."/>",
    xsl:template>
xsl:stylesheet>
JSON -
{
    "Customers" : {
        "Customer" : [
            {
                "Id" : "99",
                "Name" : "Bob",
                "Age" : "39",
                "Address" : {
                    "Street" : "10 Idle Lane",
                    "City" : "Yucksville",
                    "PostalCode" : "xxxyyy"
                }
            },
            {
                "Id" : "101",
                "Name" : "Bill",
                "Age" : "39",
                "Address" : {
                    "Street" : "10 Idle Lane",
                    "City" : "Yucksville",
                    "PostalCode" : "xxxyyy"
                }
            }
        ]
    }
}