XMLPorts

t_cracco

Hi,

I need a help creating a XMLPort in NAV2016.

The format that I need for the XML is:

<RootNode>
  <Node1/>
  <Node2/>
  <Node3/>
  ...
  <NodeX/>
  <Parameters>
    <Param/>
    <Param/>
    <Param/>
    <Param/>
  </Parameters>
</RootNode>

I have tried to create the XMLPort in multiple ways, but each time I got an incomplete result of receiving multiple times "<Param/>"-tag
The following options I have tried:
<RootNode> ==> linked to temporary table1 (min repeating: once, max: once)
<Node1> .. <NodeX> ==> linked to the field in the table1 (repeating: once,once)
<Parameters> ==> linked to the field Parameters in table1 (repeating: once,once)
<Param> ==> linked to the field Param in table1 (repeating: once, unbounded)
==> result only 1 <Param>

<RootNode> ==> linked to temporary table1 (min repeating: once, max: once)
<Node1> .. <NodeX> ==> linked to the field in the table1 (repeating: once,once)
<Parameters> ==> linked to temporary table2 (repeating: once,once) reletionship set with table1
<Param> ==> linked to the field Param in table2 (repeating: once, unbounded)
==> result only 1 <Param>

Does anybody have any idea on a solution?

Kind Regards,
Tom

lubost

- How your data looks like?
- How is table2 related to table1 if any?
- How is table2 filtered?