topic Re: Syncing AGOL Attachments with DB in Data Management Questions

Syncing AGOL Attachments with DB

CodyPatterson — Mon, 21 Oct 2024 16:10:11 GMT

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

Re: Syncing AGOL Attachments with DB

MErikReedAugusta — Mon, 21 Oct 2024 20:14:11 GMT

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.

Re: Syncing AGOL Attachments with DB

RobertKrisher — Mon, 21 Oct 2024 20:28:08 GMT

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.

Re: Syncing AGOL Attachments with DB

RhettZufelt — Thu, 21 Nov 2024 23:42:49 GMT

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

Re: Syncing AGOL Attachments with DB

AndresCastillo — Thu, 05 Dec 2024 07:55:36 GMT

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.