json to xml

Anonymous — Sat, 16 Nov 2024 02:34:02 GMT

I have a requirement to extract data from RestAPI and convert it to xml format. The problem comes from how to handle data that is looped

The data comes in the body

ex. json

{
  "magentoOrderId": "200026689",
  "comments": null,
  "date": "2020-04-27 15:50:55",
  "zone": 1,
  "customer": {
    "magentoCustomerId": "3633",
    "email": "emparbadia@icloud.com",
    "phoneNo": "615272461",
    "name": "Empar Badia Nácher",
    "shipToCountry": "ES",
    "shipToCity": "Swedish",
    "shipToPostCode": "46410",
    "shipToAddress": "C / dels Foressos, 27, 1",
    "shipToAddress2": null,
    "billToCountry": "ES",
    "billToPostCode": "46410",
    "billToCity": "Swedish",
    "billToAddress": "C / dels Foressos, 27, 1",
    "billToAddress2": "Valencia"
  },
  "salesLines": [
    {
      "itemId": "11000135242",
      "unitPrice": "66.0300",
      "discountPct": "0.0000",
      "quantity": "1.0000"
    },
    {
      "itemId": "11000326942",
      "unitPrice": "66.0400",
      "discountPct": "0.0000",
      "quantity": "1.0000"
    }
  ],
  "paymentMethodCode": "i4redsyspro",
  "shippingCost": "0.0000"
}

salesLines has a loop, how do I fix it to pass to xml

At the moment I have the following

tRestRequest -> TextractJSONFields

Thank you

Re: json to xml

manodwhb — Fri, 01 May 2020 06:02:30 GMT

If your are using enterprise Talend, then you can use tHmap to convert Json to XML.

topic Re: json to xml in Talend Studio

json to xml

Re: json to xml