insert cursor arcgis online via python

Question

Hey there, I don't know if this is the right space to ask this question but I figure it is worth a shot. I am trying to use an insert Cursor in a script to update a table hosted in ArcGIS Online. My script has no problem updating tables in databases however I cannot for the life of me figure out how to edit the feature service.

also you should know I barely know what I am doing. I can connect to my account via python but that's about it. I assume this is pretty simple so hopefully one of you folks can guide me!

thanks,

Dave

Anonymous User · Answer

thanks for this! because of you I will look like a GIS all star.

RandyBurton · Answer

A sample script using the REST API: import urllib, urllib2, json, sys, time, arcpy # Credentials and feature service information username = <username> password = <password> # addList (geometry and fields) : [ X_LON, Y_LAT, Name, C_long, F_date ] addList = [ [ -8572606.3109, 4705898.3536000028, 'US Capitol', 20180822, '2018-08-22 12:00:00' ] ] URL = "https:///arcgis/rest/services/example/FeatureServer/0/addFeatures" # obtain a token referer = "http://www.arcgis.com/" query_dict = { 'username': username, 'password': password, 'referer': referer } query_string = urllib.urlencode(query_dict) url = "https://www.arcgis.com/sharing/rest/generateToken" token = json.loads(urllib.urlopen(url + "?f=json", query_string).read()) if "token" not in token: print(token['error']) sys.exit(1) # exit if no token for item in addList : f_date = int(time.mktime(time.strptime(item[4], "%Y-%m-%d %H:%M:%S")))*1000 # UTC in miliseconds feature_data = [{ "attributes": { "Name": item[2], "C_long": item[3], "F_date": f_date }, "geometry": { "x": item[0], "y": item[1] }}] # print feature_data submitData = { "features": json.dumps(feature_data), "f": "json", "token": token['token'] } # print submitData jsonResponse = urllib.urlopen(URL, urllib.urlencode(submitData)) jsonOutput = json.loads(jsonResponse.read()) print json.dumps(jsonOutput, indent=4, sort_keys=False) # parse jsonOutput for results‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

RandyBurton · Answer

You can also use the Rest API. See:  Add Features and Update Features .

There are forms to add and update features using the REST API.  Sign in to your account.  In the content section select the feature layer you want, then (on next page) select the specific layer.  This will take you into the services directory and show you basic info about your layer.  At the bottom of this page, under supported operations, there is a link to the Add Features and Update Features forms.  I would suggest learning with a practice/backup feature until you are comfortable with the process.