Table join to json data?

[RowanWinsemius]

Hi there,

I've often used the standard join tool to join spatial data with a table however Im wondering if its possible to setup a join to json data which represents a table? The scenario is I have a google sheet (like an excel but in the cloud), within ArcGIS desktop I'd like to be able to run my join on to this data which I can I can access via json... Can anyone suggest any ideas as to how this might be feasible?

Cheers,

Rowan

PS I can't find a regular ArcGIS Desktop forum so I'm posting here sorry..

[TimGowner]

Perhaps it would be helpful to first import the JSON into a spreadsheet as well then match them up in the same spreadsheet.  You can use a tool like https://json-csv.com‌ to convert the JSON.

[RowanWinsemius]

Thanks for the suggestion Tim but I was hoping to be able to have it as a live join rather than converting it to a static data source like a csv.

Cheers

[XanderBakker]

Maybe you find the necessary information in this website:

Python Example - Google Cloud Storage — Google Cloud Platform

Kind regards, Xander

[XanderBakker]

You could use some Python code to retrieve the JSON from Google Docs and join it using python (arcpy) to a featureclass.

And yes, you should probably move this to a different place, since installation support has nothing to do with your question.

Kind regards, Xander