topic Re: Loading an API response in JSON to Map Viewer. in ArcGIS Online Questions

Loading an API response in JSON to Map Viewer.

Boyang_Wang — Fri, 17 Dec 2021 14:00:49 GMT

I am using an API for fleet management that responds in JSON with vehicle coordinates. This is how the JSON looks like:

https://api.silentpassenger.com/rest/v2/help/operations/GetDataPoints#response-json

I would like to draw these coordinates as points in ArcGIS Online Map Viewer. Do I need to use another API to convert JSON to ArcGIS compatible formats such as CSV, GeoRSS or KML?

Thanks!

Re: Loading an API response in JSON to Map Viewer.

RussRoberts — Fri, 17 Dec 2021 16:08:54 GMT

Yup you will need to convert it. I would recommend CSV or GeoJSON in the New Map Viewer.

Re: Loading an API response in JSON to Map Viewer.

Boyang_Wang — Fri, 17 Dec 2021 16:13:41 GMT

Is there an converter API ready to use for this purpose? I do not have web server so I think I cannot develop and deploy a converter by myself.

What about GeoEvent Server? Can that server be used for this purpose?

Re: Loading an API response in JSON to Map Viewer.

Deputy_Rico — Tue, 26 Jul 2022 00:00:08 GMT

With regards to the initial problem, I am also curious as to what program or application I should use to convert an API that is in JSON format into a GEOJSON format in order to connect and upload dynamic data into Map Viewer.

Re: Loading an API response in JSON to Map Viewer.

Boyang_Wang — Tue, 26 Jul 2022 12:43:29 GMT

My solution was creating a hosted feature service, using Python to convert JSON to CSV and cursor to write to feature service every 10 seconds. I am working in Enterprise environment, so I am not sure if this method will drain the credits in ArcGIS Online environment.

Re: Loading an API response in JSON to Map Viewer.

Deputy_Rico — Tue, 26 Jul 2022 15:49:36 GMT

Thank you! I will give this a try and see how it goes with the credits.