Mapping name value pairs

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping name value pairs

Viewing 1 reply thread
  • Author
    Posts
    • #23384

      I have a source schema containing an array of name-value pairs, eg

      <Property>

      <Name>Organization</Name>

      <Value>Contoso</Value>

      </Property>

      <Property>

      <Name>Plan</Name>

      <Value>GOLD</Value>

      </Property>

      which I need to convert to schema

      <Request>

      <Organization>Contoso</Organization>

      <Plan>GOLD</Plan>

      </Request>

      Please let me know the best way to do this. I tried using scripts but that generated redundant fields as well..

    • #23386

      is there something wrapping the Property elements in the source schema that lets you know that the two go together?

      • #23394

        Hi Brunchey,

        Thanks for the look.. The property pairs are part of a large Order Request. Since this is a generic request it caters to different kind of orders and hence the data required for each order is passed as name-value pairs. Our orchestration has to extract the data and populate the actual order which will be passed to the back end system.

        Please let me know if this info is enough or you would like to know more.. 🙂

        • #23395

          One more detail.. The name element specifies the destination element it should be mapped to..

          eg <Name>Org</Name><Value>Contoso</Value> means the <Org> element (will be present in destination schema) should have value Contoso..

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.