topic Re: Appending rows to an empty hosted Feature Service using python in ArcGIS REST APIs and Services Questions

Appending rows to an empty hosted Feature Service using python

ErnestoCarreras2 — Mon, 02 Mar 2020 20:05:13 GMT

Is it possible to append data from an excel table to a hosted Table (stand-alone table – not a layer) using python? I am attempting to replicate the process that is available in ArcGIS Online > Data > Append Data to Layer using an Excel table as the input file. The table may have more than one record.

Jake Skinner

Jake, will the tool referenced in the link below work? Can it be modified so th einput is a table instead of a feature class?

Update Hosted Feature Service with Feature Class

Re: Appending rows to an empty hosted Feature Service using python

JakeSkinner — Wed, 04 Mar 2020 13:01:47 GMT

Hi Ernesto,

Unfortunately, the tool I developed will not work as it uses the Features to JSON tool. This tool requires a feature class for the input.

Re: Appending rows to an empty hosted Feature Service using python

ErnestoCarreras2 — Wed, 04 Mar 2020 13:04:38 GMT

Any suggestions? Can you point me to the right direction? Any assistance will be appreciated/

Re: Appending rows to an empty hosted Feature Service using python

JakeSkinner — Fri, 10 Dec 2021 20:33:34 GMT

You can use the Add Features REST API command. You first will want to get the attribute data by iterating through the Excel file. I would recommend first importing the excel file to a File Geodatabase using the Excel to Table function, then do the iteration on the geodatabase table.

You can then pass the attributes from the geodatabase table to the feature service. Below is an example on how to update a feature service:

import requests, json, arcpy

# Disable warnings
requests.packages.urllib3.disable_warnings()

# Variables
gdbTable = r"C:\temp\python\test.gdb\xy"
username = "agol"
password = "gis1234"
addfsURL = 'https://services.arcgis.com/dlFJXQQtlWFB4qUk/ArcGIS/rest/services/Recycling/FeatureServer/2/addFeatures'

# Generate Token
tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'
params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'}
r = requests.post(tokenURL, data = params, verify=False)
response = json.loads(r.content)
token = response['token']

# Add Features
with arcpy.da.SearchCursor(gdbTable, ["Latitude", "Longitude"]) as cursor:
  for row in cursor:
    latitude = row[0]
    longitude = row[1]
    attr = [{"attributes":{"Latitude":"{0}".format(latitude),"Longitude":"{0}".format(longitude)}}]
    params = {"features": json.dumps(attr), 'token': token, 'f': 'json'}
    r = requests.post(addfsURL, data = params, verify=False)
del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have not tested the above, so there may be some minor errors.

Re: Appending rows to an empty hosted Feature Service using python

ErnestoCarreras2 — Wed, 04 Mar 2020 14:22:51 GMT

Exactly what I needed... I just tried it and worked as expected!