Troy Thomas
asked on
Convert XML to JSON
Hi, All - I need to convert XML to JSON 1-5 times a month, I want to do this on premise on a Windows or Linux server. Online conversions are not an option, doing the task manually is not an option.
I would prefer to find a free option, happy to pay a little money for software however free is best. I was thinking java, ASP - anything really.
The files will be downloaded from an FTP server and placed in a directory, which I then hope to have something pick them up to convert them. Once converted the files will be placed in a folder.
I am looking for suggestions and ideas on how to make this happen, in the event someone out there is feeling helpful I have attached the two files that I will convert regularly that can be used to create a script.
Thanks
promotionsxml.xml
201707pb.xml
I would prefer to find a free option, happy to pay a little money for software however free is best. I was thinking java, ASP - anything really.
The files will be downloaded from an FTP server and placed in a directory, which I then hope to have something pick them up to convert them. Once converted the files will be placed in a folder.
I am looking for suggestions and ideas on how to make this happen, in the event someone out there is feeling helpful I have attached the two files that I will convert regularly that can be used to create a script.
Thanks
promotionsxml.xml
201707pb.xml
ste5an
Normally you would write a XSLT transform. This allows to create JSON (any text in reality) as output from your XML file. The necessary tools are already on-board: MSXML. It can be invoked by command-line via VBScript or PowerShell.
I use BizTalk or custom code for this. Can you write C# etc.?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.