Hi Everyone,

I am using API Gateway version 10.15 and I am trying to transform my response from JSON to XML using XSLT in response processing policy. But my response is always in json despite of my payload. How can I transform my JSON response to XML. This is my XSLT.

<xsl:stylesheet version="1.1" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:strip-space elements="*"/>
<xsl:output method="xml"/>
<!-- Identity transform -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="*[not(node()) or text() = 'null']"/>
</xsl:stylesheet>

What is the value passing in Accept header parameter in the request and give us the details about response policy defined for the API?

In header Accept value is “/”

This is the payload defined in response processing.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<invoicedetails>
<invoiceid>
12345
</invoiceid>
<paymentreference>
269467
</paymentreference>
<referenceid>
fa51c8b6
</referenceid>
<externaltransactionid>
2112
</externaltransactionid>
<receiver>
ID:111/11
</receiver>
<creator>
ID:111/11
</creator>
<amount>
<amount>
100.00
</amount>
<currency>
EUR
</currency>
</amount>
<status>
<status1>
PENDING
</status1>

</status>
<creationdatetime>
2022-11-29T15:24:27.920+01:00
</creationdatetime>
<lastupdatedatetime>
2022-11-29T15:24:27.920+01:00
</lastupdatedatetime>
<expirydatetime>
2022-11-29T16:24:27.920+01:00
</expirydatetime>
</invoicedetails>

This is response processing configurations.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/da43b374a6b891bfed89caf7d4a4e1a4ddb60ae2_2_1035x493.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/da43b374a6b891bfed89caf7d4a4e1a4ddb60ae2_2_1380x658.png 2x" data-dominant-color="FBFBFC">

2022-11-30_1840571800×860 47.2 KB

See if this tutorial helps.

It shows how json is transformed using XSLT.

https://youtu.be/h670ZpoC-Zc

Hi @franklinantony,

Thank you for your response but this is JSON to JSON transformation. We need to transform JSON to xml

Similar topic covered here : WM API Gateway - Request Transformation Payload - From JSON to XML? - #10 by rmg

HTH
Bharath