topic Re: Append all data from hosted table to a table in a different hosted feature layer in ArcGIS Online Questions

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

RichardHowe — Fri, 16 Jun 2023 10:12:23 GMT

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

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

JakeSkinner — Fri, 16 Jun 2023 12:21:55 GMT

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.

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

RichardHowe — Tue, 20 Jun 2023 08:04:18 GMT

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?

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

JakeSkinner — Tue, 20 Jun 2023 11:07:45 GMT

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

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

RichardHowe — Tue, 20 Jun 2023 12:31:17 GMT

Amazing. Thanks