Forum Discussion

vinny's avatar
vinny
New Contributor
12 years ago

Comma separated list from excel

Hi All,

I have a web service request which can take multiple ids as input. I am using excel for data driven testing. I want to feed the multiple ids from excel using a comma separated list. Is this possible ?
or I can use XML as a data source.

like...
<ord:orderId>1959326</ord:orderId>
<!--1 or more repetitions:-->
<ord:testIds>9655</ord:testIds>
<ord:testIds>9000</ord:testIds>

Thanks in advance

4 Replies

  • vinny's avatar
    vinny
    New Contributor
    Thanks for your response. I have seen that link. My question is around how do I feed the multiple Ids for the request.

    Here is my request
    <ord:addTestsToOrder>
    <ord:orderId>${DataSource#orderId}</ord:orderId>
    <!--1 or more repetitions:-->
    <ord:testIds>9655</ord:testIds>
    <!--Optional:-->

    <ord:foc>${DataSource#foc}</ord:foc><ord:addingUserId>1</ord:addingUserId>
    <ord:userLocale>${DataSource#userLocale}</ord:userLocale>
    <ord:labLocale>${DataSource#labLocale}</ord:labLocale>
    <ord:owningLabId>${DataSource#owningLabId}</ord:owningLabId>
    </ord:addTestsToOrder>

    so if you see in the request there is testIds which accept one or moreIds, I want to pass this multiple ids in a data driven testing

    Thanks
  • nmrao's avatar
    nmrao
    Community Hero
    Are you still having this issue? Is <testIds> always variable or fixed?
  • vinny's avatar
    vinny
    New Contributor
    I was just playing around the tool.. I did not give a try after that... but the testIds are variable.