AnsweredAssumed Answered

Import JSON file into ArcMap

Question asked by cwholmes on Sep 15, 2015
Latest reply on Sep 17, 2015 by cwholmes

Hello everyone,


I have a .json file which I would like to be able to import into ArcMap. The format of the json file when I receive it is like this:


[{"geometry":{"x":-5561.656,"y":5659411.683,"spatialReference":{"wkid":3776}},"attributes":{"EXTERNALNUM":"FILE1","STATUS":"OPEN","FILECLERK":"JANE DOE","RPID":1111111}},{"geometry":{"x":-4480.512000000001,"y":5671280.649,"spatialReference":{"wkid":3776}},"attributes":{"EXTERNALNUM":"FILE2","STATUS":"HOLD","FILECLERK":"BOB BROWN","RPID":2222222}}}]


Is this possible given the way the file is formatted? It doesn't seem to be formatted in a manner to work with the JSON toolset in ArcMap: ArcGIS Help (10.2, 10.2.1, and 10.2.2)


Any suggestions appreciated,