Solved

AGOL Hosted Feature Layer Update Question

3 days ago
May 30, 2025
1 reply
9 views

+18

vxn43
Supporter
43 replies

Hello,

I have an AGOL Hosted Feature Layer that contains Fire Hydrants. There are 5,000 points.

I want to update from a File Geodatabase with new Fire Hydrants. There are 5,004 points (meaning there are 4 new hydrants that do not exist in the Hosted Feature Layer).

In the AGOL Feature Service Writer (highlighted in blue in the screenshot), to update this Hosted Feature Layer, would I use INSERT in Writer Mode?

I want to upload only the 4 new Fire Hydrants to the Hosted Feature Layer from the Fire Geodatabase, thus preserving the existing records in the Hosted Feature Layer. Would I use Truncate Yes or No?

Best answer by crutledge

Hi @vxn43

There are several ways you can tackle this issue. If you simply take the GDB Feature Class with 5004 records and publish using Insert you will add 5004 records to the Hosted Feature Class. If you can first filter to the 4 new records (like a date filter or change detector/matcher) then insert will add 4 new records to existing.

If you take your GDB Feature Class with 5004 records and publish using Truncate you will delete all records and add 5004 records.
Here is a good explanation in previous thread: truncate table and append | Community

Hope that helps.

View original

Did this help you find an answer to your question?

+32

crutledge
Influencer
177 replies
Best Answer
1 day ago
June 2, 2025

Hi @vxn43

There are several ways you can tackle this issue. If you simply take the GDB Feature Class with 5004 records and publish using Insert you will add 5004 records to the Hosted Feature Class. If you can first filter to the 4 new records (like a date filter or change detector/matcher) then insert will add 4 new records to existing.

If you take your GDB Feature Class with 5004 records and publish using Truncate you will delete all records and add 5004 records.
Here is a good explanation in previous thread: truncate table and append | Community

Hope that helps.

At your rest service ^B