Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How to get the results in xml data bank from incoming request->DB tool

mdsheeraz
mdsheeraz Posts: 25

Hi team,

We are creating a virtual asset to post a request from JSON message responder, and one of the argument look for the value in the DB using SQL query, that has been added in the DB tool step and to extract the values results as XML -> XML Data bank step added.

How to get the results inthe XML data bank, i tried running responder suite locally using Example configuration it didnt return any results.

Please find the attached screenshot for the same.

Thanks,
Mohammed Sheeraz

Best Answer

  • benken_parasoft
    benken_parasoft Posts: 1,297 ✭✭✭
    edited July 5 Answer ✓

    You can't run a responder suite as it were a SOAtest test suite.

    In Virtualize, responder suites are deployed as their own an isolated instance, separate from the instance seen from the Virtual Asset Explorer. Certain runtime data is available by monitoring the deployed instance (right-click > Start Monitoring). However, the traffic from the DB Tool may not be visible from there.

    To assist in configuring the extractions for your XML Data Bank, you just need a sample XML document to paste in the Literal tab. You could run a sample query from a DB Tool you add to a provisioning action suite. In Virtualize, a provisioning action suite (.pvn file) acts very much the same as a SOAtest test suite (.tst file) and can be directly executed from the Virtual Asset Explorer. Then you could copy-paste the sample XML to your XML Data Bank.

    You could also consider other approaches, like temporarily using a Write File tool to write the last SQL result XML to disk.

    Once you paste your sample XML into your Data Bank, you should also consider clicking the "Save Expected XML" option. Otherwise, the sample message that you pasted is intentionally not retained.

Answers

  • mdsheeraz
    mdsheeraz Posts: 25
    edited July 5

    Thanks @benken_parasoft for the steps.
    By adding a write file step to record the data and performing above mentioned steps could able to achieve it.
    I was missing clicking the "Save Expected XML" option so every time i save it was disappearing, now it is resolved selecting this option.

    Thanks again for your help.