Skip to main content
Question

Update table or feature in AGOL with FME using JSON

  • September 1, 2020
  • 2 replies
  • 26 views

mr_fme
Enthusiast
Forum|alt.badge.img+8

I am converting a JSON file to a table in arcgis online. This data needs to be updated every day. How do I update a table in arcgis online from external data (JSON)? I'm always getting errors ... Or at least delete and create a table again every time the workspace is set up.

WhatsApp Image 2020-09-01 at 16.08.34

thank´s

2 replies

xilef
Contributor
Forum|alt.badge.img+5
  • Contributor
  • September 4, 2020

Hello, from the error message it seams like the data is missing the "OBJECTID_1" field that is required to perform an update or delete operation. If you want to update existing features in a layer or table, both the destination layer and incoming data must share a common ID attribute that will be used as the key to find the destination features and update their information. This field should be used in the feature type parameters as the update field.

 


mr_fme
Enthusiast
Forum|alt.badge.img+8
  • Author
  • Enthusiast
  • September 4, 2020
xilef wrote:

Hello, from the error message it seams like the data is missing the "OBJECTID_1" field that is required to perform an update or delete operation. If you want to update existing features in a layer or table, both the destination layer and incoming data must share a common ID attribute that will be used as the key to find the destination features and update their information. This field should be used in the feature type parameters as the update field.

 

Have you some example?

 

Thank´s


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings