topic Re: Code - Does Feature Class have attachments in ArcGIS API for Python Questions

Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 13:41:02 GMT

Looking for some code that would verify if a Feature Layer has Attachments...

I can check using the describe for many things like if Tracking is Enabled but not sure for attachments I do not see that as a child of DESCRIBE

Thoughts...

desc1 = arcpy.Describe(LayerA) hasEditorTracking = desc1.editorTrackingEnabled print(hasEditorTracking )

Re: Code - Does Feature Class have attachments

Clubdebambos — Wed, 01 Mar 2023 13:58:04 GMT

Hi @kapalczynski

See commented code below for checking if a layer has attachments enabled for a Feature Layer.

from arcgis.gis import GIS ## connect to AGOL agol = GIS("home") ## access Feature Service Item using Item ID item = agol.content.get("INSERT_ITEM_ID") ## iterate through layers and print name and if hasAttachments (True or False) for lyr in item.layers: print(lyr.properties.name) print(lyr.properties.hasAttachments)

Re: Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 14:25:10 GMT

OK I should have been a bit more specific... this data resides on our oracle server and is publish to portal. I would assume that it would change the syntax a bit?

Where this is referencing AGOL

item = agol.content.get("INSERT_ITEM_ID")

Re: Code - Does Feature Class have attachments

Clubdebambos — Wed, 01 Mar 2023 14:46:45 GMT

Hi @kapalczynski

Same principal applies for AGOL/Portal, you can get the feature service item id from the URL when you click into the service item in Portal. Just copy the id into the script.

GIS("home") will access AGOL or Portal depending on which one you are logged into last in ArcGIS Pro.

You could change this to use full parameters

agol = GIS("PORTAL_URL", "PORTAL_USERNAME", "PORTAL_PASSWORD")

Re: Code - Does Feature Class have attachments

Clubdebambos — Wed, 01 Mar 2023 15:04:44 GMT

You can also use ArcPy

import arcpy ## Path to Feature Class in SDE/GDB fc = r"path\to\fc" ## get a describe dictionary desc = arcpy.da.Describe(fc) ## if there is an ATTACHREL relationship class print the name of it. ## this would hint that attachments are enabled for relclass_name in desc["relationshipClassNames"]: if "ATTACHREL" in relclass_name: print(relclass_name)

Re: Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 15:26:30 GMT

Thats what I was looking for @Clubdebambos

I wont know the ID unless I look for it... need this to be within Python....

THANK YOU BOTH for your thoughts...

Re: Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 15:42:50 GMT

I do get this error though:

Traceback (most recent call last):
File "C:/Users/Ja/Desktop/GIS_projects/Land Use Project Folder/PythonScripts/LUPS_Data_TEST_to_UAT_DESCRIBE.py", line 47, in <module>
for relclass_name in desc1["relationshipClassNames"]:
TypeError: 'geoprocessing describe data object' object is not subscriptable

LayerA_Tst = "Database Connections\\TEST@gis_data.sde\\GIS_DATA.SDE_TEST" desc1 = arcpy.Describe(LayerA_Tst) for relclass_name in desc1["relationshipClassNames"]: if "ATTACHREL" in relclass_name: print(relclass_name)

Re: Code - Does Feature Class have attachments

Clubdebambos — Wed, 01 Mar 2023 15:47:23 GMT

I'm using the data access module in mine to access describe as a dictionary rather than a describe object. Change to this line below.

desc1 = arcpy.da.Describe(LayerA_Tst)

Re: Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 15:51:19 GMT

Thanks again... missed that...

Re: Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 16:26:32 GMT

question: If there are no Attachments there it does nothing... I cant seem to trap if they are there if they are not...

If there are NO attachments I don't get True OR False

for relclass_name in desc1a["relationshipClassNames"]: if "ATTACHREL" in relclass_name: print("True") else: print("False")

EDIT: I guess I can just play with a variable and change it from True to false and report on that.... I think I can get it to work.... albeit clumsy..

Re: Code - Does Feature Class have attachments

kapalczynski — Wed, 01 Mar 2023 16:28:38 GMT

I just did this with a couple variables:

hasAttachments1 = "FALSE" hasAttachments2 = "FALSE" for relclass_name in desc1a["relationshipClassNames"]: if "ATTACHREL" in relclass_name: hasAttachments1 = "True - " + str(relclass_name) for relclass_name in desc2a["relationshipClassNames"]: if "ATTACHREL" in relclass_name: hasAttachments2 = "True - " + str(relclass_name) print("---Attachments: " + hasAttachments1) print("---Attachments: " + hasAttachments2)

Re: Code - Does Feature Class have attachments

Clubdebambos — Thu, 02 Mar 2023 09:32:40 GMT

import arcpy ## Path to Feature Class in SDE/GDB fc = r"path\to\fc" ## get a describe dictionary desc = arcpy.da.Describe(fc) ## if there are no relationships classes then no attachments if not desc["relationshipClassNames"]: print("FALSE") ## if there are relationship classes else: ## check if there is an ATTACHREL relationship class if [relclass_name for relclass_name in desc["relationshipClassNames"] if "ATTACHREL" in relclass_name]: print("TRUE") ## otherwise no attachments else: print("FALSE")

Re: Code - Does Feature Class have attachments

PaulHaakma — Wed, 15 Jan 2025 22:58:45 GMT

Here's another way to achieve this using one line.

Using the Data Access describe ensures we have a dictionary and can use the 'get' method to provide a fallback of an empty list if the relationshipClassNames key doesn't exist.

The code iterates over the strings in the relationshipClassNames list and checks if any match the baseName of the featureclass with '__ATTACHREL' at the end which indicates attachments are enabled.

The python 'any' keyword returns true if any of the strings match and false if none do.

This should therefore return true if there are attachments and false if not. It's essentially the same as previously suggested code, but some people prefer one liners and some prefer multiline if/else statements as more readable. Take your pick 😀

desc = arcpy.da.Describe(feature_class) hasAttachments = any(value == f'{desc.get('baseName', '||')}__ATTACHREL' for value in desc.get('relationshipClassNames', []))