Need help exporting Epicor data in a structured xml file with parent / child nodes.
Specifically trying to export ShipHead and ShipDtl records in xml where the ShipHead elements are listed first, then child nodes follow, one for each line on the pack.
Have tried exporting BAQs, and API calls to the business objects.
Best answer by fred
View original
I don’t think Epicor has a native tool that will convert either BAQ results or JSON into XML. If you have access to the SQL Server, there is a “FOR XML” clause you can use to get results as XML. Alternatively you can write a program to convert the JSON to XML and format it exactly as you need.
You’ll need to know the format of the XML output. What the expected node names and attributes are. My guess is what comes out natively for column names is not the exact XML that you are wanting in the long run.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.