Forum Discussion

anand1's avatar
anand1
Contributor
5 years ago

Assertion of selective elements in a teststep

Hi, I am using readyapi version 3.1.0 and I am trying to do the database testing using it My test case looks like this Iteration 1- csvdata file-Datasource step step1 step2 step3 XPATH - [AC-1...
Assertions
Automation Environments
Editors
REST
Scripting
SOAP
  • anand1's avatar
    anand1
    5 years ago

    Thanks nmrao for your suggestion

    I have never used custom property earlier, however I am able to achieve it using script assertion and for now it seems that it running well with my huge data.

    Still if i run into any scenario..will surely try the custom property approach.

     

    Thanks for your help.

HimanshuTayal's avatar
HimanshuTayal
Community Hero

anand1  : I think doing this by groovy script will easy your work as this is so dynamic. Even if you want to assert via pre existing feature of ReadyAPI then please share some response of Step-3.

anand1's avatar
anand1
Contributor
5 years ago

Thanks nmrao HimanshuTayal 

Below is the screenshot for the call that I am executing, and in both the screenshot, call is made to the same table, however the expected value that I am trying to assert is changing.

 

Screen1:

 

Screen2:

 

Let me know if that helps.

 

Thanks,

Anand

  • nmrao's avatar
    nmrao
    Champion Level 3
    5 years ago
    Can't view the images, lost the quality on zooming.

    Attach text of the response.
    • anand1's avatar
      anand1
      Contributor
      5 years ago

      Sure nmrao 

       

      Sc2:

       

      And the response output is 

      <Row rowNumber="1">
      <_>[STUDENTOBJECTIVEASSESSMENTSCORErESULTS]</_>
      <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
      <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
      <FORMATTEDRESULT>3611</FORMATTEDRESULT>
      <SHORTDESCRIPTION>Scale score</SHORTDESCRIPTION>
      <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
      <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
      <RESULT>3611</RESULT>
      <RESULTDATATYPETYPEID>1</RESULTDATATYPETYPEID>
      <EFFECTIVEFROMDATE>2020-03-11</EFFECTIVEFROMDATE>
      <EFFECTIVETODATE/>
      <CREATEDDATE>2020-03-11 09:05:58.353</CREATEDDATE>

       

      Assertion is 

      //Results[1]/ResultSet[1]/Row[1]/FORMATTEDRESULT[1]

      #Reading for Information Scaled Score

       

      Next Iteration 

      <Row rowNumber="1">
      <_>[STUDENTOBJECTIVEASSESSMENTSCORErESULTS]</_>
      <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
      <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
      <FORMATTEDRESULT>3611</FORMATTEDRESULT>
      <SHORTDESCRIPTION>Scale score</SHORTDESCRIPTION>
      <STUDENTOBJECTIVEASSESSMENTID>447023021</STUDENTOBJECTIVEASSESSMENTID>
      <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
      <RESULT>3611</RESULT>
      <RESULTDATATYPETYPEID>1</RESULTDATATYPETYPEID>
      <EFFECTIVEFROMDATE>2020-03-11</EFFECTIVEFROMDATE>
      <EFFECTIVETODATE/>
      <CREATEDDATE>2020-03-11 09:05:58.353</CREATEDDATE>
      <LASTMODIFIEDDATE>2020-03-11 09:06:09.567</LASTMODIFIEDDATE>
      <STUDENTOBJECTIVEASSESSMENTSCORERESULTBK/>
      <ASSESSMENTREPORTINGMETHODTYPEID>24</ASSESSMENTREPORTINGMETHODTYPEID>
      <CODEVALUE>Scale score</CODEVALUE>
      <DESCRIPTION>Scale score</DESCRIPTION>
      <EFFECTIVEFROMDATE>2012-07-01</EFFECTIVEFROMDATE>
      <EFFECTIVETODATE/>
      <CREATEDDATE>2012-08-01 00:00:00.0</CREATEDDATE>

       

      Assertion is 

      //Results[1]/ResultSet[1]/Row[1]/FORMATTEDRESULT[1]

      #Functions (8, Alg I, Alg II) Scaled Score

       

      Let me know it that helps

      • nmrao's avatar
        nmrao
        Champion Level 3
        5 years ago
        Not sure if it is copy paste issue. Both iteration 1, 2 responses look similar.
        - "#Functions (8, Alg I, Alg II) Scaled Score" did not get what it is.

        Few other questions
        - how many rows in each iteration? fixed? varies?
        - how does a data source row appears for each iteration, assuming that this data is used to verify response.