Question

Reading XML from a website

  • 28 May 2019
  • 1 reply
  • 2 views

Badge +3

Hi I am trying to bring in an XML table from http://envdata.es.govt.nz/services/data.ashx?f=water-level.xml which has some useful water level data. I have tried different XML readers and can't get it to read the data. Can someone recommend a workflow that will read it.

 


1 reply

Userlevel 2
Badge +17

The URL seems to link to a JSON document rather than XML. Try using the JSON reader or a JSON transformer.

Reply