Assert Value against database

LegacyForumLegacyForum Posts: 1,669 ✭✭
edited December 2016 in SOAtest
Hi,
I would like to know using SOATEST 5.5 how can I assert that the value returend in a SOAP/XML response from my webservice is the same as in the DB.
Thanks in advance
Tagged:

Comments

  • LegacyForumLegacyForum Posts: 1,669 ✭✭
    One way of doing it:

    1. Add a Db Tool to the test suite. Populate the Db tool with appropriate connection settings and provide a SQL query.
    2. Chain XML Data Bank to the Db tool. Run the Db Tool which will result in the XML Data Bank being populated with the Resultset in XML representation
    3. Extract desired value from the Resultset that you want to use in the assertion
    4. Add SOAP Client that consumes your Web service, and populate it accordingly
    5. Chain XML Assertor to SOAP Client. Add Value Assertion and choose the desired XPath
    6. In Value Assertion, choose parameterized and select the XML data bank data source column

    Hi,
    I would like to know using SOATEST 5.5 how can I assert that the value returend in a SOAP/XML response from my webservice is the same as in the DB.
    Thanks in advance

  • LegacyForumLegacyForum Posts: 1,669 ✭✭
    Thanks, I will give it a try.

    One way of doing it:

    1. Add a Db Tool to the test suite. Populate the Db tool with appropriate connection settings and provide a SQL query.
    2. Chain XML Data Bank to the Db tool. Run the Db Tool which will result in the XML Data Bank being populated with the Resultset in XML representation
    3. Extract desired value from the Resultset that you want to use in the assertion
    4. Add SOAP Client that consumes your Web service, and populate it accordingly
    5. Chain XML Assertor to SOAP Client. Add Value Assertion and choose the desired XPath
    6. In Value Assertion, choose parameterized and select the XML data bank data source column

    Hi,
    I would like to know using SOATEST 5.5 how can I assert that the value returend in a SOAP/XML response from my webservice is the same as in the DB.
    Thanks in advance

Sign In or Register to comment.