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; } } }

Syncing AGOL Attachments with DB

CodyPatterson

Hey all,

I've found the need to sync an AGOL hosted feature layer with attachments to our local DB. I've pull the FGDB and loaded it onto the DB, and created a Python script using the ArcGIS API for Python, to sync the points and features, but I'm now lost for how I would bring the attachments over. I've found the documentation on how to actually access these through the API for Python, but I haven't found how to get these over.

I'm using SQL Server 2019, newest ArcGIS Pro, and I have access to ArcPy.

Any suggestions?

Thanks in advance!

Cody

Find more posts tagged with

Geodatabase

Databases

Python

Accepted answers

MErikReedAugusta

Broadly speaking, you'll probably need to use the API to "download" the attachments into memory in a script, and then use Add Attachments to add them to the Feature Class in the DB.

If you need specific help, let me know, but I'm a little rusty on the API.

All comments

AndresCastillo

If you take the portal item layer url.

bring in the layer using the item id.

export the features, enabling the environments (Maintain Attachments, and Preserve Global IDs) as below:

The export will create the relationship class with all the needed pictures assigned to the respective records.

RhettZufelt

For this, I use arcpy.append with Maintain Attachments = True.

RobertKrisher

There are also geoprocessing tools that allow you to bulk export and add attachments, these tools do respect selected features (even when run standalone) so you'll use layers to manage which attachments to export.

You can also do this using the ArcGIS API for Python to individual download and add attachments between the two environments.

MErikReedAugusta

Broadly speaking, you'll probably need to use the API to "download" the attachments into memory in a script, and then use Add Attachments to add them to the Feature Class in the DB.

If you need specific help, let me know, but I'm a little rusty on the API.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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