Details about this thread
  • State Verified Answer
  • Replies 12 replies
  • Subscribers 291 subscribers
  • Views 3079 views
  • Users 0 members are here
Related content from around SugarClub

restore deleted user

admin guy

Hello! I made a REST API call to DELETE a user and the deletion was successful.

1) Is there a way to undelete or restore the deleted user?

2) Are there any time limits before which the deleted user has to be restored?

3) If undelete is not possible, is there a way to transfer the user's data (like leads, opportunities, etc.,) to some other user or an Admin?

I tried making a POST call sending the same details of a deleted user (like id, user_name, first and last_names), but it resulted in an HTTP 500 status. The response payload read something like 'Database failure. Please refer to sugarcrm.log for details.' Is this expected or a bug?

Parents
  • 0

    Hello,

    If you have deleted Users using the REST API then you can restore it. Basically when you delete any record using REST API or SugarCRM interface it will not delete record from the database. It just mark deleted flag to true. 

    So, to restore your deleted record go to the users table of CRM database and updated value in the deleted field to '0' for desired user record.

    As SugarCRM do not delete record permanently you can restore it at any time there is no time limit to restore.

    Regarding the error with code 500, please check your php log. there might be some error in execution.

    Hope this will helps you!

    Thanks

  • 0 in reply to Maulik Shah

    Hi admin guy,

    I'm not sure wether the standard SugarCRM REST API v10 lets you update the "deleted" field of any record, as I think that when you try to 'GET' the user for instance by ID, the API would through a 404 error or something like this, indicating that the user hasn't been found in the system.

    However, you could create your custom endpoint, receiving as a parameter for instance the username (or the user ID, as desired), and then performing an SQL query in order to look for the given user in the database, and then UPDATE it using again an SQL query.

    Knowing that, you can create your custom endpoint and then perform an SQL query (SELECT) to fetch the user in the database, and then if found perform the UPDATE query in order to bring it back to life... something like:

    UPDATE users SET deleted = 0 WHERE user_name = "jon.doe"

    You also must take into account that if you've got enabled for your instance the Prune Database on 1st Month  scheduler, then your users will be always deleted on 1st of every month and then you won't be able to restore them.

    Hope this helps.

    Regards,

    David.

Reply Children
  • 0 in reply to David López

    Thanks David. So we confirm that there's no in-built REST endpoint to restore a deleted user because of the fact that GET the record by ID will be a 404.

    Also, we don't want to create any custom endpoints, as it involves building the endpoint and interacting with Databases ourselves. We expect the SugarCRM as a Service Provider to expose that feature. I also believe that creating a custom endpoint will enable it only for that SugarCRM instance and not for all customers who have SugarCRM.

  • 0 in reply to David López

    Hi,

    If you have no direct access to the database then a workaround to undeleting any records that have accidentally been deleted either via API or GUI is to simply import those records back in using the standard GUI import tool. This technique relies on knowing the original data (or at least the relevant bits of it) but has always worked for me.

    You need to either use an existing exported CSV or create yourself a new one that has the data. Importantly you need the original "id" value plus any required fields (for Users that is "Last Name", "User Name" and "Status"). When importing select the "Create and Update Existing..." option as you want to update the existing data. You need to add a column in the CSV called "Deleted" and use the value "0" in that column. This will then effectively update the record to change the soft delete flag from 1 to 0 and will undelete the record in the GUI.

    N.B. This technique will (obviously) only work if the record has only been soft deleted. As David Lopez says, if the "Prune Database" type Scheduler jobs have been run and have hard deleted the record from the database then you will not be able to "undelete" the record. You may, however, be able to re-import the record using the original data, including the id, and it should** then link up with any existing related records that still exist (** I haven't tested this though).

    Finally, if you have no database access and do not have the original data to re-import then obtaining a backup of the database (either from your sys admin or from SugarCRM Support for On-Cloud) will provide you with the data you require.

    Thanks,

    JH.