Azure Logic Apps EDIFACT DECODE Allow underscore(_) character in

Question

I am using Azure Logic Apps and Integration Accounts for receiving the EDIFACT messages.

The EDIFACT incoming message has an underscore character in it, and EDIFACT DECODE validation fails with the message:

Error encountered during parsing. The Edifact transaction set with id '1' contained in interchange (without group) with id '1', with sender id 'XXX', receiver id 'XXXXX' is being suspended with following errors:

Error: 1 (Field level error)

SegmentID: BGM

Position in TS: 2

Data Element ID: XXXX

Position in Segment: 3

Position in Field: 1

Data Value: 1_2017-09-2206:24:42

21: Invalid character found

I want to allow the underscore character to be considered as valid character, appreciate any pointers in resolving the issue.

Answer 1

It's all driven by the standard character set, see here, I don't recall any that supports underscore, so ultimately the transaction is incorrect according to the EDIFACT standard as the error message states.

Answer 2

There are 1.5 problems. :)

But, the first thing you need to do is inform your management that your Trading Partner is sending invalid EDIFACT. If the Trading Partner is not able to solve their problem, you will have to spend extra time accommodating their issue.

This is not a problem with you, your app or BizTalk Server.

EDIFACT supports a very limited number of character sets and "_" is not in any of them.

Either they fix their problem or you will have to create a custom Function that removes/changes the invalid characters.

Finally, the .5 problem is that they're not even sending a usable value. That format is not any standard date format so manipulation would be required anyway to use it.