Scripting & Automation - How can I convert JSON to XML in 2K2?

Print Page | Close Window

How can I convert JSON to XML in 2K2?

Printed From: Rocket Software
Category: AccuTerm Knowledge Base (read only)
Forum Name: Scripting & Automation
Forum Description: Customize and control AccuTerm using scripts and automation
URL: https://forum.asent.com/forum_posts.asp?TID=2710
Printed Date: March 26 2026 at 8:51pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: How can I convert JSON to XML in 2K2?

Posted By: rsine
Subject: How can I convert JSON to XML in 2K2?
Date Posted: March 05 2019 at 4:17am

Can someone provide a script example of how a JSON string can be converted to XML in 2K2?

Replies:

Posted By: TonyG
Date Posted: March 20 2019 at 10:00am

That's not actually a question regarding AccuTerm. It's more of a question about how to code with the server to which AccuTerm is connected.

I welcome you to join a community forum to ask your question, and please tell the group which Pick/MV platform you are using. Good luck!

http://groups.google.com/group/mvdbms" rel="nofollow - http://groups.google.com/group/mvdbms

-------------
Tony Gravagno Nebula Research & Development
TG@ Nebula-RnD . com
http://Nebula-RnD.com/blog
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms
https://www.linkedin.com/groups/64935

Posted By: rsine
Date Posted: March 20 2019 at 10:09am

Tony,

I'm using MVEnterprise. The reason I asked about an Accuterm example is because I tried so many Google searched solutions that didn't work, I figured it had to be something with Accuterm.

Posted By: TonyG
Date Posted: March 21 2019 at 10:11am

The best approach for things like this is to step outside of the MV box. You're not dealing with a MV-specific challenge. So you can Google for "json to xml" and you will find a ton of OS-level solutions. So all you need to do is to write the data to the OS, Execute an OS command to operate on that data, and if necessary you can read it back in for post-processing. This is not inelegant. It's using the tools that are available, effectively and quickly. The solution does not need to be in the DBMS or in connectivity tools.

HTH

-------------
Tony Gravagno Nebula Research & Development
TG@ Nebula-RnD . com
http://Nebula-RnD.com/blog
http://Twitter.com/TonyGravagno
http://groups.google.com/group/mvdbms
https://www.linkedin.com/groups/64935