how to example to create a map for edi 204 using intergration account, visual studio , azure logic apps

Question

how to example to create a map for edi 204 using intergration account, visual studio , azure logic apps

Diana Boone 26

Does anyone have an example article where someone has taken and EDI x12 file format and pushed it into a row in a sql table?
I would like to see if azure logic apps would work but I can't find example with how to map the contents of the x12 file to a json format then take the json and insert into a sql table.

It shouldn't be difficult but I have yet to find an example. Can I use a schema or some of kind of scripting language or something else than C#?
272946-edi204.txt

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-01-04T05:04:10.067+00:00

@Diana Boone The query is more towards creating the map based on your EDI document rather than adding the maps to the logic app. For logic app end you can review this document. I am not an expert in creating the map, but you need to first determine the data that needs to be included in the EDI 204 document. This will typically include information about the shipment, such as the type of cargo, the shipping and receiving parties, and the dates and locations of pickup and delivery. There are several options available for creating EDI maps, including specialized EDI mapping software, spreadsheet programs, and text editors and you research it as per your need. Identify the data elements that need to be included in the EDI 204 and map them to the corresponding fields in the software or tool that you are using. This will typically involve creating a table or spreadsheet with columns for the data elements and rows for each instance of the data.

Feel free to let me know if there are any specific queries from logic app end.
Diana Boone 26 Reputation points

2023-01-04T12:10:14.15+00:00

So Microsoft does not have a "product , tool, or service" that helps with the actual mapping from X12 format to a json format? Yes, I'm sure it can be done using C# but I was looking for something that would "fit into " the logic app workflow.

Your answer

MayankBargali-MSFT 70,936 Reputation points Moderator

2023-01-04T05:04:10.067+00:00

@Diana Boone The query is more towards creating the map based on your EDI document rather than adding the maps to the logic app. For logic app end you can review this document. I am not an expert in creating the map, but you need to first determine the data that needs to be included in the EDI 204 document. This will typically include information about the shipment, such as the type of cargo, the shipping and receiving parties, and the dates and locations of pickup and delivery. There are several options available for creating EDI maps, including specialized EDI mapping software, spreadsheet programs, and text editors and you research it as per your need. Identify the data elements that need to be included in the EDI 204 and map them to the corresponding fields in the software or tool that you are using. This will typically involve creating a table or spreadsheet with columns for the data elements and rows for each instance of the data.

Feel free to let me know if there are any specific queries from logic app end.
Diana Boone 26 Reputation points

2023-01-04T12:10:14.15+00:00

So Microsoft does not have a "product , tool, or service" that helps with the actual mapping from X12 format to a json format? Yes, I'm sure it can be done using C# but I was looking for something that would "fit into " the logic app workflow.

Share via

how to example to create a map for edi 204 using intergration account, visual studio , azure logic apps

Your answer