nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using Python API to Update a Hosted Feature Layer

LouieDowney_III

I'm trying to automate the process of taking data from our local gis servers and push a copy into ArcGIS Online to use the OpenData tools/website.

I've uploaded a file geodatabase containing two layers and created hosted feature layer from them, which was fairly simple.

Where I'm struggling is updating the data. When I go to the ArcGIS online website and go to hosted feature layer and select "Update Data" and give it the new file geodatabase with the updated data, it works like a charm.

From what I've found, this seems like it should work, and it returns successfully, but the data is never updated when I go and look at it.

# overwrite the initial data
updateData = '<Path2MyData>'
fgdb = gis.content.get('<IDofMyHostedLayer')
if fgdb.update({}, updateData):
print("Success?")
else:
print("No success?")

What am I missing here? I just want to overwrite the existing data with the new files.

Thanks,

Trouver plus de publications taguées avec

Accepted answers

WilliamCraft

I think you're missing the 'publish' step. Here is some code that should work for completely overwriting the data any time you need. The example is for a CSV but the same concept applies for file geodatabases. Just replace the item ID, the URL, username/password, and the data source reference.

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS

source <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"http://yourorganization.maps.arcgis.com"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"username"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"password"</SPAN><SPAN class="punctuation token">,</SPAN> verify_cert<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
csv <SPAN class="operator token">=</SPAN> source<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a4e4587122354eb2847d461263e3ccb7'</SPAN><SPAN class="punctuation token">)</SPAN>
csv<SPAN class="punctuation token">.</SPAN>update<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">'C:\TEMP\data.csv'</SPAN><SPAN class="punctuation token">)</SPAN>
csv<SPAN class="punctuation token">.</SPAN>publish<SPAN class="punctuation token">(</SPAN>overwrite<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

FyneAde-Amadi

Hi, will this code work if the geodatabase is compressed or there's another layer to add? Thanks.

LouieDowney_III

Thanks, that's what I was missing.

I had to change my ItemID to be the file geodatabase I'd uploaded instead of the hosted feature layer, and add the filetype to the publish properties, but seems to have it.

fgdb.publish(overwrite=True,file_type='fileGeodatabase')

On an unrelated note, I've been struggling to use the Python API documentation. I'm used to the format from the JavaScript API, where each class has it's own page, and all the properties are listed in a nice clean table at the top that then links to the details of that function.

The python api documentation is one massive page and all the properties of a class, while listed, have all the details of the other properties before you get to them. So if you go on there and look at the Item class, you just have to keep scrolling until you find publish, and if you just search "Publish", you get over 60 results to try and weed through. All the info is there, just not nearly as easy to sift through.

And I can't seem to find anywhere in there that updating the source data requires you to republish the feature layer for the changes to show up, so I don' t know how I'm supposed to know that.

WilliamCraft

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS

source <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"http://yourorganization.maps.arcgis.com"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"username"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"password"</SPAN><SPAN class="punctuation token">,</SPAN> verify_cert<SPAN class="operator token">=</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>
csv <SPAN class="operator token">=</SPAN> source<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a4e4587122354eb2847d461263e3ccb7'</SPAN><SPAN class="punctuation token">)</SPAN>
csv<SPAN class="punctuation token">.</SPAN>update<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">'C:\TEMP\data.csv'</SPAN><SPAN class="punctuation token">)</SPAN>
csv<SPAN class="punctuation token">.</SPAN>publish<SPAN class="punctuation token">(</SPAN>overwrite<SPAN class="operator token">=</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.