How can I add Geo(JSON) to ArcGIS for Portal?

Question

I've been trying to add a JSON file containing fields with coordinates (not sure if that is the only criteria for calling JSON files GeoJSON). This JSON file comes from an external real-time server but is saved locally. The steps I took are as: My content > Add item > From my computer. Everytime I try to add the concerning JSON file, it says: "invalid url". Extra information: the JSON file is a saved output from the HERE Traffic REST API. The corresponding URL to get the output contains parameters like the desired incidents categories, bounding box, and the API ID and key.

BeckyMaholland · Answer

Hi Bruce, I recently submitted a ticket and worked with an ESRI tech on this issue and he found that there is a bug in Arcmap 10.5 that does not allow for json or geojson to be read via REST utilizing the Spatial ETL Tool. v10.5.1 however, fixes this bug.  Since I will not be able to upgrade soon, I was hoping that you might know of another fix for this issue?

bharold · Answer

Becky, Data Interoperability extension can read JSON via REST, transform it into rows or features (if that is what the endpoint abstracts) and write to a portal feature service with truncate or update.  An ETL can be called via Python on any schedule.

BeckyMaholland · Answer

Hi, I also have this question, but am working with a dynamic dataset provided as a REST API in json format.  Is there a way to access this dynamic data in our Portal? I found some information on Koop, but not sure if that will work for us behind our firewall (the json REST API is also behind our firewall).  I'm not a programmer, but can do some scripting if needed.  Any help is appreciated. Thanks!