Deleting 1M documents from Appian

Question

I have a case where i need to delete 1million documents from appian. so what I did is querying the appian doc ids from the DB and checking whether the appian has this document and proceeding with deletion. for this i planned 2 approaches: 
1. using a rule querying the doc ids from db. then, I will make an intersection with doc folder (getting list of doc ids in this folder) and doc id list to confirm those ids are in Appian and proceed with deletion.
2.adding a script task before deletion to whether doc is present in appian or not using isObjectexists then proceed with deletion(currently my environment has only delete single doc at one time)
 which will be best solution and pros and cons of it or is there any other ways . I'm new to Appian can anyone help me this ?Thanks in advance

stefanhelzle0001 · Answer

If you want to delete all files in a folder, the plugin "Content Tools" has a smart service to do that. This plugin also has a smart service to delete multiple documents in one go.

For modelling loops in a process, find some examples in the documentation: https://docs.appian.com/suite/help/23.3/looping.html

You will have to implement some kind of batching. Do not try to load all IDs into memory.

Your approach 1 is probably a bit more efficient.

Deleting 1M documents from Appian

I have a case where i need to delete 1million documents from appian. so what I did is querying the appian doc ids from the DB and checking whether the appian has this document and proceeding with deletion.

for this i planned 2 approaches:

1. using a rule querying the doc ids from db. then, I will make an intersection with doc folder (getting list of doc ids in this folder) and doc id list to confirm those ids are in Appian and proceed with deletion.

2.adding a script task before deletion to whether doc is present in appian or not using isObjectexists then proceed with deletion(currently my environment has only delete single doc at one time)

which will be best solution and pros and cons of it or is there any other ways . I'm new to Appian can anyone help me this ?

Thanks in advance

2 replies

I have a case where i need to delete 1million documents from appian. so what I did is querying the appian doc ids from the DB and checking whether the appian has this document and proceeding with deletion. for this i planned 2 approaches:

1. using a rule querying the doc ids from db. then, I will make an intersection with doc folder (getting list of doc ids in this folder) and doc id list to confirm those ids are in Appian and proceed with deletion.

2.adding a script task before deletion to whether doc is present in appian or not using isObjectexists then proceed with deletion(currently my environment has only delete single doc at one time)

which will be best solution and pros and cons of it or is there any other ways . I'm new to Appian can anyone help me this ?Thanks in advance

Sign up

Login with SSO

Login to the community

Login with SSO

I have a case where i need to delete 1million documents from appian. so what I did is querying the appian doc ids from the DB and checking whether the appian has this document and proceeding with deletion.

for this i planned 2 approaches:

which will be best solution and pros and cons of it or is there any other ways . I'm new to Appian can anyone help me this ?

Thanks in advance