XML To Json Conversion

Document ID : KB000103785
Last Modified Date : 29/06/2018
Show Technical Document Details
Question:

Users publish soap/xml services by converting them to rest/json.
They use 'Apply Json Transformation' assertion to convert xml to json.  In some cases, the same field converted as an object and array at the same response.
I have added a screenshot that explains the situation.
How can we fix this conversion issue? 

 

Environment:
ENV: 9.3
Answer:
This issue is not related to ordering. The values of duplicate tags at the same level in XML are being combined into an array, where if there's only one tag it's converted to an object. This is a common way JSON libraries handle duplicate field names in an object. 

While the official JSON standard does not forbid duplicate keys, it is discouraged and there is no requirement for them to be supported. 

This Stack Overflow answer explains and gives sources for this very clearly:
https://stackoverflow.com/a/23195243/2631689 
File Attachments:
apiResponse.jpg