Service Virtualization

We have a requirement to use a spread sheet to drive virtual service responses.  We have built some services using the DD facility in the portal.  For this new requirement the data management team would like to use multiple rows in the data sheet with the same key value to represent each response grouping.  This would then control the number of iterations of the response grouping to be returned in the xml. 

If the DD facility can not do this is there any other method to accomplish this?

Below is a simple example of what I am describing.

 Data Sheet with two rows keyed by SSN

Resulting response XML

<soapenv:Body>
    <ns1:holdingSearchResponse>
      <Response>
     <ns2:Policy>
            <ns2:PolNumber>UL15401800</ns2:PolNumber>
            <ns2:PlanName>STF000</ns2:PlanName>
            <ns2:AgencyMailCd>7700</ns2:AgencyMailCd>
          </ns2:Policy>
        </ns2:Holding>
      </Response>
  
      <Response>
        <ns2:Policy>
            <ns2:PolNumber>UL15401801</ns2:PolNumber>
            <ns2:PlanName>STF001</ns2:PlanName>
            <ns2:AgencyMailCd>7701</ns2:AgencyMailCd>
          </ns2:Policy>
        </ns2:Holding>
      </Response>
  
 
    </ns1:holdingSearchResponse>
  </soapenv:Body>

Jay,

I have discussed this DevTest Community post with a number of my Colleagues. The packaged DDVS solution is limited. We recommend custom field extensions to get what you are looking for.