Kathir J
Kathir J

Reputation: 1

JSON with EDI => XML/CSV/EDI/Txt

I'm trying to create a JSON structure for EDI. Input file will be EDI. i need to retrieve the EDI values via JSON and generate an user defined XML/EDI.

I see a json to json mapping in the link: http://www.altova.com/mapforce/json-data-mapping.html

I don't need a mapping but i need to retrieve the EDI values and have the incoming EDI structure in JSON format.

Could someone please share your thoughts on the same?

Thanks in advance.

Upvotes: 0

Views: 1191

Answers (2)

bnjt
bnjt

Reputation: 1

Stedi has an EDI translator which converts X12 EDI to and from JSON. There is also a mapper to further transform the shape of the JSON on either end. Disclosure: Stedi affiliated.

(edit: disclosure)

Upvotes: 0

NitzerEbb
NitzerEbb

Reputation: 1

Mapping is the way I use with Altova Mapforce.

First of all you can construct a mapping from EDI to XML and vice versa. Then let Mapforce create the code for it e.g. in C Sharp.

Unfortunately a mapping from EDI to JSON in combination with the code generator is not supported in Mapforce. So we have to do a little side step.

You can use little helper tools like Newtonsofts JSON and convert the XML to a json array. This will allow you to work with object structures in combination with EDI.

In case you use the code generator from Mapforce the working order is like:

EDI - XML - JSON to generate your json from an edi document

JSON - XML - EDI to generate your json to an edi document

Upvotes: 0

Related Questions