---
schema_version: "1"
id: 253c9fdc024479fc70ada272ae3b98c9f125e91fb93979e0e8a7eac94d030eba
title: Transform XML to JSON
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/dataweave/latest/dataweave-cookbook-perform-basic-transformation.md
canonical_url: https://docs.mulesoft.com/dataweave/latest/dataweave-cookbook-perform-basic-transformation
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 9fbba27969e4ef722f4ed159850a60b026599b70617c7265075a18fdef0261c0
description: MuleSoft Documentation Site
release: "2.13"
latest: true
---
---
product: DataWeave
version: 2.13
is-latest-version: true
keywords: studio, anypoint, transform, transformer, format, xml, json, dataweave, data weave, datamapper, dwl, dfl, dw, output structure, input structure
---

# Transform XML to JSON

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

These simple DataWeave examples change the XML input to JSON output. Note that more complex
transformations usually require the use of the `map` or `mapObject` function.

The following DataWeave script maps the names (or keys) for the output fields to values of the input
fields. The input fields are specified with selector expressions without any functions. The script
also changes the order and names of some of the fields.

DataWeave Script:

```dataweave
%dw 2.0
output application/json
---
{
        address1: payload.order.buyer.address,
        city: payload.order.buyer.city,
        country: payload.order.buyer.nationality,
        email: payload.order.buyer.email,
        name: payload.order.buyer.name,
        postalCode: payload.order.buyer.postCode,
        stateOrProvince: payload.order.buyer.state
}
```

Input XML Payload:

```xml
<?xml version='1.0' encoding='UTF-8'?>
<order>
  <product>
    <price>5</price>
    <model>MuleSoft Connect 2016</model>
  </product>
  <item_amount>3</item_amount>
  <payment>
    <payment-type>credit-card</payment-type>
    <currency>USD</currency>
    <installments>1</installments>
  </payment>
  <buyer>
    <email>mike@hotmail.com</email>
    <name>Michael</name>
    <address>Koala Boulevard 314</address>
    <city>San Diego</city>
    <state>CA</state>
    <postCode>1345</postCode>
    <nationality>USA</nationality>
  </buyer>
  <shop>main branch</shop>
  <salesperson>Mathew Chow</salesperson>
</order>
```

Output JSON:

```json
{
  "address1": "Koala Boulevard 314",
  "city": "San Diego",
  "country": "USA",
  "email": "mike@hotmail.com",
  "name": "Michael",
  "postalCode": "1345",
  "stateOrProvince": "CA"
}
```

In the following example, the DataWeave script transforms the XML containing multiple XML nodes with
the same key into a valid JSON creating an array instead of creating JSON nodes with the same key.

DataWeave Script:

```dataweave
%dw 2.0
output application/json duplicateKeyAsArray=true
---
payload
```

Input XML Payload:

```xml
<order>
  <product-lineitems>
	<product-lineitem>
	   <net-price>100.0</net-price>
	</product-lineitem>
	<product-lineitem>
	     <net-price>498.00</net-price>
	</product-lineitem>
  </product-lineitems>
</order>
```

Output JSON:

```json
{
  "order": {
    "product-lineitems": {
      "product-lineitem": [
        {
          "net-price": "100.0"
        },
        {
          "net-price": "498.00"
        }
      ]
    }
  }
}
```

## Related Examples

- [Extract Data](https://docs.mulesoft.com/dataweave/latest/dataweave-cookbook-extract-data)

- [Map Data with DataWeave](https://docs.mulesoft.com/dataweave/latest/dataweave-cookbook-map)

- [Rename Keys](https://docs.mulesoft.com/dataweave/latest/dataweave-cookbook-rename-keys)

## See Also

- [DataWeave Types](https://docs.mulesoft.com/dataweave/latest/dataweave-types)

- [DataWeave Selectors](https://docs.mulesoft.com/dataweave/latest/dataweave-selectors)

- [DataWeave Cookbook](https://docs.mulesoft.com/dataweave/latest/dataweave-cookbook)
