JSON to XML by Object Schema

unknown

Hi!

I am running some API flows that receives a JSON payload. 

After that, I call the IONSERVICES /v2/message to get my message into the correct Application in order for me to use a Data Flow. (Why can't I send a message directly from an API Flow into a Data Flow....?)

However, I need the payload in an XML format. 
This should be fully possible by parsing the JSON Schema, and tell it to use the configured schema and output an XML instead. But unfortunately this cannot be done.

Instead I have to insert my JSON to a Python script and use dicttoxml which is an awful library, this results in me getting extra appended <item> tags due to bad converting.

Does anyone have a better alternative for converting the JSON to XML somewhere in ION?

unknown

Hi

Greetings!.

We have done XMLtoJson conversion using Python Script on Dataflow. have used XML file schema into Json schema using below links 

https://www.liquid-technologies.com/online-xml-to-xsd-converter. We have also faced the same issue what you have, Used below Python Script , you may change based on your requirement.

import xmltodict

import json

def convert_xml_to_json(xml_string):

    # Convert XML to Python dictionary

    data_dict = xmltodict.parse(xml_string)

    # Check if there is only one partNumber

    parts_data = data_dict['PCC_Order_Status']['fulfillment']['parts']

    if isinstance(parts_data, dict):

        # Wrap the single partNumber in a list

        data_dict['PCC_Order_Status']['fulfillment']['parts'] = [parts_data]

    # Convert Python dictionary to JSON

    json_data = json.dumps(data_dict, indent=4)

    return json_data

def replace_null_with_empty_string(json_object):

  for key, value in json_object.items():

    if value is None:

      json_object[key] = ""

    elif isinstance(value, dict):

      replace_null_with_empty_string(value)

    elif isinstance(value, list):

      for item in value:

        replace_null_with_empty_string(item)

  # Parse the XML data into a Python dictionary.

#xml_dict = xmltodict.parse(xml_data)

# Convert XML to JSON

json_data = convert_xml_to_json(xml_data)

# Remove the outermost layer

start_index = json_data.find(':') + 1

end_index = json_data.rfind('}')

json_data = json_data[start_index:end_index]

json_object = json.loads(json_data)

# Replace all `None` values with empty strings

replace_null_with_empty_string(json_object)

# Convert the JSON object to a string

json_data = json.dumps(json_object,indent=4)

  

  # Print the JSON data

   #print(json_data)