Parse XML File

Question

Newbie...I have an XML file wanting to Parse.  I've tried using Datasource as File, when i try bringing it up with XML datasource I receive an error "Failed to select XPath for row property value &lt;/fees&gt;Tried Directory datasource no errors but i don't get any rows coming back..Groovy i don't understand at all..Any help appreciated. Here is my XML- &lt;Fees&gt;- &lt;Fee&gt;  &lt;AsOfDate&gt;2013-05-31T00:00:00&lt;/AsOfDate&gt;   &lt;SourceId&gt;6&lt;/SourceId&gt;   &lt;MandateId&gt;24166&lt;/MandateId&gt;   &lt;PortfolioId&gt;17741&lt;/PortfolioId&gt;   &lt;Amount&gt;1000000.00&lt;/Amount&gt;   &lt;FeeTypeId&gt;6&lt;/FeeTypeId&gt;   &lt;ToId&gt;7&lt;/ToId&gt;   &lt;FromId&gt;3&lt;/FromId&gt;   &lt;BillingValuationAmount&gt;34567.00&lt;/BillingValuationAmount&gt;   &lt;/Fee&gt;  &lt;/Fees&gt;

nmrao · Answer

Welcome to soapui

If you got interest and needed for you, you will learn them automatically, not that difficult as you think.

Did not get what are you looking for. Would you please send your query with details?

n911681 · Answer

Hear is what i want to do...Take an xml file..  read it in soap and then one of two options...  pass it on to a service and/or compare the xml file and validate the data made it to the database...  THe xml output is from my previous post.A) I assume passing an xml to a service is possibleB) I'm having issues reading the xml file.any direction would be appreciatedThanks

nmrao · Answer

What is that xml you are trying to read and in which type of step? Is it a response of soap request type? If so you may get examples in soapui tips &amp; tricks.

n911681 · Answer

I've attached the xml file trying to read...

2 things I'm looking for..
1) a service to read this xml file and pass the information into the database versus me having to manually type in the values. I need to test multiple XML files getting sent to database. So it's not a response its a send.
2) i'd like to parse the xml so i can do data verification once the data is populated in the database.

Hope this brings some clarity. Thanks for hlep in advance.

smartbear_suppo · Answer

If you have SoapUI Pro, then you can select values and generate XPATH automatically: http://www.soapui.org/Working-with-soap ... sting.html

If you are using open source, it sounds like you need to learn XPATH and apply the right paths to your elements: http://www.w3schools.com/xpath/

Thanks,
Michael Giller
SmartBear Software

Forum Discussion

Parse XML File

5 Replies

Recent Discussions

Update API definition : Error with the json format

Test result Pass when data source times out

Run Test Case properties not populating for Data Source based items

Related Content

Parsing XML file with Groovy script

Json file parsing

How to parse JSON or XML in Assertions