I have a number of datasets which are being shared to me via a third party platform in which I can access the data as an XML or JSON.
There are a total of 10 monitors each with 7 data being recorded which I would like to bring into ArcGIS Pro and link to a hosted feature layer so that the data can be presented in a dashboard.
I am looking for some advice on how best to do this, I have been able to simply access the data for one montior via XML using a Spatial ETL and convert it to a SHP file. However, I cannot get the latitude and longitude to also be pulled through. Equally, I am unsure of how I can get this SHP file to link to a hosted feature layer and update/append every 24hrs.
Is this the most effective approach to this issue or is there a more initiuative solution?