With the exploding adoption of IoT and mobile applications, how do you handle all this data behind REST web services along with their expanded requirements?
For years, Progress customers have been using XML Converters to bi-directionally convert EDI and flat-file data into XML documents and streams. As companies adopt and integrate with IoT, mobile devices and data behind REST web services, their requirements have expanded, now requiring bi-directional conversion of EDI/flat-file data into JSON instead of XML.
How can one do this with XQuery and the XML Converters? Let me show you using the following sample X12 270 5010 (Real-time eligibility, coverage or benefit requests) HIPAA document and Stylus Studio.
Using Stylus Studio’s XML Mapper functionality and the DataDirect XQuery engine, you’ve mapped your EDI data into the desired XML Schema (see below).
When you press the green preview button, you generate your desired XML output.
The DataDirect XQuery engine is seamlessly integrated with the XML Converters and can force the output into another supported format just by using one of the DataDirect XQuery functions. To generate the output as JSON data, write the following command at the beginning of your existing XQuery statement.
declare option ddtek:serialize “method=JSON”;
Re-run your XQuery statement by pressing the green preview button. You’ll see the output has been converted to JSON based on the XML Schema defined.
Now, your web clients, mobile applications or IoT devices are ready to support real-time eligibility, coverage or benefit requests with JSON.
Get instant SQL connectivity from tabular and hierarchical-formatted XML documents with a single connector. Progress DataDirect enables you to connect to XML via ODBC, XML Converters, XQuery or XML editor. These solutions enable the easy integration of XML data with your application, along with the ability to quickly retrieve data from either a local file system, a web server or a web service.
View all posts from Gordon Crenshaw on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.