XML Parse error

  

Hi,

I'm trying to collect information from a website and the information is structured in XML format.

In attached file, if someone can help me, can see that I can already get the xml info from website.


My problem now stands on transforming text information into one record at a time.


What should I put into XPathString?


Thank you for your help.


Em

Hello Emilio,

Could you please send me the URL you are using to fetch the data, so that I can test the app?

Thanks,
R

Hi Rodrigo,


The URL are embedded. Click on the link Std on main page.

but here it goes.

https://aviationweather.gov/adds/dataserver_current/httpparam?dataSource=metars&requestType=retrieve&format=xml&stationString=KDEN&hoursBeforeNow=2


Thank you,

Solution

Oh, I missed that. :)

The XPath you're looking for is

/response/data/METAR

Also, you need to increase the "raw_text" attribute length to fit your data (200 seemed enough) and you need to increment the "current" variable on your loop (right now you have an infinite loop).

Best of luck,
R

Solution