topic Re: Truncate AGOL table from Pro in ArcGIS Online Questions

Truncate AGOL table from Pro

RoryBennison — Thu, 28 Nov 2019 17:04:40 GMT

Hi Guys,

Hopefully this hasnt been asked before, I am trying to use the truncate table tool from within arcgis pro for a feature layer in arcgis pro, the plan being to later append the data.

When i try to run it, very quickly a failed error appears as below. Is there something that needs to be updated in the arcgis online feature service to allow this to work. The delete rows tool works without a problem and so does append.

Appreciate your assistance on this one

Cheers

Rory

Re: Truncate AGOL table from Pro

Anonymous User — Wed, 05 Feb 2020 05:01:02 GMT

Hi Rory Bennison‌,

The documentation doesn't indicate that Hosted Feature Layers are unsupported, and I was able to reproduce this on my end. I agree that since Delete Rows is in the same toolset, we would expect both to work with Hosted Feature Layer input.

I logged BUG-000128389 for this behavior. If you would like, you can create a case with Eagle Technology Support and attach your customer number to this issue. As you found, the current workaround is to use Delete Rows.

Hope this helps - let me know if you have any more questions.

-Peter

Re: Truncate AGOL table from Pro

Anonymous User — Thu, 05 Nov 2020 17:26:01 GMT

To provide an update on this, BUG-000128389 was closed by Development as a known limitation with the explanation, "The Truncate Table is not supported on hosted feature layers, as described in the error message returned."

The workaround remains what Peter suggested above, Use the Delete Rows tool instead of the Truncate Table tool or use the Delete Features operation through the ArcGIS REST API.

Thank you,

Gillian

Re: Truncate AGOL table from Pro

LindsayRaabe_FPCWA — Thu, 21 Jul 2022 06:37:51 GMT

I know this is an old post, but thought it worthwhile to post anyway.

I've just discovered that the Truncate Table works with feature services (for administrators only) from ArcGIS Pro 3.0.

Re: Truncate AGOL table from Pro

LindsayRaabe_FPCWA — Mon, 03 Apr 2023 03:48:06 GMT

Small clause to add - it only works as long as the feature service doesn't have Sync enabled. More reading here: ArcGIS Pro Truncate Table GP Tool Could Work on Po... - Page 2 - Esri Community