How can convert data in JSON into XML in Celigo

To conversion, using this Syntax

<tag> {{record. Fieldname}} </tag>

For Example,

JSON data:

{

“record”: {

“id”: “259246”,

“recordType”: “salesorder”,

“Internal_ID”: “259246”,

“Customer_Name”: “CUST0000004 Amjil Capital”,

“Shipping_Address1”: “11400 Twigg Plave”

}

}

Convert to XML:

<?xml version=”1.0″ encoding=”UTF-8”?>

<Orders apiKey=”b7e02d23fb3d4c13b7ceda9de5c0e59e”>

    <brandIdentifier></brandIdentifier>

    <Order orderID= {{record. Internal_ID}}>

        <Warehouse id=”157″ />

        <CustomerInfo>

            <Company> {{record. Company}} </Company>

            <FirstName> {{record. Customer_Name}} </FirstName>

            <Address1> {{record. Shipping_Address}} </Address1>

       </CustomerInfo>

</Order>

After Conversion, data in XML format:

<?xml version=”1.0″ encoding=”UTF-8”?>

<Orders apiKey=”b7e02d23fb3d4c13b7ceda9de5c0e59e”>

    <brandIdentifier></brandIdentifier>

    <Order orderID=”259246″>

        <Warehouse id=”157″ />

        <CustomerInfo>

            <Company>Amjil Capital</Company>

            <FirstName>CUST0000004 Amjil Capital</FirstName>

 <Address1>11400 Twigg Plave </Address1>

</CustomerInfo>

<Order>

Leave a comment

Your email address will not be published. Required fields are marked *