Append all data from hosted table to a table in a different hosted feature layer

[RichardHowe]

Hi, I'm looking to append all the data held in a hosted table in ArcGIS Online to another table in a hosted feature layer (with an identical schema) using python.

I've attempted to use the API guidance, but every time I try I get an unknown error on the .append function

Exception: Unknown Error
(Error Code: 500)

Can anyone help with a code sample. All the examples in the guidance focus on CSVs rather than data already in AGOL

[JakeSkinner · Accepted solution]

Hi @RichardHowe,

If you have an ArcGIS Pro license, use arcpy's Append within your code instead of the ArcGIS API.  It will work with hosted feature services.

[RichardHowe]

Thanks @JakeSkinner , that was very helpful. I don't know why that didn't occur to me!

Next question, while you're here. Is it possible to use toolbox validation with the AGOL GIS API. SO for example could I Update a script parameter to populate with every layer in a hosted feature layer for example?

[JakeSkinner]

@RichardHowe yes the validation will work with ArcGIS API.  You just need to import the module.

[RichardHowe]

Amazing. Thanks