LogicApp Datamapper not mapping correctly #5698
Assignees
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the Bug with repro steps
The issue lies with the datamapper not transforming the nested elements and lists correctly.
Checks and FOR loops had to be added manually to make the mapping work.
I cannot add the files as this richtext editor does not allow XML and XSLT files.
I cant add the files as text either since that exceeds the character limit of the issue form.
To reproduce you would need to make the map with datamapper and test it with the payload. The map will add COVERAGE even though it is empty in some parts of the payload.
What type of Logic App Is this happening in?
Consumption (Portal)
Which operating system are you using?
Windows
Are you using new designer or old designer
New Designer
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": { "Parse_ServiceContract_to_JSON": { "type": "ParseJson", "inputs": { "content": "@json(xml(base64ToString(triggerBody()?['contentData'])))", "schema": { "type": "object", "properties": { "ServiceContractRequest": { "type": "object", "properties": { "INTEGRATION_HEADER": { "type": "object", "properties": { "MessageID": { "type": "string" }, "CorrelationID": { "type": "string" }, "ResponseLocation": { "type": "string" }, "RequestedOperation": { "type": "string" }, "ReceiverSystem": { "type": "string" }, "SenderSystem": { "type": "string" }, "SentTimeStamp": { "type": "string" } } }, "SCINTRF": { "type": "object", "properties": { "SC_HEADER": { "type": "object", "properties": { "ORIG_SYSTEM_REFERENCE": { "type": "string" }, "COST_CENTER": { "type": "string" }, "START_DATE": { "type": "string" }, "END_DATE": { "type": "string" }, "VESSEL_ID": { "type": "string" }, "CURRENCY_CODE": { "type": "string" }, "PO_NUMBER": { "type": "string" }, "SHOW_OWNER_ON_INVOICE_FLAG": { "type": "string" }, "NOTE": { "type": "string" }, "COMMENTS": { "type": "string" }, "PAYMENT_TERM_DAYS": { "type": "string" }, "PAYMENT_TERM_NAME": { "type": "string" }, "OECD_INFLATION_FLAG": { "type": "string" }, "DISCOUNT": { "type": "string" }, "INSTALMENT_DURATION": { "type": "string" }, "INSTALMENT_UOM": { "type": "string" }, "FIXED_INFLATION_RATE": { "type": "string" }, "RENEWAL_DATE": { "type": "string" }, "VESSEL_TYPE": { "type": "string" }, "CONTRACT_DOCUMENT_URL": { "type": "string" }, "CUSTOMERS": { "type": "object", "properties": { "CUSTOMER": { "type": "array", "items": { "type": "object", "properties": { "CUSTOMER_ID": { "type": "string" }, "CUSTOMER_ROLE": { "type": "string" } }, "required": [ "CUSTOMER_ID", "CUSTOMER_ROLE" ] } } } }, "SC_LINES": { "type": "object", "properties": { "SC_LINE": { "type": "array", "items": { "type": "object", "properties": { "LINE_NUMBER": { "type": "string" }, "CONTRACT_ITEM": { "type": "string" }, "LINE_AMOUNT": { "type": "string" }, "FEE_NUM": { "type": "string" }, "LINE_DISCOUNT": { "type": "string" }, "COVERAGE": { "type": "object", "properties": { "COVERAGE_NAME": { "type": "string" }, "BILLING_TYPES": { "type": "object", "properties": { "BILLING_TYPE": { "type": "array", "items": { "type": "object", "properties": { "BILLING_TYPE_NAME": { "type": "string" } }, "required": [ "BILLING_TYPE_NAME" ] } } } } } } }, "required": [ "LINE_NUMBER", "CONTRACT_ITEM", "LINE_AMOUNT", "LINE_DISCOUNT" ] } } } }, "PAYMENT_PLAN": { "type": "object", "properties": { "INSTALMENT": { "type": "array", "items": { "type": "object", "properties": { "INVOICE_DATE": { "type": "string" }, "INVOICE_AMOUNT": { "type": "string" } }, "required": [ "INVOICE_DATE", "INVOICE_AMOUNT" ] } } } } } } } }, "_xmlns:ns0": { "type": "string" }, "__prefix": { "type": "string" } } } } } }, "runAfter": {} }, "Initialize_transformedBody": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "transformedBody", "type": "string" } ] }, "runAfter": { "Parse_ServiceContract_to_JSON": [ "SUCCEEDED" ] } }, "Initialize_techResponse": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "techResponse", "type": "string" } ] }, "runAfter": { "Initialize_transformedBody": [ "SUCCEEDED" ] } }, "Initialize_fault": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "fault", "type": "string" } ] }, "runAfter": { "Initialize_techResponse": [ "SUCCEEDED" ] } }, "Initialize_customMessage": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "customMessage", "type": "string" } ] }, "runAfter": { "Initialize_fault": [ "SUCCEEDED" ] } }, "Try_Scope": { "type": "Scope", "actions": { "Transform_OFServiceContractRequest": { "type": "Xslt", "kind": "DataMapper", "inputs": { "content": "@xml(base64ToString(triggerBody()?['ContentData']))", "map": { "source": "LogicApp", "name": "servicecontract_api_oebsservicecontract.xslt" } } }, "transformedBody": { "type": "SetVariable", "inputs": { "name": "transformedBody", "value": "@{body('Transform_OFServiceContractRequest')}" }, "runAfter": { "Transform_OFServiceContractRequest": [ "SUCCEEDED" ] } }, "HTTP_TO_SOA": { "type": "Http", "inputs": { "uri": "@parameters('APIM_ServiceContract')", "method": "POST", "headers": { "Content-Type": "text/xml", "Ocp-Apim-Subscription-Key": "@{parameters('SOA_Subscription_Key')}" }, "body": "@variables('transformedBody')" }, "runAfter": { "transformedBody": [ "SUCCEEDED" ] }, "runtimeConfiguration": { "contentTransfer": { "transferMode": "Chunked" } } }, "If_StatusCode_200": { "type": "If", "expression": { "and": [ { "equals": [ "@outputs('HTTP_TO_SOA')?['statusCode']", 200 ] } ] }, "actions": { "Parse_techResponse_to_JSON": { "type": "ParseJson", "inputs": { "content": "@json(xml(body('HTTP_TO_SOA')))", "schema": { "type": "object", "properties": { "Envelope": { "type": "object", "properties": { "Header": { "type": "object", "properties": { "Action": { "type": "string" }, "MessageID": { "type": "string" }, "ReplyTo": { "type": "object", "properties": { "Address": { "type": "string" }, "ReferenceParameters": { "type": "object", "properties": { "tracking.ecid": { "type": "string" }, "tracking.FlowEventId": { "type": "integer" }, "tracking.FlowId": { "type": "integer" }, "tracking.CorrelationFlowId": { "type": "string" }, "tracking.quiescing.SCAEntityId": { "type": "integer" } } } } }, "FaultTo": { "type": "object", "properties": { "Address": { "type": "string" } } } } }, "Body": { "type": "object", "properties": { "TechResponse": { "type": "string" } } } } } } } } }, "techResponse": { "type": "SetVariable", "inputs": { "name": "techResponse", "value": "@{body('Parse_techResponse_to_JSON')['env:Envelope']['env:Body'].TechResponse['#text']}" }, "runAfter": { "Parse_techResponse_to_JSON": [ "SUCCEEDED" ] } }, "If_TechResponse_OK": { "type": "If", "expression": { "and": [ { "equals": [ "@variables('techResponse')", "OK" ] } ] }, "actions": {}, "else": { "actions": { "Transform_to_ErrorResponse": { "type": "Xslt", "kind": "DataMapper", "inputs": { "content": "@xml(base64ToString(triggerBody()?['ContentData']))", "map": { "source": "LogicApp", "name": "servicecontract_error_oebsservicecontractresponse.xslt" } } }, "Compose_add_ErrorDescription_TechResponse": { "type": "Compose", "inputs": "@xml(setProperty(json(xml(body('Transform_to_errorResponse'))),'ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE',setProperty(json(xml(body('Transform_to_errorResponse')))['ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE'],'ns0:SCINTRF_RESPONSE',setProperty(json(xml(body('Transform_to_errorResponse')))['ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE']['ns0:SCINTRF_RESPONSE'],'ns0:ERROR_MESSAGE',variables('techResponse')))))\r\n", "runAfter": { "Transform_to_ErrorResponse": [ "SUCCEEDED" ] } }, "Send_message_of_autoinvoice_response": { "type": "ApiConnection", "inputs": { "host": { "connection": { "referenceName": "servicebus" } }, "method": "post", "body": { "ContentData": "@{base64(outputs('Compose_add_ErrorDescription_TechResponse'))}", "ContentType": "text/xml", "Properties": { "ResponseLocation": "@{body('Parse_ServiceContract_to_JSON')?['ServiceContractRequest']?['INTEGRATION_HEADER']?['ResponseLocation']}", "ReceiverSystem": "@{body('Parse_ServiceContract_to_JSON')?['ServiceContractRequest']?['INTEGRATION_HEADER']?['SenderSystem']}" } }, "path": "/@{encodeURIComponent(encodeURIComponent('of_servicecontract'))}/messages", "queries": { "systemProperties": "None" } }, "runAfter": { "Compose_add_ErrorDescription_TechResponse": [ "SUCCEEDED" ] } } } }, "runAfter": { "techResponse": [ "SUCCEEDED" ] } } }, "else": { "actions": { "String_SOA_Response": { "type": "Compose", "inputs": "@string(body('HTTP_TO_SOA'))" }, "If_SOA_has_fault": { "type": "If", "expression": { "and": [ { "contains": [ "@outputs('String_SOA_Response')", "faultstring" ] } ] }, "actions": { "Parse_fault_to_JSON": { "type": "ParseJson", "inputs": { "content": "@json(xml(body('HTTP_TO_SOA')))", "schema": { "type": "object", "properties": { "env:Envelope": { "type": "object", "properties": { "@@xmlns:env": { "type": "string" }, "env:Header": {}, "env:Body": { "type": "object", "properties": { "env:Fault": { "type": "object", "properties": { "faultcode": { "type": "string" }, "faultstring": { "type": "string" }, "faultactor": { "type": "string" } } } } } } } } } } }, "fault": { "type": "SetVariable", "inputs": { "name": "fault", "value": "@body('Parse_fault_to_JSON')?['env:Envelope']?['env:Body']?['env:Fault']?['faultstring']" }, "runAfter": { "Parse_fault_to_JSON": [ "SUCCEEDED" ] } }, "Transform_to_ErrorResponseFault": { "type": "Xslt", "kind": "DataMapper", "inputs": { "content": "@xml(base64ToString(triggerBody()?['ContentData']))", "map": { "source": "LogicApp", "name": "servicecontract_error_oebsservicecontractresponse.xslt" } }, "runAfter": { "fault": [ "SUCCEEDED" ] } }, "Compose_add_ErrorDescriptionFault": { "type": "Compose", "inputs": "@xml(setProperty(json(xml(body('Transform_to_errorResponseFault'))),'ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE',setProperty(json(xml(body('Transform_to_errorResponseFault')))['ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE'],'ns0:SCINTRF_RESPONSE',setProperty(json(xml(body('Transform_to_errorResponseFault')))['ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE']['ns0:SCINTRF_RESPONSE'],'ns0:ERROR_MESSAGE',variables('fault')))))\r\n", "runAfter": { "Transform_to_ErrorResponseFault": [ "SUCCEEDED" ] } }, "Send_message_fault": { "type": "ApiConnection", "inputs": { "host": { "connection": { "referenceName": "servicebus" } }, "method": "post", "body": { "ContentData": "@{base64(outputs('Compose_add_ErrorDescriptionFault'))}", "ContentType": "text/xml", "Properties": { "ResponseLocation": "@{body('Parse_ServiceContract_to_JSON')?['ServiceContractRequest']?['INTEGRATION_HEADER']?['ResponseLocation']}", "ReceiverSystem": "@{body('Parse_ServiceContract_to_JSON')?['ServiceContractRequest']?['INTEGRATION_HEADER']?['SenderSystem']}" } }, "path": "/@{encodeURIComponent(encodeURIComponent('of_servicecontract'))}/messages", "queries": { "systemProperties": "None" } }, "runAfter": { "Compose_add_ErrorDescriptionFault": [ "SUCCEEDED" ] } }, "Terminate": { "type": "Terminate", "inputs": { "runStatus": "Failed", "runError": { "message": "@variables('fault')" } }, "runAfter": { "Send_message_fault": [ "SUCCEEDED" ] } } }, "else": { "actions": { "Transform_to_ErrorResponseUnavailable": { "type": "Xslt", "kind": "DataMapper", "inputs": { "content": "@xml(base64ToString(triggerBody()?['ContentData']))", "map": { "source": "LogicApp", "name": "servicecontract_error_oebsservicecontractresponse.xslt" } } }, "customMessage": { "type": "SetVariable", "inputs": { "name": "customMessage", "value": "Oracle Finance service is currently unavailable. Please try again later." }, "runAfter": { "Transform_to_ErrorResponseUnavailable": [ "SUCCEEDED" ] } }, "Compose_add_ErrorDescriptionCustomMessage": { "type": "Compose", "inputs": "@xml(setProperty(json(xml(body('Transform_to_ErrorResponseUnavailable'))),'ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE',setProperty(json(xml(body('Transform_to_ErrorResponseUnavailable')))['ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE'],'ns0:SCINTRF_RESPONSE',setProperty(json(xml(body('Transform_to_ErrorResponseUnavailable')))['ns0:SERVICE_CONTRACT_INTERFACE_RESPONSE']['ns0:SCINTRF_RESPONSE'],'ns0:ERROR_MESSAGE',variables('customMessage')))))\r\n", "runAfter": { "customMessage": [ "SUCCEEDED" ] } }, "Send_customMessage": { "type": "ApiConnection", "inputs": { "host": { "connection": { "referenceName": "servicebus" } }, "method": "post", "body": { "ContentData": "@{base64(outputs('Compose_add_ErrorDescriptionCustomMessage'))}", "ContentType": "text/xml", "Properties": { "ResponseLocation": "@{body('Parse_ServiceContract_to_JSON')?['ServiceContractRequest']?['INTEGRATION_HEADER']?['ResponseLocation']}", "ReceiverSystem": "@{body('Parse_ServiceContract_to_JSON')?['ServiceContractRequest']?['INTEGRATION_HEADER']?['SenderSystem']}" } }, "path": "/@{encodeURIComponent(encodeURIComponent('of_servicecontract'))}/messages", "queries": { "systemProperties": "None" } }, "runAfter": { "Compose_add_ErrorDescriptionCustomMessage": [ "SUCCEEDED" ] } }, "Terminate_customMessage": { "type": "Terminate", "inputs": { "runStatus": "Failed", "runError": { "message": "probably service is unavailable" } }, "runAfter": { "Send_customMessage": [ "SUCCEEDED" ] } } } }, "runAfter": { "String_SOA_Response": [ "SUCCEEDED" ] } } } }, "runAfter": { "HTTP_TO_SOA": [ "SUCCEEDED", "TIMEDOUT", "FAILED" ] } } }, "runAfter": { "Initialize_customMessage": [ "SUCCEEDED" ] } }, "Catch_Scope": { "type": "Scope", "actions": { "Terminate_TryScope": { "type": "Terminate", "inputs": { "runStatus": "Failed" } } }, "runAfter": { "Try_Scope": [ "TIMEDOUT", "FAILED" ] } } }, "contentVersion": "1.0.0.0", "outputs": {}, "triggers": { "When_a_message_is_received_in_a_topic_subscription_(auto-complete)": { "type": "ApiConnection", "inputs": { "host": { "connection": { "referenceName": "servicebus" } }, "method": "get", "path": "/@{encodeURIComponent(encodeURIComponent('oraclefinance_queue'))}/subscriptions/@{encodeURIComponent('servicecontract')}/messages/head", "queries": { "subscriptionType": "Main" } }, "recurrence": { "interval": 3, "frequency": "Second" } } } }, "kind": "Stateful" }Screenshots or Videos
With the mapping produced by datamapper:
With edited map file:
here is the edited section of the datamapper file:
here is the datamapper file before i had to edit it:
Browser
Edge
Additional context
if you need more context or anything else let me know. I can always share in other ways than this issue form.
The text was updated successfully, but these errors were encountered: