Skip to main content
Solved

AGOL Hosted Feature Layer Update Question

  • May 30, 2025
  • 1 reply
  • 27 views
vxn43
Supporter
Forum|alt.badge.img+18

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.

    danilo_fme
    crutledge
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    crutledge
    Influencer
    Forum|alt.badge.img+43
    • crutledgeInfluencer
    • Influencer
    • Best Answer
    • 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
    hkingsbury
    vxn43
    rory-mc

    Community Stats

    32,129
    Posts
    121,967
    Replies
    39,779
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.