Forum Discussion

Apoorva6's avatar
Apoorva6
Frequent Contributor
8 years ago

How do i prepare requests with repeated blocks having unique number in each blocks ?

Hi All,   I have below XML request , where <oewInventoryDetails> block can repeat N number of times. and only unique value in all blocks is <oew:inventoryId>. How do i add number of blocks of my in...
nmrao's avatar
nmrao
Champion Level 3
8 years ago
Apoorva6,
I know it is late.
Do you mean to add more "oewServiceDetails" elements?

How do you want to fill data? from external file ? or any dummy data would be fine?

First of all are you still looking for the answer?
  • Apoorva6's avatar
    Apoorva6
    Frequent Contributor
    8 years ago

    Hi Rao,

     

    yes, I am still looking for an answer. I need to fill the data from external file. In external xls file, I have the <oew:inventoryId> values in first column and according to its total numbers, we need so many blocks of  oewServiceDetails.

    Only <oew:inventoryId>  should be unique in oewServiceDetails.

    If my xls has 600 <oew:inventoryId> then my script should be able to fetch all 600 values , make a request with 600 blocks and then run the request.

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Does it really have to be excel file? A comma separated (csv) file will also do? Because that is more simplest to deal with. Of course, you can open the csv file in excel sheel as well if some wants.

      Then can you please send the sample data (preferably csv) file (you could save your excel file as csv file as well).
      • Apoorva6's avatar
        Apoorva6
        Frequent Contributor
        8 years ago

        CSV will work for me. attached is sample file with 20 unique oewInvId's. In this case script should read number of InvId and should prepare one final request of 20 blocks and run the step.

        Thanks for the reply.