• JDELIST is celebrating its 20 year anniversary today!
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Parsing XML File

yadah

Member
Hello Guys,

I have a requirement of parsing an XML File and using the same to update values in the JD custom Table. I have gone through the documentation but unable to find a function to get element value

Has anyone used the above scenario.

Harsh
 

alfredorz

Well Known Member
Hi friend,

Finally, could you read the xml file?

I only know using Xerces API with BSFN C and function XRCS_getElementAttributeValueByName. Find a standard function in source directory that use it, and try implement.

Regards.
 

rsvconsulting

VIP Member
To read xml file, JDE does not have a generic/general purpose business function(bsfn) or tool you can use because every xml file has different elements. You will have to create custom bsfn to read xml file.
These are some example bsfn for specific use case,

B34A4540
B34A2380
B964721
B96472
B90CA300
B0801140

Use Cross Reference Facility to find out what app or ube uses them and study how they work and use the code in your custom bsfn with modification to fit your use case.

R984038XB can read XML file into a JDE table.

There are also 3rd party tools that convert xml into csv file then use Table Conversion Tool to import csv file.
 
Top