EDI 837 ||的模式验证期间出现X12错误Azure Logic应用程序 [英] X12 Error during Schema Validation of EDI 837 || Azure Logic Apps
本文介绍了EDI 837 ||的模式验证期间出现X12错误Azure Logic应用程序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
UseCase：EDI 837使用X12转换为JSON结构（Azure Logic应用程序）
UseCase : EDI 837 Transformation to JSON structure using X12 (Azure Logic Apps)
采取的步骤：
1。已下载 Microsoft EDI 837架构版本00501
1. Downloaded Microsoft EDI 837 Schema version 00501
2。在集成帐户中配置上述架构&在协议的接收设置中添加。
2. Configured the above schema in integration account & added in the receive settings of Agreement.
EDI（这是一个有效的EDI）文件正在从目录位置（SFTP连接器）并发送到X12连接器。并且响应正在发送到电子邮件帐户。但是得到以下错误"该邮件的文档类型未知未知，并且未解析为协议中配置的任何现有架构"。
EDI (This is a valid EDI) file is getting picked up from a directory location (SFTP Connector) and being sent to the X12 connector. And response is being sent to an Email account. But getting the below error "the message has an unknown document type and did not resolve to any of the existing schemas configured in the agreement".
经过研究，似乎架构未正确配置。但不确定似乎缺少什么。 随附一些人工制品供参考。任何帮助将不胜感激。
After research it seems the schema hasn't been configured correctly. But not sure what seems to be missing. Attached are some artefacts for reference. Any help would be appreciated.
1。 EDI 837
1. EDI 837
ISA*00* *00* *ZZ*1619 *ZZ*REALMED *190122*0759*^*00501*075936319*1*P*:~
GS*HC*1619*REALMED*20190122*0759*522616027*X*005010X222A1~
ST*837*100000000*005010X222A1~
BHT*0019*00*B20EBEC4559349569C8F3806735901*20180903*1937*CH~
NM1*41*2*VaxCare Corporation*****46*1619~
PER*IC*Evan Landis*TE*4074805970~
NM1*40*2*REALMED*****46*RmTestId~
HL*1**20*1~
NM1*85*2*VaxCare Corporation*****XX*1316058217~
N3*3113 Lawton Road~
N4*Orlando*FL*328033517~
REF*EI*020769966~
NM1*87*2~
N3*PO Box 140193~
N4*Orlando*FL*328140193~
HL*2*1*22*0~
SBR*P*18*0******ZZ~
NM1*IL*1*McFakePatient*Fakey****MI*1111111~
N3*1234 Fake Street~
N4*Faketown*PA*19150~
DMG*D8*19900101*M~
NM1*PR*2*AETNA*****PI*60054~
CLM*6034049-0001*67***15:B:7*Y*A*Y*Y~
REF*F8*EYFB6Z4Y20000~
NTE*ADD*Please reprocess for payment.~
HI*ABK:Z23~
NM1*77*2*VaxCare Corporation*****XX*1316058217~
N3*5363 Oxford Ave~
N4*Philadelphia*PA*191249998~
LX*1~
SV1*HC:90471*39*UN*1***1~
DTP*472*D8*20180831~
LX*2~
SV1*HC:90686*28*UN*1***1~
DTP*472*D8*20180831~
SE*34*100000000~
GE*1*522616027~
IEA*1*075936319~
2。整合账户 - 协议
2. Integration Account - Agreement
{
"properties": {
"hostPartner": "Avizva",
"guestPartner": "HPS",
"hostIdentity": {
"qualifier": "ZZ",
"value": "1619"
},
"guestIdentity": {
"qualifier": "ZZ",
"value": "REALMED"
},
"agreementType": "X12",
"content": {
"x12": {
"receiveAgreement": {
"protocolSettings": {
"validationSettings": {
"validateCharacterSet": false,
"checkDuplicateInterchangeControlNumber": false,
"interchangeControlNumberValidityDays": 30,
"checkDuplicateGroupControlNumber": false,
"checkDuplicateTransactionSetControlNumber": false,
"validateEDITypes": true,
"validateXSDTypes": false,
"allowLeadingAndTrailingSpacesAndZeroes": false,
"trimLeadingAndTrailingSpacesAndZeroes": false,
"trailingSeparatorPolicy": "NotAllowed"
},
"framingSettings": {
"dataElementSeparator": 42,
"componentSeparator": 58,
"replaceSeparatorsInPayload": false,
"replaceCharacter": 36,
"segmentTerminator": 126,
"characterSet": "UTF8",
"segmentTerminatorSuffix": "None"
},
"envelopeSettings": {
"controlStandardsId": 85,
"useControlStandardsIdAsRepetitionCharacter": true,
"senderApplicationId": "BTS-SENDER",
"receiverApplicationId": "RECEIVE-APP",
"controlVersionNumber": "00401",
"interchangeControlNumberLowerBound": 1,
"interchangeControlNumberUpperBound": 999999999,
"rolloverInterchangeControlNumber": true,
"enableDefaultGroupHeaders": true,
"groupControlNumberLowerBound": 1,
"groupControlNumberUpperBound": 999999999,
"rolloverGroupControlNumber": true,
"groupHeaderAgencyCode": "T",
"groupHeaderVersion": "00401",
"transactionSetControlNumberLowerBound": 1,
"transactionSetControlNumberUpperBound": 999999999,
"rolloverTransactionSetControlNumber": true,
"overwriteExistingTransactionSetControlNumber": true,
"groupHeaderDateFormat": "CCYYMMDD",
"groupHeaderTimeFormat": "HHMM",
"usageIndicator": "Test"
},
"acknowledgementSettings": {
"needTechnicalAcknowledgement": true,
"batchTechnicalAcknowledgements": true,
"needFunctionalAcknowledgement": false,
"batchFunctionalAcknowledgements": true,
"needImplementationAcknowledgement": true,
"implementationAcknowledgementVersion": "00501",
"batchImplementationAcknowledgements": false,
"needLoopForValidMessages": false,
"sendSynchronousAcknowledgement": true,
"acknowledgementControlNumberLowerBound": 1,
"acknowledgementControlNumberUpperBound": 999999999,
"rolloverAcknowledgementControlNumber": true
},
"messageFilter": {
"messageFilterType": "Exclude"
},
"securitySettings": {
"authorizationQualifier": "00",
"securityQualifier": "00"
},
"processingSettings": {
"maskSecurityInfo": true,
"convertImpliedDecimal": false,
"preserveInterchange": false,
"suspendInterchangeOnError": false,
"createEmptyXmlTagsForTrailingSeparators": true,
"useDotAsDecimalSeparator": false
},
"envelopeOverrides": [],
"validationOverrides": [],
"messageFilterList": [],
"schemaReferences": [
{
"messageId": "837",
"senderApplicationId": "1619",
"schemaVersion": "00501",
"schemaName": "X12_00501_837"
}
],
"x12DelimiterOverrides": []
},
"senderBusinessIdentity": {
"qualifier": "ZZ",
"value": "1619"
},
"receiverBusinessIdentity": {
"qualifier": "ZZ",
"value": "REALMED"
}
},
"sendAgreement": {
"protocolSettings": {
"validationSettings": {
"validateCharacterSet": false,
"checkDuplicateInterchangeControlNumber": false,
"interchangeControlNumberValidityDays": 30,
"checkDuplicateGroupControlNumber": false,
"checkDuplicateTransactionSetControlNumber": false,
"validateEDITypes": true,
"validateXSDTypes": false,
"allowLeadingAndTrailingSpacesAndZeroes": false,
"trimLeadingAndTrailingSpacesAndZeroes": false,
"trailingSeparatorPolicy": "NotAllowed"
},
"framingSettings": {
"dataElementSeparator": 42,
"componentSeparator": 58,
"replaceSeparatorsInPayload": false,
"replaceCharacter": 36,
"segmentTerminator": 126,
"characterSet": "UTF8",
"segmentTerminatorSuffix": "None"
},
"envelopeSettings": {
"controlStandardsId": 85,
"useControlStandardsIdAsRepetitionCharacter": false,
"senderApplicationId": "BTS-SENDER",
"receiverApplicationId": "RECEIVE-APP",
"controlVersionNumber": "00401",
"interchangeControlNumberLowerBound": 1,
"interchangeControlNumberUpperBound": 999999999,
"rolloverInterchangeControlNumber": true,
"enableDefaultGroupHeaders": true,
"groupControlNumberLowerBound": 1,
"groupControlNumberUpperBound": 999999999,
"rolloverGroupControlNumber": true,
"groupHeaderAgencyCode": "T",
"groupHeaderVersion": "00401",
"transactionSetControlNumberLowerBound": 1,
"transactionSetControlNumberUpperBound": 999999999,
"rolloverTransactionSetControlNumber": true,
"overwriteExistingTransactionSetControlNumber": true,
"groupHeaderDateFormat": "CCYYMMDD",
"groupHeaderTimeFormat": "HHMM",
"usageIndicator": "Test"
},
"acknowledgementSettings": {
"needTechnicalAcknowledgement": false,
"batchTechnicalAcknowledgements": true,
"needFunctionalAcknowledgement": false,
"functionalAcknowledgementVersion": "00401",
"batchFunctionalAcknowledgements": true,
"needImplementationAcknowledgement": false,
"batchImplementationAcknowledgements": false,
"needLoopForValidMessages": false,
"sendSynchronousAcknowledgement": true,
"acknowledgementControlNumberLowerBound": 1,
"acknowledgementControlNumberUpperBound": 999999999,
"rolloverAcknowledgementControlNumber": true
},
"messageFilter": {
"messageFilterType": "Exclude"
},
"securitySettings": {
"authorizationQualifier": "00",
"securityQualifier": "00"
},
"processingSettings": {
"maskSecurityInfo": true,
"convertImpliedDecimal": false,
"preserveInterchange": false,
"suspendInterchangeOnError": false,
"createEmptyXmlTagsForTrailingSeparators": true,
"useDotAsDecimalSeparator": false
},
"envelopeOverrides": [],
"validationOverrides": [],
"messageFilterList": [],
"schemaReferences": [],
"x12DelimiterOverrides": []
},
"senderBusinessIdentity": {
"qualifier": "ZZ",
"value": "1619"
},
"receiverBusinessIdentity": {
"qualifier": "ZZ",
"value": "REALMED"
}
}
}
},
"createdTime": "2019-02-19T09:20:22.7534396Z",
"changedTime": "2019-02-21T06:51:37.8640884Z"
},
"id": "/subscriptions/subscriptionId/resourceGroups/TestRG/providers/Microsoft.Logic/integrationAccounts/Test_Integration/agreements/Send_Rec_Agreement",
"name": "Send_Rec_Agreement",
"type": "Microsoft.Logic/integrationAccounts/agreements"
}
3。逻辑应用程序 - 代码
3. Logic App - Code
{
"$connections": {
"value": {
"gmail": {
"connectionId": "/subscriptions/subscriptionId/resourceGroups/TestRG/providers/Microsoft.Web/connections/gmail",
"connectionName": "gmail",
"id": "/subscriptions/SubscriptionId/providers/Microsoft.Web/locations/centralindia/managedApis/gmail"
},
"sftp": {
"connectionId": "/subscriptions/SubscriptionId/resourceGroups/TestRG/providers/Microsoft.Web/connections/sftp",
"connectionName": "sftp",
"id": "/subscriptions/SubscriptionId/providers/Microsoft.Web/locations/centralindia/managedApis/sftp"
},
"x12": {
"connectionId": "/subscriptions/SubscriptionId/resourceGroups/TestRG/providers/Microsoft.Web/connections/x12",
"connectionName": "x12",
"id": "/subscriptions/SubscriptionId/providers/Microsoft.Web/locations/centralindia/managedApis/x12"
}
}
},
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"Decode_X12_message": {
"inputs": {
"body": "@triggerBody()",
"host": {
"connection": {
"name": "@parameters('$connections')['x12']['connectionId']"
}
},
"method": "post",
"path": "/decode"
},
"runAfter": {},
"type": "ApiConnection"
},
"For_each": {
"actions": {
"Send_email": {
"inputs": {
"body": {
"Body": "@{xml(base64ToBinary(item()?['Payload']))}",
"Subject": "Test Email",
"To": "<EmailID>\n"
},
"host": {
"connection": {
"name": "@parameters('$connections')['gmail']['connectionId']"
}
},
"method": "post",
"path": "/Mail"
},
"runAfter": {},
"type": "ApiConnection"
}
},
"foreach": "@body('Decode_X12_message')?['BadMessages']",
"runAfter": {
"Decode_X12_message": [
"Succeeded"
]
},
"type": "Foreach"
}
},
"contentVersion": "1.0.0.0",
"outputs": {},
"parameters": {
"$connections": {
"defaultValue": {},
"type": "Object"
}
},
"triggers": {
"When_a_file_is_added_or_modified": {
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sftp']['connectionId']"
}
},
"method": "get",
"path": "/datasets/default/triggers/onupdatedfile",
"queries": {
"folderId": "L1NGVFA=",
"includeFileContent": true,
"inferContentType": true,
"queryParametersSingleEncoded": true
}
},
"metadata": {
"L1NGVFA=": "/SFTP",
"L1NGVFAvRGF0YUludGVyY2hhbmdl": "/SFTP/DataInterchange"
},
"recurrence": {
"frequency": "Minute",
"interval": 1
},
"type": "ApiConnection"
}
}
}
}
推荐答案
Hello Shankar，
Hello Shankar,
我已删除敏感信息编辑了您的帖子喜欢个人电子邮件ID和SubscriptionID。我鼓励你不要在公共论坛上发布敏感的私人信息。
I have edited your post by removing sensitive information like personal email ID and SubscriptionID. I would encourage you not to post sensitive private information over the public forums.
此外，这个问题似乎是一个特定的环境，需要深入调查。你有Azure支持计划吗？如果没有，我可以创建一次性事故单，以通过支持请求正式跟踪此问题。请
将您的Azure订阅GUID发送到Microsoft dot com的AzCommunity，并将返回说明以便执行后续步骤。
Additionally, This issue seems to be a environment specific which requires a deep investigation. do you have an Azure Support Plan? If not, I can have a one-time incident ticket created to have this issue officially tracked via a support request. Please send your Azure Subscription GUID to AzCommunity at Microsoft dot com and instructions will be sent back for next steps.
这篇关于EDI 837 ||的模式验证期间出现X12错误Azure Logic应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
