topic Re: How do I convert a JSON URL to features in ArcGIS Pro? in ArcGIS Data Interoperability Ques.

How do I convert a JSON URL to features in ArcGIS Pro?

ThumukuntaManogna — Thu, 25 May 2023 16:00:56 GMT

I have a json url which i need imported to ArcGIS Pro and converted to Features. How do I convert the json url to features?

I have tried using the data interoperability extension converting it to shapefile, but the imported data appears as a single row of meta data.

Re: How do I convert a JSON URL to features in ArcGIS Pro?

RenatoSalvaleon3 — Thu, 25 May 2023 16:21:54 GMT

Here's a few blogs with sample workspaces that shows parsing of JSON into several destination formats.

https://community.esri.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=blog-board:arcgis-data-interoperability-blog&q=json

If you have a specific use case, a public URL, or even a sample JSON file, we could give you a more specific answer or even a working solution.

Hope this helps.

Re: How do I convert a JSON URL to features in ArcGIS Pro?

ThumukuntaManogna — Thu, 25 May 2023 16:23:48 GMT

The url I am looking to convert is https://iowa-atms.cloud-q-free.com/api/rest/dataprism/wzdx/wzdxfeed

Re: How do I convert a JSON URL to features in ArcGIS Pro?

RenatoSalvaleon3 — Thu, 25 May 2023 16:56:53 GMT

Use a GeoJson reader for this particular URL. You don't have to do anything special to parse the feature collection into a table or show its geometry. Attach is a sample solution, just add your desired destination format in the canvass.

Re: How do I convert a JSON URL to features in ArcGIS Pro?

ThumukuntaManogna — Thu, 01 Jun 2023 18:28:25 GMT

Thank you for the solution. I still face an issue with some columns being translated to Null values. Some columns seem to be translated well, while others are returning all null values. Examining the translator shows all the data, so there seems to be some tweaking to be done with the writer parameter, but I am unable to figure out what needs to be altered.

Re: How do I convert a JSON URL to features in ArcGIS Pro?

BruceHarold — Fri, 09 Jun 2023 13:58:40 GMT

Hi, I find the data is Multipoint and coming from the GeoJSON reader you'll get (first) point features unless you handle this aspect, see the attachment for how to make line geometry. I don't see any null data.