Forum Discussion

christof's avatar
christof
Occasional Contributor
13 years ago

Datasource Excel to array

Hi I am trying to build a TestRequest with an array of objects by reading from an Excel file. I have a DataSource step for my Excel, which reads three rows with two columns each. I'm stuck on how ...
christof's avatar
christof
Occasional Contributor
13 years ago
deepesh.jain wrote:
How can a node be an array of objects?


Well, basically a sequence of complex types:

<xsd:complexType name="ArrayOfProduct">
  <xsd:sequence>
     <xsd:element name="item" type="tns:product" minOccurs="0" maxOccurs="unbounded"/>
  </xsd:sequence>
</xsd:complexType>
<xsd:complexType name="product">
  <xsd:all>
     <xsd:element name="number" type="xsd:int"/>
     <xsd:element name="name" type="xsd:string"/>
  </xsd:all>
</xsd:complexType>


So the request would look something like:

<products>
  <item>
    <number>1</number>
    <name>Jacket</name>    
  </item>
  <item>
    <number>2</number>
    <name>Wallet</name>    
  </item>
</product>


So whilst reading from the Excel file, I have to create a new <item> node dynamically on every iteration.

Thanks for the links, I'll have a look.