Automatic Update layer via Google Docs

Question

Hello all. Here is my scenario. In integromat I am:

* calling a Geojson API
* converting data to a csv (the Geojson layer kept assigning a number field to a string hence with a csv upload I had control over the field type)
* updating the original csv file in google docs
* said google doc is what created the feature layer.

Is there a way to auto append or auto overwrite the table without doing it manually in the content viewer for said layer?

thanks

FireRidge

jcarlson · Answer

I imagine you could. I have not used Google functions in ages, but I have seen users on here mention using it for certain tasks.

FireRidge · Answer

Josh

You have been s super help with directing me towards a final solution.

I am going to try and call https://www.fire.ca.gov/umbraco/api/IncidentApi/GeoJsonList?inactive=true&year=2021

within a google python function (https trigger)

Before I go down the rabbit hole ( i do not have experience with python) do you think it is possible to use the ArcGIS Python api in a google function to

* populate said geojson as a layer
* Format said layer
* overwrite said layer (with https trigger set on timer)

Thanks again

Josh

jcarlson · Answer

You can convert a GEOJON directly to a FeatureSet using FeatureSet.from_geojson. From there, you can convert the FeatureSet to a Spatially Enabled DataFrame, which would let you control the field types prior to uploading / appending.