Table join to json data?

Question

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..

XanderBakker · Answer

Maybe you find the necessary information in this website:

Python Example - Google Cloud Storage — Google Cloud Platform

Kind regards, Xander

RowanWinsemius2 · Answer

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 · Answer

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