Hello all. Here is my scenario. In integromat I am:
Is there a way to auto append or auto overwrite the table without doing it manually in the content viewer for said layer?
There is an overwrite function in the Python API that will take a CSV as an input. A bit of python scripting can automate the process easily enough. It's important to note that when you add a Google Sheet to AGOL / Enterprise, all it's really doing is reading that spreadsheet as text, so if you have the CSV, you can eliminate the Google Docs step entirely.
Also, if your layer has a unique identifier field, you can use append instead, which preserves existing settings and field types.
Thank you for the response. The csv has been a work around since the https geojson address I keep trying to add keeps giving me general error. Is there a way to clean up the geojson file (to make sure fields have the correct type) before I import nor overwrite layer?
So far I can’t figure out why I keep getting an error when trying to import this geojson file —see below
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