LogicAppsUX
LogicAppsUX copied to clipboard
Azure
AxiosError: Request failed with status code 401
Severity
P1 - Critical (Blocking production)
Describe the Bug with repro steps
Workflow not saved. Error in fetching connection keys for /subscriptions/7834065d-5016-45d3-8675-b2e1dbb0693c/resourceGroups/rg-middleware-qa/providers/Microsoft.Web/connections/office365. AxiosError: Request failed with status code 401
What type of Logic App Is this happening in?
Standard (VSCode)
Are you experiencing a regression?
No response
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#",
"contentVersion": "1.0.0.0",
"actions": {
"read_XUI": {
"type": "ServiceProvider",
"inputs": {
"parameters": {
"containerName": "@triggerBody()?['containerInfo']?['name']",
"blobName": "@triggerBody()?['name']"
},
"serviceProviderConfiguration": {
"connectionName": "AzureBlob",
"operationId": "readBlob",
"serviceProviderId": "/serviceProviders/AzureBlob"
}
},
"runAfter": {}
},
"parseJson_XUI": {
"type": "ParseJson",
"inputs": {
"content": "@outputs('compose_XUI')",
"schema": {
"properties": {
"universalInterchange": {
"type": "string"
},
"universalShipment": {
"type": "string"
}
},
"type": "object"
}
},
"runAfter": {
"compose_XUI": [
"SUCCEEDED"
]
}
},
"EDI214Process": {
"type": "Scope",
"actions": {
"transform_xus_to_intermediate_edi_214": {
"type": "Xslt",
"inputs": {
"content": "@body('parseJson_XUI')?['universalShipment']",
"map": {
"source": "LogicApp",
"name": "Map_Enphase_Universalshipment_To_IntermediateXML.xslt"
}
},
"runAfter": {
"uploadBlob_XUI": [
"SUCCEEDED"
]
}
},
"compose_intermediate_edi_214": {
"type": "Compose",
"inputs": "@body('transform_xus_to_intermediate_edi_214')",
"runAfter": {
"transform_xus_to_intermediate_edi_214": [
"SUCCEEDED"
]
}
},
"Transform_Intermediate_EDI_214_TO_EDI_214": {
"type": "Xslt",
"inputs": {
"content": "@outputs('compose_intermediate_edi_214')",
"map": {
"source": "LogicApp",
"name": "Map_Enphase_IntermediateXML_To_EDI_214.xslt"
}
},
"runAfter": {
"compose_intermediate_edi_214": [
"SUCCEEDED"
]
}
},
"X12_Encode": {
"type": "X12Encode",
"inputs": {
"messageToEncode": "@body('Transform_Intermediate_EDI_214_TO_EDI_214')",
"agreementName": "PGL-ENPHASE-X12"
},
"runAfter": {
"Transform_Intermediate_EDI_214_TO_EDI_214": [
"SUCCEEDED"
]
}
},
"parseJson_XUS": {
"type": "ParseJson",
"inputs": {
"content": "@outputs('compose_XUS')",
"schema": {
"type": "object",
"properties": {
"forwardingShipmentNumber": {
"type": "string"
},
"houseWayBillNumber": {
"type": "string"
},
"shipmentOrderRefNumber": {
"type": "string"
},
"workUnitNumber": {
"type": "string"
},
"statuscode": {
"type": "string"
}
}
}
},
"runAfter": {
"compose_XUS": [
"SUCCEEDED"
]
}
},
"compose_archiveMetadata": {
"type": "Compose",
"inputs": {
"archive_BlobDirectory": "@{concat(body('parseJson_XUS')?['workOrderNumber'], '/')}",
"universalInterchange_ArchiveFilename": "@{concat('XUI_', variables('str_WorkflowRunID'), '.xml')}",
"forwardingShipmentNumber": "@{xpath(\r\n xml(body('parseJson_XUI')?['universalShipment']),\r\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"DataContext\"]/*[local-name()=\"DataSourceCollection\"]/*[local-name()=\"DataSource\"]/*[local-name()=\"Type\"][text()=\"ForwardingShipment\"]/../*[local-name()=\"Key\"])'\r\n)\r\n}",
"houseWayBillNumber": "@{xpath(\r\n xml(body('parseJson_XUI')?['universalShipment']),\r\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"WayBillType\"]/*[local-name()=\"Code\"][text()=\"HWB\"]/../../*[local-name()=\"WayBillNumber\"])'\r\n)\r\n}",
"shipmentOrderRefNumber": "@{xpath(\r\n xml(body('parseJson_XUI')?['universalShipment']),\r\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"LocalProcessing\"]/*[local-name()=\"OrderNumberCollection\"]/*[local-name()=\"OrderNumber\"]/*[local-name()=\"OrderReference\"])'\r\n)\r\n}",
"workUnitNumber": "@{xpath(\r\n xml(body('parseJson_XUI')?['universalShipment']),\r\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"CustomizedFieldCollection\"]/*[local-name()=\"CustomizedField\"][*[local-name()=\"Key\"]=\"Work Unit Number\"]/*[local-name()=\"Value\"])'\r\n)\r\n}",
"statuscode": "@{xpath(\r\n xml(body('parseJson_XUI')?['universalShipment']),\r\n 'string(substring(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"DataContext\"]/*[local-name()=\"ActionPurpose\"]/*[local-name()=\"Code\"],1,2))'\r\n)\r\n\r\n}"
},
"runAfter": {
"parseJson_XUS": [
"SUCCEEDED"
]
}
},
"parseJson_archiveMetadata": {
"type": "ParseJson",
"inputs": {
"content": "@outputs('compose_archiveMetadata')",
"schema": {
"type": "object",
"properties": {
"archive_BlobDirectory": {
"type": "string"
},
"universalInterchange_ArchiveFilename": {
"type": "string"
},
"forwardingShipmentNumber": {
"type": "string"
},
"houseWayBillNumber": {
"type": "string"
},
"shipmentOrderRefNumber": {
"type": "string"
},
"workUnitNumber": {
"type": "string"
},
"statuscode": {
"type": "string"
}
}
}
},
"runAfter": {
"compose_archiveMetadata": [
"SUCCEEDED"
]
}
},
"uploadBlob_XUI": {
"type": "ServiceProvider",
"inputs": {
"parameters": {
"containerName": "archive",
"blobName": "@concat(body('parseJson_archiveMetadata')?['archive_BlobDirectory'], body('parseJson_archiveMetadata')?['universalInterchange_ArchiveFilename'])",
"content": "@body('read_XUI')?['content']",
"overrideIfExists": "true"
},
"serviceProviderConfiguration": {
"connectionName": "AzureBlob",
"operationId": "uploadBlob",
"serviceProviderId": "/serviceProviders/AzureBlob"
}
},
"runAfter": {
"parseJason_mailsetting": [
"SUCCEEDED"
]
}
},
"EDI_214": {
"type": "Compose",
"inputs": "@xpath(xml(body('parseJson_XUI')?['universalShipment']), 'string(//*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"DataContext\"]/*[local-name()=\"ActionPurpose\"]/*[local-name()=\"Code\"])')",
"runAfter": {
"X12_Encode": [
"SUCCEEDED"
]
}
},
"compose_mailsetting": {
"type": "Compose",
"inputs": {
"cc_FailureAlerts": "[email protected], [email protected]",
"cc_SuccessAlerts": "[email protected], [email protected] ",
"client_Mail_Ids": "[email protected]",
"to_FailureAlerts": "[email protected], [email protected] ",
"to_SuccessAlerts": "[email protected], [email protected]"
},
"runAfter": {
"parseJson_archiveMetadata": [
"SUCCEEDED"
]
}
},
"parseJason_mailsetting": {
"type": "ParseJson",
"inputs": {
"content": "@outputs('compose_mailsetting')",
"schema": {
"properties": {
"cc_FailureAlerts": {
"type": "string"
},
"cc_SuccessAlerts": {
"type": "string"
},
"client_Mail_Ids": {
"type": "string"
},
"to_FailureAlerts": {
"type": "string"
},
"to_SuccessAlerts": {
"type": "string"
}
},
"type": "object"
}
},
"runAfter": {
"compose_mailsetting": [
"SUCCEEDED"
]
}
},
"compose_XUS": {
"type": "Compose",
"inputs": {
"forwardingShipmentNumber": "@{xpath(\n xml(body('parseJson_XUI')?['universalShipment']),\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"DataContext\"]/*[local-name()=\"DataSourceCollection\"]/*[local-name()=\"DataSource\"]/*[local-name()=\"Type\"][text()=\"ForwardingShipment\"]/../*[local-name()=\"Key\"])'\n)\n}",
"houseWayBillNumber": "@{xpath(\n xml(body('parseJson_XUI')?['universalShipment']),\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"WayBillType\"]/*[local-name()=\"Code\"][text()=\"HWB\"]/../../*[local-name()=\"WayBillNumber\"])'\n)\n}",
"shipmentOrderRefNumber": "@{xpath(\n xml(body('parseJson_XUI')?['universalShipment']),\n '/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"LocalProcessing\"]/*[local-name()=\"OrderNumberCollection\"]/*[local-name()=\"OrderNumber\"]/*[local-name()=\"OrderReference\"]'\n)\n}",
"workUnitNumber": "@{xpath(\n xml(body('parseJson_XUI')?['universalShipment']),\n 'string(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"CustomizedFieldCollection\"]/*[local-name()=\"CustomizedField\"][*[local-name()=\"Key\"]=\"Work Unit Number\"]/*[local-name()=\"Value\"])'\n)\n}",
"statuscode": "@{xpath(\n xml(body('parseJson_XUI')?['universalShipment']),\n 'string(substring(/*[local-name()=\"UniversalShipment\"]/*[local-name()=\"Shipment\"]/*[local-name()=\"DataContext\"]/*[local-name()=\"ActionPurpose\"]/*[local-name()=\"Code\"],1,2))'\n)\n\n}"
}
},
"archive_EDI214_": {
"type": "ServiceProvider",
"inputs": {
"parameters": {
"containerName": "archive",
"blobName": "@concat(\r\n body('parseJson_archiveMetadata')?['archive_BlobDirectory'],\r\n body('X12_Encode')?['agreement']?['senderIdentifier'], '_',\r\n body('X12_Encode')?['agreement']?['receiverIdentifier'], '_',\r\n outputs('EDI_214'), '_',\r\n body('X12_Encode')?['interchangeProperties']?['interchangeControlNumber']\r\n)",
"content": "@body('X12_Encode')['encodedMessageContent']"
},
"serviceProviderConfiguration": {
"connectionName": "AzureBlob",
"operationId": "uploadBlob",
"serviceProviderId": "/serviceProviders/AzureBlob"
}
},
"runAfter": {
"Send_Encoded_EDI214_To_Enphase": [
"SUCCEEDED"
]
}
},
"Send_Encoded_EDI214_To_Enphase": {
"type": "ServiceProvider",
"inputs": {
"parameters": {
"filePath": "@concat(parameters('enphase_sftp-outbound-directory'),'/',\r\n body('X12_Encode')['agreement']['senderIdentifier'],\r\n '_',\r\n body('X12_Encode')['agreement']['receiverIdentifier'],\r\n '_',\r\n string(outputs('EDI_214')),\r\n '_',\r\n 'edi214',\r\n '_',\r\n body('X12_Encode')['interchangeProperties']['interchangeControlNumber'],\r\n '.edi'\r\n)\r\n",
"overWriteFileIfExists": true,
"content": "@body('X12_Encode')['encodedMessageContent']"
},
"serviceProviderConfiguration": {
"connectionName": "Sftp-2",
"operationId": "uploadFileContent",
"serviceProviderId": "/serviceProviders/Sftp"
}
},
"runAfter": {
"EDI_214": [
"SUCCEEDED"
]
}
}
},
"runAfter": {
"parseJson_XUI": [
"SUCCEEDED"
]
}
},
"CatchException": {
"type": "Scope",
"actions": {
"FilterArrayOtherThanSuccess": {
"type": "Query",
"inputs": {
"from": "@result('EDI214Process')",
"where": "@not(equals(item()['status'],'Succeeded'))"
}
},
"CheckEDI214Process": {
"type": "If",
"expression": {
"and": [
{
"equals": [
"@length(body('FilterArrayOtherThanSuccess'))",
0
]
}
]
},
"actions": {
"append_successLogInfo": {
"type": "SetVariable",
"inputs": {
"name": "arr_LogInfo",
"value": {
"requestInTime": "@{formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Pacific Standard Time'), 'yyyy-MM-dd HH:mm:ss')}",
"workFlowName": "@{variables('str_WorkFlowName')}",
"workFlowRunId": "@{variables('str_WorkflowRunID')}",
"status": "Success",
"universalInterchange_ArchiveFilename": "@{concat('XUI_', variables('str_WorkflowRunID'), '.xml')}",
"forwardingShipmentNumber": "@{body('parseJson_archiveMetadata')?['forwardingShipmentNumber']}",
"houseWayBillNumber": "@{body('parseJson_archiveMetadata')?['houseWayBillNumber']}",
"shipmentOrderRefNumber": "@{body('parseJson_archiveMetadata')?['shipmentOrderRefNumber']}",
"workUnitNumber": "@{body('parseJson_archiveMetadata')?['workUnitNumber']}",
"statuscode": "@{body('parseJson_archiveMetadata')?['statuscode']}",
"ip_XUI_ArchiveFilename": "@{concat(body('parseJson_archiveMetadata')?['archive_BlobDirectory'], body('parseJson_archiveMetadata')?['universalInterchange_ArchiveFilename'])\r\n }",
"ip_XUI_FileCreationTime": " @{triggerBody()?['properties']?['creationTime']}",
"ip_XUI_Filename": "@{triggerBody()?['name']}",
"op_EDI214_FileName": "@{body('X12_Encode')['agreement']['senderIdentifier']}_@{body('X12_Encode')['agreement']['receiverIdentifier']}_@{outputs('EDI_214')}_edi214_@{body('X12_Encode')['interchangeProperties']['interchangeControlNumber']}.edi"
}
}
},
"Parse_(V1)": {
"type": "ParseJson",
"inputs": {
"content": "@variables('arr_LogInfo')",
"schema": {
"type": "object",
"properties": {
"requestInTime": {
"type": "string"
},
"workFlowName": {
"type": "string"
},
"workFlowRunId": {
"type": "string"
},
"status": {
"type": "string"
},
"universalInterchange_ArchiveFilename": {
"type": "string"
},
"forwardingShipmentNumber": {
"type": "string"
},
"houseWayBillNumber": {
"type": "string"
},
"shipmentOrderRefNumber": {
"type": "string"
},
"workUnitNumber": {
"type": "string"
},
"statuscode": {
"type": "string"
},
"ip_XUI_ArchiveFilename": {
"type": "string"
},
"ip_XUI_FileCreationTime": {
"type": "string"
},
"ip_XUI_Filename": {
"type": "string"
},
"op_EDI214_FileName": {
"type": "string"
}
}
}
},
"runAfter": {
"append_successLogInfo": [
"SUCCEEDED"
]
}
},
"Set_-_logger-Success": {
"type": "SetVariable",
"inputs": {
"name": "logger",
"value": [
{
"ReqInTime": "@{utcNow()}",
"WorkflowName": "@{workflow()?['name']}",
"WorkflowRunID": "@{workflow().run.name}",
"LogicAppName": "pgl-logic-app-prod",
"Status": "Success",
"Message": {
"universalInterchange_ArchiveFilename": "@{concat('XUI_', variables('str_WorkflowRunID'), '.xml')}",
"forwardingShipmentNumber": "@{body('parseJson_archiveMetadata')?['forwardingShipmentNumber']}",
"houseWayBillNumber": "@{body('parseJson_archiveMetadata')?['houseWayBillNumber']}",
"shipmentOrderRefNumber": "@{body('parseJson_archiveMetadata')?['shipmentOrderRefNumber']}",
"workUnitNumber": "@{body('parseJson_archiveMetadata')?['workUnitNumber']}",
"statuscode": "@{body('parseJson_archiveMetadata')?['statuscode']}",
"ip_XUI_ArchiveFilename": "@{concat(body('parseJson_archiveMetadata')?['archive_BlobDirectory'], body('parseJson_archiveMetadata')?['universalInterchange_ArchiveFilename'])}",
"ip_XUI_FileCreationTime": "@{triggerBody()?['properties']?['creationTime']}",
"ip_XUI_Filename": "@{triggerBody()?['name']}",
"op_EDI214_FileName": "@{body('X12_Encode')['agreement']['senderIdentifier']}_@{body('X12_Encode')['agreement']['receiverIdentifier']}_@{outputs('EDI_214')}_edi214_@{body('X12_Encode')['interchangeProperties']['interchangeControlNumber']}.edi",
"Payload": {
"transform_xus_to_intermediate_edi_214": {
"Inputs": "@{outputs('compose_XUS')}",
"Outputs": "@{body('transform_xus_to_intermediate_edi_214')}"
},
"Transform_Intermediate_EDI_214_to_EDI_214": {
"Inputs": "@{outputs('compose_intermediate_edi_214')}",
"Outputs": "@{body('Transform_Intermediate_EDI_214_TO_EDI_214')}"
},
"workflow": {
"Inputs": "@{outputs('compose_XUI')}",
"Outputs": "@{body('X12_Encode')['encodedMessageContent']}"
}
}
}
}
]
}
},
"Parse_-_logger-Success": {
"type": "ParseJson",
"inputs": {
"content": "@variables('logger')",
"schema": {
"type": "array",
"items": {
"type": "object",
"properties": {
"ReqInTime": {
"type": "string"
},
"WorkflowName": {
"type": "string"
},
"WorkflowRunID": {
"type": "string"
},
"LogicAppName": {
"type": "string"
},
"Status": {
"type": "string"
},
"Message": {
"type": "object",
"properties": {
"universalInterchange_ArchiveFilename": {
"type": "string"
},
"forwardingShipmentNumber": {
"type": "string"
},
"houseWayBillNumber": {
"type": "string"
},
"shipmentOrderRefNumber": {
"type": "string"
},
"workUnitNumber": {
"type": "string"
},
"statuscode": {
"type": "string"
},
"ip_XUI_ArchiveFilename": {
"type": "string"
},
"ip_XUI_FileCreationTime": {
"type": "string"
},
"ip_XUI_Filename": {
"type": "string"
},
"op_EDI214_FileName": {
"type": "string"
},
"Payload": {
"type": "object",
"properties": {
"transform_xus_to_intermediate_edi_214": {
"type": "object",
"properties": {
"Inputs": {
"type": "string"
},
"Outputs": {
"type": "string"
}
}
},
"Transform_Intermediate_EDI_214_to_EDI_214": {
"type": "object",
"properties": {
"Inputs": {
"type": "string"
},
"Outputs": {
"type": "string"
}
}
},
"workflow": {
"type": "object",
"properties": {
"Inputs": {
"type": "string"
},
"Outputs": {
"type": "string"
}
}
}
}
}
}
}
},
"required": [
"ReqInTime",
"WorkflowName",
"WorkflowRunID",
"LogicAppName",
"Status",
"Message"
]
}
}
},
"runAfter": {
"Set_-_logger-Success": [
"SUCCEEDED"
]
}
}
},
"else": {
"actions": {
"append_failureLogInfo": {
"type": "SetVariable",
"inputs": {
"name": "arr_LogInfo",
"value": {
"requestInTime": "@{formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Pacific Standard Time'), 'yyyy-MM-dd HH:mm:ss')}",
"workFlowName": "@{variables('str_WorkFlowName')}",
"workFlowRunId": "@{variables('str_WorkflowRunID')}",
"status": "Failure",
"universalInterchange_ArchiveFilename": "@{concat('XUI_', variables('str_WorkflowRunID'), '.xml')}",
"forwardingShipmentNumber": "@{body('parseJson_archiveMetadata')?['forwardingShipmentNumber']}",
"houseWayBillNumber": "@{body('parseJson_archiveMetadata')?['houseWayBillNumber']}",
"shipmentOrderRefNumber": "@{body('parseJson_archiveMetadata')?['shipmentOrderRefNumber']}",
"workUnitNumber": "@{body('parseJson_archiveMetadata')?['workUnitNumber']}",
"statuscode": "@{body('parseJson_archiveMetadata')?['statuscode']}",
"ip_XUI_ArchiveFilename": "@{concat(body('parseJson_archiveMetadata')?['archive_BlobDirectory'], body('parseJson_archiveMetadata')?['universalInterchange_ArchiveFilename'])\n }",
"ip_XUI_FileCreationTime": " @{triggerBody()?['properties']?['creationTime']}",
"ip_XUI_Filename": "@{triggerBody()?['name']}",
"op_EDI214_FileName": "@{body('X12_Encode')['agreement']['senderIdentifier']}_@{body('X12_Encode')['agreement']['receiverIdentifier']}_@{outputs('EDI_214')}_edi214_@{body('X12_Encode')['interchangeProperties']['interchangeControlNumber']}.edi"
}
}
},
"Send_Failuremailalert": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"referenceName": "office365"
}
},
"method": "post",
"body": {
"To": "@body('parseJason_mailsetting')?['to_FailureAlerts']",
"Subject": "[PGL] [ENPHASE] [SEND214] - Failure",
"Body": "<p class=\"editor-paragraph\">Workflow Name: @{variables('str_WorkFlowName')}<br>Workflow Run Id: @{variables('str_WorkflowRunID')}<br><br><br>Error occurred in one or more actions while processing the create work order.<br><br>See https://pgl.enkaypro.com/bam for more details.<br>Thank you!</p>",
"Importance": "Normal"
},
"path": "/v2/Mail"
}
},
"Parse_failurelogInfo": {
"type": "ParseJson",
"inputs": {
"content": "@variables('arr_LogInfo')",
"schema": {
"type": "object",
"properties": {
"requestInTime": {
"type": "string"
},
"workFlowName": {
"type": "string"
},
"workFlowRunId": {
"type": "string"
},
"status": {
"type": "string"
},
"universalInterchange_ArchiveFilename": {
"type": "string"
},
"forwardingShipmentNumber": {
"type": "string"
},
"houseWayBillNumber": {
"type": "string"
},
"shipmentOrderRefNumber": {
"type": "string"
},
"workUnitNumber": {
"type": "string"
},
"statuscode": {
"type": "string"
},
"ip_XUI_ArchiveFilename": {
"type": "string"
},
"ip_XUI_FileCreationTime": {
"type": "string"
},
"ip_XUI_Filename": {
"type": "string"
},
"op_EDI214_FileName": {
"type": "string"
}
}
}
},
"runAfter": {
"append_failureLogInfo": [
"SUCCEEDED"
]
}
},
"Set_-_logger_-failure": {
"type": "SetVariable",
"inputs": {
"name": "logger",
"value": [
{
"ReqInTime": "@{utcNow()}",
"WorkflowName": "@{workflow()?['name']}",
"WorkflowRunID": "@{workflow().run.name}",
"LogicAppName": "pgl-logic-app-prod",
"Status": "Failure",
"Message": {
"universalInterchange_ArchiveFilename": "@{concat('XUI_', variables('str_WorkflowRunID'), '.xml')}",
"forwardingShipmentNumber": "@{body('parseJson_archiveMetadata')?['forwardingShipmentNumber']}",
"houseWayBillNumber": "@{body('parseJson_archiveMetadata')?['houseWayBillNumber']}",
"shipmentOrderRefNumber": "@{body('parseJson_archiveMetadata')?['shipmentOrderRefNumber']}",
"workUnitNumber": "@{body('parseJson_archiveMetadata')?['workUnitNumber']}",
"statuscode": "@{body('parseJson_archiveMetadata')?['statuscode']}",
"ip_XUI_ArchiveFilename": "@{concat(body('parseJson_archiveMetadata')?['archive_BlobDirectory'], body('parseJson_archiveMetadata')?['universalInterchange_ArchiveFilename'])}",
"ip_XUI_FileCreationTime": "@{triggerBody()?['properties']?['creationTime']}",
"ip_XUI_Filename": "@{triggerBody()?['name']}",
"op_EDI214_FileName": "@{body('X12_Encode')['agreement']['senderIdentifier']}_@{body('X12_Encode')['agreement']['receiverIdentifier']}_@{outputs('EDI_214')}_edi214_@{body('X12_Encode')['interchangeProperties']['interchangeControlNumber']}.edi",
"Payload": {
"transform_xus_to_intermediate_edi_214": {
"Inputs": "@{outputs('compose_XUS')}",
"Outputs": "@{body('transform_xus_to_intermediate_edi_214')}"
},
"Transform_Intermediate_EDI_214_to_EDI_214": {
"Inputs": "@{outputs('compose_intermediate_edi_214')}",
"Outputs": "@{body('Transform_Intermediate_EDI_214_TO_EDI_214')}"
},
"workflow": {
"Inputs": "@{outputs('compose_XUI')}",
"Outputs": "@{body('X12_Encode')['encodedMessageContent']}"
}
}
}
}
]
}
},
"Parse_-_logger_-Failure": {
"type": "ParseJson",
"inputs": {
"content": "@variables('logger')",
"schema": {
"type": "array",
"items": {
"type": "object",
"properties": {
"ReqInTime": {
"type": "string"
},
"WorkflowName": {
"type": "string"
},
"WorkflowRunID": {
"type": "string"
},
"LogicAppName": {
"type": "string"
},
"Status": {
"type": "string"
},
"Message": {
"type": "object",
"properties": {
"universalInterchange_ArchiveFilename": {
"type": "string"
},
"forwardingShipmentNumber": {
"type": "string"
},
"houseWayBillNumber": {
"type": "string"
},
"shipmentOrderRefNumber": {
"type": "string"
},
"workUnitNumber": {
"type": "string"
},
"statuscode": {
"type": "string"
},
"ip_XUI_ArchiveFilename": {
"type": "string"
},
"ip_XUI_FileCreationTime": {
"type": "string"
},
"ip_XUI_Filename": {
"type": "string"
},
"op_EDI214_FileName": {
"type": "string"
},
"Payload": {
"type": "object",
"properties": {
"transform_xus_to_intermediate_edi_214": {
"type": "object",
"properties": {
"Inputs": {
"type": "string"
},
"Outputs": {
"type": "string"
}
}
},
"Transform_Intermediate_EDI_214_to_EDI_214": {
"type": "object",
"properties": {
"Inputs": {
"type": "string"
},
"Outputs": {
"type": "string"
}
}
},
"workflow": {
"type": "object",
"properties": {
"Inputs": {
"type": "string"
},
"Outputs": {
"type": "string"
}
}
}
}
}
}
}
},
"required": [
"ReqInTime",
"WorkflowName",
"WorkflowRunID",
"LogicAppName",
"Status",
"Message"
]
}
}
},
"runAfter": {
"Set_-_logger_-failure": [
"SUCCEEDED"
]
}
}
}
},
"runAfter": {
"FilterArrayOtherThanSuccess": [
"SUCCEEDED"
]
}
}
},
"runAfter": {
"EDI214Process": [
"SUCCEEDED"
]
}
},
"init_workflowRunID": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "str_WorkflowRunID",
"type": "string",
"value": "@workflow().run.name"
}
]
},
"runAfter": {
"read_XUI": [
"SUCCEEDED"
]
}
},
"init_logInfo": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "arr_LogInfo",
"type": "object"
}
]
},
"runAfter": {
"init_workflowName": [
"SUCCEEDED"
]
}
},
"init_workflowName": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "str_WorkFlowName",
"type": "string",
"value": "@workflow()['name']"
}
]
},
"runAfter": {
"init_workflowRunID": [
"SUCCEEDED"
]
}
},
"compose_XUI": {
"type": "Compose",
"inputs": {
"universalInterchange": "@{body('read_XUI')?['content']}",
"universalShipment": "@{decodeBase64(xpath(xml(body('read_XUI')?['content']), '/*[local-name()=\"UniversalInterchange\"]/*[local-name()=\"Body\"]/*[local-name()=\"UniversalShipment\"]')?[0]?['$content'])}"
},
"runAfter": {
"Init_logger": [
"SUCCEEDED"
]
}
},
"Init_logger": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "logger",
"type": "array"
}
]
},
"runAfter": {
"init_logInfo": [
"SUCCEEDED"
]
}
}
},
"outputs": {},
"triggers": {
"rcv_XUIFile": {
"type": "ServiceProvider",
"inputs": {
"parameters": {
"path": "cargowise-eadaptor-outboundfiles/ENPHASE/EDI214/{blobName}.xml"
},
"serviceProviderConfiguration": {
"connectionName": "AzureBlob",
"operationId": "whenABlobIsAddedOrModified",
"serviceProviderId": "/serviceProviders/AzureBlob"
}
}
}
}
},
"kind": "Stateful"
}
Screenshots or Videos
Environment
- VS Code version [1.105.1]
Additional context
No response
It looks like you have MSI auth configured for each of the connections which we don't yet support for local development. Can you try updating each connection to use connection key-based auth instead?
