I have installed Cdata Arc software and trying to create Flows.
Created Flow to convert EDI file → Xml → JSON. I couldn’t generate JSON as in my Xml step it is showing source and destination files both are in xml format. How can I generate Json out of xml. Can anyone provide brief of complete workflow and how it works.
Best answer by Yazhini Gopalakrishnan
Thank you for reaching out!
Arc cannot convert an EDI file directly into JSON, but you can do that with the following flow:
EDI connector -> XML Map connector -> JSON connector.
The EDI connector reads your EDI file and converts it into XML. This EDI XML is then used as the source file in the XML Map connector.
For the destination, take your expected JSON master sample and run it through the JSON connector first. The JSON connector converts it into XML, and this JSON XML is then used as the destination file in the XML Map connector.
With both the source EDI XML and destination JSON XML loaded into the XML Map connector, you can map the fields between them. This tells Arc how to transform the incoming EDI XML into the exact XML structure that matches your expected JSON output. The JSON connector at the end of the flow then takes this mapped XML and outputs it as your final JSON file.
If you would like more information, please check out these docs for each connector:
EDI connector: https://cdn.cdata.com/help/AZK/mft/EDI-Connectors.html
JSON connector: https://cdn.cdata.com/help/AZJ/mft/JSON.html
XML Map connector: https://cdn.cdata.com/help/AZK/mft/XML-Map.html
Generating template files: https://cdn.cdata.com/help/AZH/mft/XML-Map-Template-Files.html
Also, here is a quick read with a video tutorial that covers the mapping flow end to end: https://arc.cdata.com/kb/articles/mapping-overview-vid.rst
Hope this helps! If you need any further assistance, feel free to reach out to
Thank you for reaching out!
Arc cannot convert an EDI file directly into JSON, but you can do that with the following flow:
EDI connector -> XML Map connector -> JSON connector.
The EDI connector reads your EDI file and converts it into XML. This EDI XML is then used as the source file in the XML Map connector.
For the destination, take your expected JSON master sample and run it through the JSON connector first. The JSON connector converts it into XML, and this JSON XML is then used as the destination file in the XML Map connector.
With both the source EDI XML and destination JSON XML loaded into the XML Map connector, you can map the fields between them. This tells Arc how to transform the incoming EDI XML into the exact XML structure that matches your expected JSON output. The JSON connector at the end of the flow then takes this mapped XML and outputs it as your final JSON file.
If you would like more information, please check out these docs for each connector:
EDI connector: https://cdn.cdata.com/help/AZK/mft/EDI-Connectors.html
JSON connector: https://cdn.cdata.com/help/AZJ/mft/JSON.html
XML Map connector: https://cdn.cdata.com/help/AZK/mft/XML-Map.html
Generating template files: https://cdn.cdata.com/help/AZH/mft/XML-Map-Template-Files.html
Also, here is a quick read with a video tutorial that covers the mapping flow end to end: https://arc.cdata.com/kb/articles/mapping-overview-vid.rst
Hope this helps! If you need any further assistance, feel free to reach out to
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
