Forum Discussion

cstott02's avatar
cstott02
New Contributor
6 years ago

how to datasink values from a dynamic response

Each time i send a request to a SOAP service the repsonse provided is dynamic and the location of a particular field i'm interested in data sinking may change. 

 

Within the below XML response, i want to capture the value from the tech_value_string but only when the Tech_TechCode is 67. Can anyone help with the best approach to datasinking this value please?

 

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<TechnicalData xmlns="">
<Tech diffgr:id="Tech1" msdata:rowOrder="0">
<Tech_TechCode>110</Tech_TechCode>
<DT_LongDescription>CO</DT_LongDescription>
<Dc_Description>Emissions - ICE</Dc_Description>
<tech_value_string>Not Available</tech_value_string>
</Tech>
<Tech diffgr:id="Tech2" msdata:rowOrder="1">
<Tech_TechCode>67</Tech_TechCode>
<DT_LongDescription>CO2</DT_LongDescription>
<Dc_Description>Emissions - ICE</Dc_Description>
<tech_value_string>165</tech_value_string>
</Tech>
<Tech diffgr:id="Tech3" msdata:rowOrder="2">
<Tech_TechCode>133</Tech_TechCode>
<DT_LongDescription>HC</DT_LongDescription>
<Dc_Description>Emissions - ICE</Dc_Description>
<tech_value_string>Not Available</tech_value_string>
</Tech>
<Tech diffgr:id="Tech4" msdata:rowOrder="3">
<Tech_TechCode>113</Tech_TechCode>
<DT_LongDescription>HC+NOx</DT_LongDescription>
<Dc_Description>Emissions - ICE</Dc_Description>
<tech_value_string>Not Available</tech_value_string>
</Tech>
<Tech diffgr:id="Tech5" msdata:rowOrder="4">
<Tech_TechCode>109</Tech_TechCode>
<DT_LongDescription>Noise Level dB(A)</DT_LongDescription>
<Dc_Description>Emissions - ICE</Dc_Description>
<tech_value_string>Not Available</tech_value_string>

 

 

  • jsheph01's avatar
    jsheph01
    6 years ago

    I'm not sure if there is a way to do what you are asking with an assertion sctipt since you wont have access to testRunner. You should be able to do that with a groovy script step. Depending on how your datasink is setup you may have to disable it so it does not run after the request and log everything. Just a warning; I have not been able to test this code, but it should get you started.

     

    //get the response as xml
def tStep = testRunner.testCase.getTestStepByName("testStepName")
def reponse =  '${testStepName#ResponseAsXml}' 
xmlHold = context.expand(response)
def holder = new XmlParser().parseText(xmlHold)
holder instanceof Node
def max = holder.TechnicalData.Tech.size()

//loop through each tech node
for(cnt=0;cnt<max;cnt++){ 
    if(holder.TechnicalData.Tech[cnt].Tech_TechCode.text() == "67"){
		tStep = testRunner.testCase.getTestStepByName("dataSink")
        def tech_value_string = (holder.TechnicalData.Tech[cnt].tech_value_string.text()
	    tStep.setPropertyValue(dataSinkTarget,tech_value_string)
	}
}

     

  • jsheph01's avatar
    jsheph01
    Contributor
    6 years ago

    I'm not sure if there is a way to do what you are asking with an assertion sctipt since you wont have access to testRunner. You should be able to do that with a groovy script step. Depending on how your datasink is setup you may have to disable it so it does not run after the request and log everything. Just a warning; I have not been able to test this code, but it should get you started.

     

    //get the response as xml
def tStep = testRunner.testCase.getTestStepByName("testStepName")
def reponse =  '${testStepName#ResponseAsXml}' 
xmlHold = context.expand(response)
def holder = new XmlParser().parseText(xmlHold)
holder instanceof Node
def max = holder.TechnicalData.Tech.size()

//loop through each tech node
for(cnt=0;cnt<max;cnt++){ 
    if(holder.TechnicalData.Tech[cnt].Tech_TechCode.text() == "67"){
		tStep = testRunner.testCase.getTestStepByName("dataSink")
        def tech_value_string = (holder.TechnicalData.Tech[cnt].tech_value_string.text()
	    tStep.setPropertyValue(dataSinkTarget,tech_value_string)
	}
}