How can I use UpdateCursor in AGOL layers?

Question

I'm all new to Python, and 'Im stuck with a problem:

Is it possible to use UpdateCursor on Feature Layers in AGOL?

I am trying something like this:

from arcgis.gis import GIS

gis = GIS("https://arcgis.com", "xxxxxx")

import arcpy

fs=gis.content.search(query="title:xxx, owner:xxxx", max_items=5000,)

kort = fs.layer[0]

fields = ["Fabrikat", "Entreprenør"]

with arcpy.da.UpdateCursor(kort, fields) as cursor:

    for row in cursor:
        if row[0] == "ABB":
               row[1] = "3"
        cursor.updateRow(row)

but its popping up with this error:

RuntimeError Traceback (most recent call last) in 2 lag = query_result1 3 fields = ["Fabrikat", "Entreprenør"] ----> 4 with arcpy.da.UpdateCursor(lag, fields) as cursor: 5 for row in cursor: 6 if row[0] == "ABB":

RuntimeError: 'in_table' is not a table or a featureclass

How can I make the cursor "eat" the layer?

Answer 1

The error is saying the UpdateCursor does not like the input, it is NOT a "table or featureclass".

If you do a type on your layers, you'll see its an object specific to the ArcGIS Python API. And you're trying to use an arcpy cursor that wants either a table or feature class.

l = f.layers[0]
type(l)
>> arcgis.features.layer.FeatureLayer

However, the Cursors appear to accept a URL to a feature service. So you can modify your code slightly and use the URL:

url = kort.url
with arcpy.da.UpdateCursor(url, fields) as cursor:

    for row in cursor:
        if row[0] == "ABB":
               row[1] = "3"
        cursor.updateRow(row)

My testing shows you do NOT need to provide authentication with a private Feature Service (as long as you've created your GIS object as the owner of the service). However, you can also try this workflow to pass in a token.

g = GIS("https://www.arcgis.com", USER, PASS)

token = g._con.token

fs = g.content.search(query="title:My Service", max_items=10)
url = fs[0].layers[0].url
print(url)

featureset = arcpy.FeatureSet()
authenticatedURL = url + "?token={}".format(token)
featureset.load(authenticatedURL)

with arcpy.da.UpdateCursor(authenticatedURL , "*") as cursor:
    for row in cursor:
        row[0] = "hello"
        cursor.updateRow(row)