Wasn't expecting this kind of obvious answer! :)
Before adding a question here, i have gone through all the open problem statements in this forum and none of them have a direct solution.
The external API I am trying to mimic and import XML from, is not under my control. Also, please note that it works with Python, Java and browsers, but not with Denodo Express !
Is that intentional for Express to behave ?
Since, you are able to reproduce it, please try with Java, Python and IE does that work ? If not, then the problem still persists.
Desperately waiting for technical solution.