LogicAppsUX icon indicating copy to clipboard operation
LogicAppsUX copied to clipboard

Schema with multiple root nodes. Cannot choose root node in the Data Mapper.

Open JanErikHaland opened this issue 1 year ago • 6 comments

Describe the Bug with repro steps

Using mapper in Biztalk we are prompted with the root nodes in the xml schema and are able to choose root node.

In Azure Data Mapper, we are not prompted for anything and the Data Mapper automatically selects the first root node.

We have tested with the same xml schema file in both cases described above.

Is this a known issue in Azure Data Mapper or are we missing something here?

Screenshots or Videos

No response

Version

Azure Logic Apps for Visual Studio Code (Standard) version 4.107.4

Additional context

No response

JanErikHaland avatar Jan 14 '25 13:01 JanErikHaland

Currently with Data Mapper we automatically set the root node. Can you provide a simple schema example for us to understand under what scenarios you'd select a different root?

DanielleCogs avatar Jan 14 '25 18:01 DanielleCogs

Thank you for a quick response! Our use case is health related. There is a standard with schemas used by health systems to communicate with each other: HL7 Standards Product Brief - Version 2 v2.xml XML Schemas for HL7 Version 2.5 and earlier | HL7 International

In our case we will use a schema called ORU_R01. The ORU_R01 schema contains many root nodes. We will select the root node which is also called ORU_R01 and do mapping from this node. I have attached a document containing screenshots from Biztalk which shows what we want to achieve in the DataMapper. I also attached the required xsd-files.

Use case in Biztalk.docx xsd-files.zip

JanErikHaland avatar Jan 15 '25 07:01 JanErikHaland

I'd agree, this makes the mapper almost useless for any non-trivial schema. I'm working with a schema that has multiple included schemas and root nodes. The mapper seems to pick a node that isn't even in the main schema; it's from an included schema. Not having the ability to change the root node means I can't create a map at all. I even tried pulling the single node I wanted into its own top-level schema, but it didn't matter as the tool still somehow found the same root node buried in the included schemas.

mnmilner avatar Feb 14 '25 14:02 mnmilner

Okay so I am seeing two different issues here:

  1. There is a bug where the assumed root node is choosing a random node. I was able to reproduce this in the ORU schema, and can investigate what is happening with this schema.
  2. Feature request with the ability to choose any node to be the root of the schema in the map.

DanielleCogs avatar Feb 15 '25 02:02 DanielleCogs

@mnmilner @JanErikHaland I am Parth from the product team and would love to get in touch with you to improve the current experience based on the scenarios you are bringing up, especially core ones like these that BizTalk already supports. Can you please send me an email to

shahparth @microsoft.com (without space in between my alias and microsoft.com) so we can book sometime for a chat. Thank you for your support!

shahparth-lab avatar Mar 24 '25 23:03 shahparth-lab

Hi!

Sorry for late response.

Next week Tuesday – Thursday may be an option or the week after that.

I am located in Norway. So my business hours are 08-15 CET, but I may be available other times as well.

I haven’t tested the data mapper for some time, so my short version of my wish is to get the same functionality as described in the issue’s attached document.

We use some standard health business schema files containing multiple roots notes (attached to the case)

And want to select one of the root nodes before the node is shown in the data mapper.

Best regards

Jan Erik tir. 25. mars 2025 kl. 00:17 skrev shahparth-lab @.***>:

@mnmilner https://github.com/mnmilner @JanErikHaland https://github.com/JanErikHaland I am Parth from the product team and would love to get in touch with you to improve the current experience based on the scenarios you are bringing up, especially core ones like these that BizTalk already supports. Can you please send me an email to

shah @.*** (without the space in between my first and last name) so we can book sometime for a chat. Thank you for your support!

— Reply to this email directly, view it on GitHub https://github.com/Azure/LogicAppsUX/issues/6391#issuecomment-2749606264, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7FA6IDFBO63VO6WB2TMPL2WCHBRAVCNFSM6AAAAABVE33QVCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDONBZGYYDMMRWGQ . You are receiving this because you were mentioned.Message ID: @.***> [image: shahparth-lab]shahparth-lab left a comment (Azure/LogicAppsUX#6391) https://github.com/Azure/LogicAppsUX/issues/6391#issuecomment-2749606264

@mnmilner https://github.com/mnmilner @JanErikHaland https://github.com/JanErikHaland I am Parth from the product team and would love to get in touch with you to improve the current experience based on the scenarios you are bringing up, especially core ones like these that BizTalk already supports. Can you please send me an email to

shah @.*** (without the space in between my first and last name) so we can book sometime for a chat. Thank you for your support!

— Reply to this email directly, view it on GitHub https://github.com/Azure/LogicAppsUX/issues/6391#issuecomment-2749606264, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS7FA6IDFBO63VO6WB2TMPL2WCHBRAVCNFSM6AAAAABVE33QVCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDONBZGYYDMMRWGQ . You are receiving this because you were mentioned.Message ID: @.***>

JanErikHaland avatar May 09 '25 10:05 JanErikHaland