Map XML to JSON - use xpath in scripting

Legacy Contributor

Hi,

I'm trying to map purchaseorder BOD to JSON using below script:

import json
from xml.etree import ElementTree as ET
ET.register_namespace('', "">schema.infor.com/.../2")
ET.register_namespace('xsi', "">www.w3.org/.../XMLSchema-instance")
root = ET.fromstring(input_po)
 
for each in root.findall(".//DataArea/PurchaseOrder/PurchaseOrderLine"):

However the XPath in root.findall() doesnt find any nodes. I tried different combinations, but couldn't get it to work.

I've tried to import lxml library as well, but couldn't find the right whl package - I tried cp37m, manylinux1_x86_64 and few other packages.

I appreciate any help!

TIA

Brandon Watson

Have you tried either of the two approaches below? I prefer the first way, as it completely takes NS out of it and then sets it back at the end.

root = ET.fromstring(input_po.replace('xmlns="'">schema.infor.com/.../2"',"").replace('xmlns:xsi="'">www.w3.org/.../XMLSchema-instance"',""))

for each in root.findall(".//PurchaseOrder/PurchaseOrderLine", ):

#Do stuff here

root.set("xmlns:xsi","">www.w3.org/.../XMLSchema-instance")

root.set("xmlns","">schema.infor.com/.../2")
===========================================================

ns = {

'bod': 'schema.infor.com/.../2',

}

root = ET.fromstring(input_po)

for each in root.findall(".//bod:PurchaseOrder/PurchaseOrderLine", ns):

#Do stuff here