How to Delete Organizations in bulk

[Harish7]

Hi,

Is it possible to to delete organizations in bulk via custom query job? or any other way?

I tried to use the below query to make the organization inactive and change the org name. But i get the below error when i run the job

Query: update customer set customername=concat(customername,'-Deleted_',CURDATE()) where customername in('Test','Test2','Test3')

Error:

Could you please assist me on this issue?

Thanks in Advance!

Best regards

Harish

[avinashchhetri]

Harish,

There are certain keywords that are restricted from the Custom Query Job as shown in your error message. Try to spell "deleted" as say something else say "Deletd" or append it with "Do-Not-use" or something similar to appropriately "mark" your organizations names that you do not intend to use.

There is also an API available /deleteOrganization.  I have not personally used it but you could explore that as well.

https://documenter.getpostman.com/view/1797923/RWaLwo21?version=latest#4cecd9d0-18c3-4fb3-8431-8df22...

[Nikitaj · Accepted solution]

Hi Harish,

We cannot actually delete an organization permanently, however with the delete option it will be set to Inactive state. You can try this using the csv upload. So, we need to add "DELETE" in the operation column of the .csv and once we upload it we will see corresponding organization is set to Inactive status as below:

Please refer Onboarding Organizations : Customer Portal (freshdesk.com) for more details on the same.

[Harish7]

Hi Avinash, Hi Nikitha,

Thank you very much for the reply.

@avinashchhetri Thank you, Renaming Deleted to Removed in query worked..
But currently in my saviynt, all the remaining ogrs which are inactive are named as Deleted at the end. So i am trying for a similar solution.

@Nikitaj  Thank you for the solution, i saw the csv file to upload and delete the Orgs, but i do not see the upload option.

I tried to add in the SAV role - as described in the Saviynt documentation, but it didnt work.

In the documentation, it is shown that after selecting Manage Organization - we get as option below to add Upload Organization. But i didnt get any as you see in the screenshot above.

@Nikitaj or @avinashchhetri Do you have any idea , how to add this option to upload Organization

Thanks in Advance!!

Best regards
Harish

[Nikitaj]

Hi Harish,

Could you please confirm the version you are on? As I am on v2021 and can see the option on SAV Role and also on the feature access in SAV Role 

[Harish7]

Hi Nikitha,

I am on V5.5. May be this option is not available with this version or it should be a bug hopefully.

But, thanks a lot for the solution(Deleting Orgs with file upload) 🙂

Best regards

Harish

[sahajranajee]

@Harish7 ,

Org management from uploads is available with our 2020.1 and later releases (2021.x) . Its not available in 5.5SP3.x