I can think of two ways to solve the problem.
- Use an XSL policy to Transform the returned XML to translate <ExampleNull i:nil="true"></ExampleNull> into <ExampleNull/>
- Transform the JSON output of the XMLToJSON policy using a JavaScript policy that correctly walks the graph of the response object.
Which you prefer depends on your situation. The XSL policy does the recursion you want implicitly - that's how XSL works. So you may find it easier to do the replacement there. Or, You may prefer to write things in JavaScript, if you don't know XSL. JS may be easier to maintain in that case.
As an example of case 1, XSL
Suppose the XML returned is like this:
<Response xmlns:i='i'>
<AccountId>12345</AccountId>
<CompanyCode>1</CompanyCode>
<CustomerName>Joseph X. Schmoe</CustomerName>
<EmailAddressList>
<Response.mailAddressDTO>
<AlertOptionList/>
<ContactMethodSeqNum>2</ContactMethodSeqNum>
<EmailAddress/>
</Response.mailAddressDTO>
</EmailAddressList>
<MailingAddress>
<NonStandard i:nil='true'/>
<Standard>
<Address>Example</Address>
<DisplayAddressText i:nil='true'/>
</Standard>
</MailingAddress>
<LastBill/>
<LastPayment/>
</Response>
Running that through this XSL:
<xsl:stylesheet version="1.0"
xmlns:i="i"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output indent="yes" omit-xml-declaration="yes"/>
<!-- pass through for all elements and attributes -->
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="node()|@*"/>
</xsl:copy>
</xsl:template>
<!-- for elements with a nil='true' attribute, strip the attribute -->
<xsl:template match="*[@i:nil='true']">
<xsl:element name="{local-name()}"/>
</xsl:template>
</xsl:stylesheet>
...results in this:
<Response xmlns:i="i">
<AccountId>12345</AccountId>
<CompanyCode>1</CompanyCode>
<CustomerName>Joseph X. Schmoe</CustomerName>
<EmailAddressList>
<Response.mailAddressDTO>
<AlertOptionList/>
<ContactMethodSeqNum>2</ContactMethodSeqNum>
<EmailAddress/>
</Response.mailAddressDTO>
</EmailAddressList>
<MailingAddress>
<NonStandard/>
<Standard>
<Address>Example</Address>
<DisplayAddressText/>
</Standard>
</MailingAddress>
<LastBill/>
<LastPayment/>
</Response>
If you then pass THAT ^^ through the XMLToJSON policy I think you will get what you desire.
For case 2, Post-Process in JavaScript
you need to walk the graph of the JSON hash. For that you can use logic like this:
// walkObj.js
// ------------------------------------------------------------------
var what = Object.prototype.toString;
function walkObj(obj, fn) {
var wo = what.call(obj);
if (wo == "[object Object]") {
Object.keys(obj).forEach(function(key){
fn(obj, key);
var item = obj[key], w = what.call(item);
if (w == "[object Object]" || w == "[object Array]") {
walkObj(item, fn);
}
});
}
else if (wo == "[object Array]") {
obj.forEach(function(item, ix) {
fn(obj, ix);
});
obj.forEach(function(item, ix) {
var w = what.call(item);
if (w == "[object Object]" || w == "[object Array]") {
walkObj(item, fn);
}
});
}
}
function checkAndFixNull(parent, key) {
var value = parent[key], w = what.call(value);
if ((w == "[object Object]") && (value.TEXT === null) && (value['@nil'] === true)) {
parent[key] = null;
}
}
var source = JSON.parse(context.getVariable('request.content'));
walkObj(source, checkAndFixNull);
// source now contains the transformed JSON hash
context.setVariable('request.content', JSON.stringify(source, null, 2));
Supposing input JSON like this:
{
"Response": {
"AccountId": "12345",
"CompanyCode": 1,
"CustomerName": "Joseph X. Schmoe",
"EmailAddressList": {
"Response.EmailAddressDTO": {
"AlertOptionList": null,
"ContactMethodSeqNum": 2,
"EmailAddress": null
}
},
"MailingAddress": {
"NonStandard": {
"@nil": true,
"TEXT": null
},
"Standard": {
"Address": "Example",
"DisplayAddressText": {
"@nil": true,
"TEXT": null
}
}
},
"LastBill": null,
"LastPayment": null
}
}
...the output is like this:
{
"Response": {
"AccountId": "12345",
"CompanyCode": 1,
"CustomerName": "Joseph X. Schmoe",
"EmailAddressList": {
"Response.EmailAddressDTO": {
"AlertOptionList": null,
"ContactMethodSeqNum": 2,
"EmailAddress": null
}
},
"MailingAddress": {
"NonStandard": null,
"Standard": {
"Address": "Example",
"DisplayAddressText": null
}
},
"LastBill": null,
"LastPayment": null
}
}
LinkedIn
Twitter
