Input for WaterML

Question

Does anyone have any suggestions on how to ingest WaterML formatted data?  I would like to use USGS REST services for real-time stream gauge data:

https://waterservices.usgs.gov/rest/IV-Test-Tool.html

This is the URL that I generated that I want to use as input:

https://waterservices.usgs.gov/nwis/iv/?format=waterml,2.0&stateCd=la&parameterCd=00065&siteStatus=all

I've tried numerous options for ingesting the XML feed with no luck.

Thanks in advance!

SeanRedar · Answer

I know this is a bit old.  Install the multi-cardinal field splitter and have the USGS feed respond with JSON.  You can break down the JSON structure using the mc field splitter in a few steps.  Seems like ESRI would have a methods to work with waterml but typically ESRI they don't, at least I haven't seen anything.  Probably better, use the Notebook server and python, way more robust.