How to work with Json Arrays when converting an xml to json using Python script in ION

Hi All,

I am having an issue where from an python script I am trying to convert an xml to Json.

But The Address array appears in json only if multiple address tags are passed from xml.

I am expecting this as below But I am not getting it in a array format and I want it in that format even if its one Record of addresses. Else the record is failing in third party application. with the error..

Has anybody work on this to create json Arrays from a python script or any other in ION?

Error from third party application:

{

"code": "REQUEST_VALIDATION_ERROR",

"message": "Invalid schema for content type application/json. Errors: /addresses expected type: JSONArray, found: JSONObject. "

}

Expected Result:

"addresses": [
{
"id": "",
"ifsAddressId": "",
"addressType": "",
"street": "",
"postalCode": "",
"city": "",
"state": "",
"stateCode": "",
"country": "",
"countryCode": ""
}
],

This below is my python script

import json

import xmltodict

xml = xmltodict.parse(input_xml)

output_json = xml['BillToPartyMaster']

print(output_json)

This is the xml with address tags I am trying to convert to Json

</addresses>

This is the json output I am getting in Test window of python scripting

"addresses": {

"id": "",

"ifsAddressId": "",

"addressType": "",

"street": "",

"postalCode": "",

"city": "",

"state": "",

"stateCode": "",

"country": "",

"countryCode": ""

Find more posts tagged with

ION Mapper & Scripting

Accepted answers

unknown

Hi Brandon,

The issue is resolved for me.

There is a force_list method which when used My addresses and other arrays come in Array (List) format even for one or multiple iterations.

My Json now looks ok

xml = xmltodict.parse(input_xml, force_list={"addresses","phones"})

Thanks and have a nice weekend

All comments

Brandon Watson

Hello Shashank! With your code, it will create a 1-to-1 for the JSON, meaning if you only have one addresses element, then you will only see one addresses in the json. However, if you test with an XML that has multiple addresses your json will result with multiple addresses. Below is an example output from my test with your code. This will be problematic when your BOD only has one address. I would consider building the entire JSON as a string in your script, then you can parse values from the XML, into the JSON. This will ensure that JSON is always correct.

unknown

Hi Brandon,

Thanks. Yes the issue is if I have single address. Like this I have other arrays as well like "Phones", Emails etc

Yes that is the task ahead of me to build the json along with the arrays from an xml converted.

Do you have any sample code of that in Python. Please can you share ??

Brandon Watson

Hello! Something like the below would work, where there is only one address, but could be changed to support more. Hopefully this helps!

'''

import json

from xml.etree import ElementTree as ET

root = ET.fromstring(input_var_1)

address_id = root.find('.//Location/Address/id').text

json_base = '''{

"addresses": [

{

"id": "",

"ifsAddressId": "",

"addressType": "",

"street": "",

"postalCode": "",

"city": "",

"state": "",

"stateCode": "",

"country": "",

"countryCode": ""

}

]

}

'''

json_data = json.loads(json_base)

json_data['addresses'][0]['id'] = address_id

output_var_1 = json.dumps(json_data)

'''

unknown

Hi Brandon,

The issue is resolved for me.

There is a force_list method which when used My addresses and other arrays come in Array (List) format even for one or multiple iterations.

My Json now looks ok

xml = xmltodict.parse(input_xml, force_list={"addresses","phones"})

Thanks and have a nice weekend

Roy Es van

I made a generic script for this with a json_forcelist_input where you can provide multiple tags to create a list for. This way you only need one script and use it for every generic conversion between xml and json

use it like this

Copyright © 2025 Infor. All rights reserved.