#Missing API response in XML format

Hi Team,

I'm facing a lot of issues with oanda v20 api request/response format which is currently available only in Json format, i need response to be in XML format.

1. Is there any way from which I can get a response in XML format directly from the API?
2. Or can I convert JSON format in XML object in VB scripts in excel macros?

Please let me know the possible solutions.

Thanks in advanced.