AnsweredAssumed Answered

Can a DD Virtual Service use multiple rows from a spread sheet to build a single response

Question asked by Jay.Meadows.1 on May 10, 2018
Latest reply on May 11, 2018 by norre01

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

SSNPolicyNumbermailCodeplanName
987654321UL154018007700STF000
987654321UL154018017701STF001

 

 

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>

Outcomes