logicapps icon indicating copy to clipboard operation
logicapps copied to clipboard
verified publisher icon Azure

EDIFACT Decode connector (built-in) integration account parameter is missing

Open corocode opened this issue 10 months ago • 1 comments

Describe the Bug with repro steps

  1. Create and configure an integration account (sku Free) with your artifacts: 2 partners, an EDIFAct type agreements between the partners, and the xsd scheme for EFACT_D96A_ORDERS.xsd

  2. create an standard logic app using and WS1:1 app service plan

  3. create a basic workflow with the following steps:

a. an "http request" trigger to receive the edifact string in binary base64 with the following scheme:

{
    "type": "object",
    "properties": {
        "filename": {
            "type": "string"
        },
        "fileContent": {
            "type": "string"
        }
    }
}

b. an in-app action "EDIFACT Decode" with the following message to decode parameter:

base64ToString(triggerBody()?['fileContent'])

You will not find the integration account parameter in the configuration screen. Also, in the "About" section you will see

Connector: Not available

Operation note: Convert EDIFACT flat file to XML message.

Connector type: In-app

  1. test run with payload with a basic edifact ORDERS D96A message in binary, in the EDIFACT decode step you will see:

IntegrationAccountCallbackUrlInvalid The integration account callback URL specified is invalid.

Of course you need to link the integration account, but there is no option to do it. And in the doc doesn't show it too: https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-enterprise-integration-edifact?tabs=standard

What type of Logic App Is this happening in?

Standard (Portal)

Which operating system are you using?

Windows

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {
            "EDIFACT_Decode": {
                "type": "EdifactDecode",
                "inputs": {
                    "messageToDecode": "@base64ToString(triggerBody()?['fileContent'])",
                    "componentSeparator": 58,
                    "dataElementSeparator": 43,
                    "escapeCharacter": 63,
                    "repetitionSeparator": 42,
                    "segmentTerminator": 39,
                    "segmentTerminatorSuffix": "None",
                    "decimalPointIndicator": "Comma",
                    "payloadCharacterSet": "Legacy"
                },
                "runAfter": {}
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "triggers": {
            "When_a_HTTP_request_is_received": {
                "type": "Request",
                "kind": "Http",
                "inputs": {
                    "schema": {
                        "type": "object",
                        "properties": {
                            "filename": {
                                "type": "string"
                            },
                            "fileContent": {
                                "type": "string"
                            }
                        }
                    }
                }
            }
        }
    },
    "kind": "Stateful"
}

Screenshots or Videos

Configuration of the agreement - receive options:

Configuration of the EDIFACT built-in:

Image

Image

Browser

Edge

Additional context

Trying to decode and EDIFACT flat message type ORDERS - D96A, and use the built-in DECODE connector to transform the flat text to XML.

This is an example of the flat text message:

UNA:+,? '

UNB+UNOC:3+372670674:1+ZZ03072025BW:14+150930:0455+716'

UNH+71600001+ORDERS:D:96A:UN:EAN008'

BGM+220+4500000000+9'

DTM+137:20150930:102'

FTX+AAI+++Order Level Text'

RFF+CR:Customer Reference Number'

NAD+BY+311698::91++XYZ International GmbH:Zxyzabcdeeffffff+John-aaa-Str. 40+Bssssss++D-99999+DE'

CTA+PD+:Christian Izzo'

NAD+SU+0000011111::9'

NAD+DP+++GmbH:Distribution Center+Nabccadadd.+Munich++11234+DE'

CTA+GR+:END USER'

COM+0241/1234567:TE'

NAD+IV+311698::91++XYZ International GmbH:Zxyzabcdeeffffff+John-aaa-Str. 40+Bssssss++D-99999+DE'

CUX+2:EUR:9'

LIN+10++XYZ_PART:BP'

PIA+1+Vendor_Part:VP+EndCustomerPart:UA+BATCH_No:NB+4500_END_CUST_ORDER:ON'

IMD+F++:::MODUL A'

QTY+21:2:EA'

DTM+2:20151001:102'

MOA+203:2000.00'

FTX+AAI+++Line Item Text'

PRI+AAA:1000.00:CA'

RFF+AGA:Agreement Number:Agreement Line Number'

RFF+CR:Customer Reference Number Line Level'

RFF+PR:Quote Number'

LIN+20++XYZ_PART_2:BP'

PIA+1+Vendor_Part_2:VP+EndCustomerPart2:UA+BATCH_No_2:NB+4500_END_CUST_ORDER:ON'

IMD+F++:::MODUL X'

QTY+21:1:EA'

DTM+2:20151001:102'

MOA+203:225.50'

PRI+AAA:225.50:CA'

UNS+S'

UNT+33+71600001'

UNZ+1+716'

This is the EDIFACT agreement JSON:

{

"properties": {

"hostPartner": "bwfr",

"guestPartner": "vwrfr",

"hostIdentity": {

"qualifier": "14",

"value": "ZZ03072025BW"

},

"guestIdentity": {

"qualifier": "1",

"value": "372670674"

},

"agreementType": "EDIFACT",

"content": {

"edifact": {

"receiveAgreement": {

"protocolSettings": {

"validationSettings": {

"validateCharacterSet": true,

"checkDuplicateInterchangeControlNumber": false,

"interchangeControlNumberValidityDays": 30,

"checkDuplicateGroupControlNumber": false,

"checkDuplicateTransactionSetControlNumber": false,

"validateEDITypes": true,

"validateXSDTypes": false,

"trimLeadingAndTrailingSpacesAndZeroes": false,

"allowLeadingAndTrailingSpacesAndZeroes": false,

"trailingSeparatorPolicy": "NotAllowed"

},

"framingSettings": {

"protocolVersion": 3,

"dataElementSeparator": 43,

"componentSeparator": 58,

"segmentTerminator": 39,

"releaseIndicator": 63,

"repetitionSeparator": 42,

"characterSet": "UNOB",

"decimalPointIndicator": "Comma",

"segmentTerminatorSuffix": "None"

},

"envelopeSettings": {

"applyDelimiterStringAdvice": false,

"createGroupingSegments": false,

"enableDefaultGroupHeaders": true,

"recipientReferencePasswordValue": "",

"recipientReferencePasswordQualifier": "",

"interchangeControlNumberLowerBound": 1,

"interchangeControlNumberUpperBound": 999999999,

"rolloverInterchangeControlNumber": true,

"groupControlNumberLowerBound": 1,

"groupControlNumberUpperBound": 999999999,

"rolloverGroupControlNumber": true,

"overwriteExistingTransactionSetControlNumber": true,

"transactionSetControlNumberLowerBound": 1,

"transactionSetControlNumberUpperBound": 999999999,

"rolloverTransactionSetControlNumber": true,

"isTestInterchange": false,

"businessIdentityQualifierPaddingType": "None"

},

"acknowledgementSettings": {

"needTechnicalAcknowledgement": false,

"batchTechnicalAcknowledgements": true,

"needFunctionalAcknowledgement": false,

"batchFunctionalAcknowledgements": true,

"needLoopForValidMessages": false,

"sendSynchronousAcknowledgement": true,

"acknowledgementControlNumberPrefix": "BW",

"acknowledgementControlNumberLowerBound": 1,

"acknowledgementControlNumberUpperBound": 999999999,

"rolloverAcknowledgementControlNumber": true

},

"messageFilter": {

"messageFilterType": "Exclude"

},

"processingSettings": {

"maskSecurityInfo": true,

"preserveInterchange": false,

"suspendInterchangeOnError": false,

"createEmptyXmlTagsForTrailingSeparators": true,

"useDotAsDecimalSeparator": false

},

"envelopeOverrides": [],

"messageFilterList": [],

"schemaReferences": [

{

"messageId": "ORDERS",

"messageVersion": "D",

"messageRelease": "96A",

"senderApplicationId": "",

"senderApplicationQualifier": "",

"associationAssignedCode": "EAN008",

"schemaName": "EFACT_D96A_ORDERS"

}

],

"validationOverrides": [],

"edifactDelimiterOverrides": []

},

"senderBusinessIdentity": {

"qualifier": "1",

"value": "372670674"

},

"receiverBusinessIdentity": {

"qualifier": "14",

"value": "ZZ03072025BW"

},

"trackingState": "Enabled"

},

"sendAgreement": {

"protocolSettings": {

"validationSettings": {

"validateCharacterSet": true,

"checkDuplicateInterchangeControlNumber": false,

"interchangeControlNumberValidityDays": 30,

"checkDuplicateGroupControlNumber": false,

"checkDuplicateTransactionSetControlNumber": false,

"validateEDITypes": true,

"validateXSDTypes": false,

"trimLeadingAndTrailingSpacesAndZeroes": false,

"allowLeadingAndTrailingSpacesAndZeroes": false,

"trailingSeparatorPolicy": "NotAllowed"

},

"framingSettings": {

"protocolVersion": 3,

"dataElementSeparator": 43,

"componentSeparator": 58,

"segmentTerminator": 39,

"releaseIndicator": 63,

"repetitionSeparator": 42,

"characterSet": "UNOB",

"decimalPointIndicator": "Comma",

"segmentTerminatorSuffix": "None"

},

"envelopeSettings": {

"applyDelimiterStringAdvice": false,

"createGroupingSegments": false,

"enableDefaultGroupHeaders": true,

"interchangeControlNumberLowerBound": 1,

"interchangeControlNumberUpperBound": 999999999,

"rolloverInterchangeControlNumber": true,

"groupControlNumberLowerBound": 1,

"groupControlNumberUpperBound": 999999999,

"rolloverGroupControlNumber": true,

"overwriteExistingTransactionSetControlNumber": true,

"transactionSetControlNumberLowerBound": 1,

"transactionSetControlNumberUpperBound": 999999999,

"rolloverTransactionSetControlNumber": true,

"isTestInterchange": false,

"businessIdentityQualifierPaddingType": "None"

},

"acknowledgementSettings": {

"needTechnicalAcknowledgement": false,

"batchTechnicalAcknowledgements": true,

"needFunctionalAcknowledgement": false,

"batchFunctionalAcknowledgements": true,

"needLoopForValidMessages": false,

"sendSynchronousAcknowledgement": true,

"acknowledgementControlNumberLowerBound": 1,

"acknowledgementControlNumberUpperBound": 999999999,

"rolloverAcknowledgementControlNumber": true

},

"messageFilter": {

"messageFilterType": "Exclude"

},

"processingSettings": {

"maskSecurityInfo": true,

"preserveInterchange": false,

"suspendInterchangeOnError": false,

"createEmptyXmlTagsForTrailingSeparators": true,

"useDotAsDecimalSeparator": false

},

"envelopeOverrides": [],

"messageFilterList": [],

"schemaReferences": [],

"validationOverrides": [],

"edifactDelimiterOverrides": []

},

"senderBusinessIdentity": {

"qualifier": "14",

"value": "ZZ03072025BW"

},

"receiverBusinessIdentity": {

"qualifier": "1",

"value": "372670674"

},

"trackingState": "Enabled"

}

}

},

"createdTime": "2025-03-12T00:32:41.4680083Z",

"changedTime": "2025-03-17T23:32:08.3317499Z"

},

"id": "/subscriptions/e5e4965a-5e8c-4a20-95fa-8ebf551a6fbd/resourceGroups/rg-serascandia/providers/Microsoft.Logic/integrationAccounts/EDIFACTIntegrationAccount/agreements/EDIFact_PO",

"name": "EDIFact_PO",

"type": "Microsoft.Logic/integrationAccounts/agreements"

}

corocode avatar Mar 21 '25 02:03 corocode

Is there any updates to this?

denniselit avatar Oct 27 '25 09:10 denniselit