Hi,
This is possible using ArcGIS API for Python. You can write a script to query features using an expression and delete the attachments of those selected features only while leaving the rest of attachments in the feature service.
Below is a sample code that you can use. Keep in mind that you need to modify some parameters in the script according to the settings in your own data.
You should be careful when deleting attachments, as this operation is permanent and cannot be undone. It's a good practice to make a backup of your data before performing any deletion operations, just in case you accidentally delete something you didn't mean to.
from arcgis.gis import GIS
import arcgis
from arcgis.features import FeatureLayerCollection
gis = GIS("https://www.arcgis.com", "USERNAME", "PASSWORD") #Replace your username and password
featureService = gis.content.get('ITEM_ID')
flayer=featureService.layers[0] #You may need to change layer id from 0 to your own layer number
whereclause = "QUERY_EXPRESSION" #for example "status ='done'" queries features where the value in the "status" field is "done"
for feature in flayer.query(where=whereclause):
f_oid=feature.attributes.get("OBJECTID") #You need to replace OBJECTID with the name of the objectid field in your dataset.
att_list=flayer.attachments.get_list(oid=f_oid)
if att_list:
for att in att_list:
att_id= att['id']
flayer.attachments.delete(f_oid,att_id)
print(f"Attachments were deleted for feature {f_oid}")
else:
print(f"No attachments found for feature {f_oid}")
Some documentation that might be helpful for reference:
https://developers.arcgis.com/python/guide/using-attachments-with-feature-layers/
https://developers.arcgis.com/python/api-reference/arcgis.features.managers.html
Best,
MJ
