Get Data from XML for SQL in UFT API.
Question ID:
107488
| ♥ 0 |
How can I capture a value from the XML returned, then run a SQL query against my database and compare the fields in the database record to expected results. Would I use the database functions in API testing?
Marked as spam
|
Posted by Answers (1)
|
Private answer
I have used from the tool box ''TransForm XML'' with an XSLT to get the value of a item in XML. For example I used the following XML from [W3Schools.com](http://www.w3schools.com/xsl/). Then I used the following XSLT file: This returns the 'To' value. Then I have used the database functions. Marked as spam
 Posted by bubblehead712 (Questions: 2, Answers: 98) Answered on March 3, 2017 3:54 pm
|