How to add JSON layer into ArcGIS Online?
Hi, I am trying to find a way to get a feed of species observation data from the NatureWatch NZ database into ArcGIS Online using the iNat API
http://naturewatch.org.nz/pages/api+reference The data needs to be refreshed automatically with new observations from the NatureWatch database, so uploading a static file from drive is not an option.
I am looking at a specific NatureWatch project called "Piwauwau NZ Rock Wren monitoring" which can be accessed in JSON or CSV format via the following urls:
http://www.inaturalist.org/observations/project/piwauwau-nz-rock-wren-national-count.json
http://www.inaturalist.org/observations/project/piwauwau-nz-rock-wren-national-count.csv
(these only return the first page of results - I haven't yet figured out how to get all pages)
The data can also be accessed in KML and Atom formats, which I have been able to add directly as web layers into ArcGIS Online, however these formats do not contain all of the original attribute columns.
I have tried adding the CSV version as a web layer, however this returns the following error, which I suspect might be because there are spaces in some of the column names.:
Does anyone know a way of getting the JSON feed from the iNat API into ArcGIS Online as a layer?
