{"id":16,"date":"2013-08-14T07:15:00","date_gmt":"2013-08-14T07:15:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=16"},"modified":"2021-12-21T15:35:29","modified_gmt":"2021-12-21T10:05:29","slug":"re-create-deleted-records-using-audit-history","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2013\/08\/re-create-deleted-records-using-audit-history\/","title":{"rendered":"Re-create deleted records using Audit History"},"content":{"rendered":"
\n

Many a times we come across situations where we accidentally, delete a particular record and wish to recover that record back in CRM. This is possible only if you have \u201cAuditing\u201d enabled for that respective entity. So from the audit history we can re-create deleted records in CRM.<\/p>\n

<\/div>\n

Let us take an example, supposing some records were deleted today and needs to be recovered.
\n<\/p>\n

\/\/fetch XML for retrieving auditing records which were deleted today<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string fetchXML = ” ” +<\/div>\n
\u00a0\u00a0\u00a0 ”\u00a0 ” +<\/div>\n
\u00a0\u00a0\u00a0 ” ” +<\/div>\n
\u00a0\u00a0\u00a0\u00a0 ” ” +<\/div>\n
\u00a0\u00a0\u00a0 ” ” +<\/div>\n
\u00a0\u00a0\u00a0 ” ” +<\/div>\n
\u00a0\u00a0 ” ” +<\/div>\n
\u00a0\u00a0\u00a0 ”\u00a0\u00a0 ” +<\/div>\n
\u00a0\u00a0\u00a0 ” ” +<\/div>\n
\u00a0\u00a0\u00a0 “”;<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/retrieve the audit records from fetchxml<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var auditrecords = service.RetrieveMultiple(new FetchExpression(fetchXML));<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/loop through each audit entity record found and create deleted records<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 foreach (Entityaudit in auditrecords.Entities)<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ create retrieveaudit detail request object<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RetrieveAuditDetailsRequest auditDetailsRequest = new RetrieveAuditDetailsRequest();<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/assign audit id value<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 auditDetailsRequest.AuditId = audit.Id;<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/execute request and retrieve response<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 RetrieveAuditDetailsResponseauditDetailsResponse =<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (RetrieveAuditDetailsResponse)_service.Execute(auditDetailsRequest);<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/create auditDetail variable and assign its value<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AuditDetail auditDetail = auditDetailsResponse.AuditDetail;<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/type cast audtitDetail as AttributeAuditDetail<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AttributeAuditDetail attributeAuditDetail = auditDetail as AttributeAuditDetail;<\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/create the deletedrecord<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 service.Create(attributeAuditDetail.OldValue);<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/div>\n

 <\/p>\n

<\/div>\n

 <\/p>\n

<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\n

In above code first we have retrieved audit entity records which were created \u201ctoday\u201d and operation was \u201cDelete\u201d.<\/p>\n

<\/div>\n
\u201cOperation\u201d field is an \u201cOption Set\u201d field and values are<\/div>\n
<\/div>\n
–\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 Create = 1<\/div>\n
–\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 Update = 2<\/div>\n
–\u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 Delete = 3<\/div>\n
–\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 Assign = 4<\/div>\n
\n


\n<\/p>\n

Hope this post helps!<\/div>\n

 <\/p>\n<\/div>\n

<\/p>\n<\/div>\n

<\/div>\n
<\/div>\n
\n

<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Many a times we come across situations where we accidentally, delete a particular record and wish to recover that record back in CRM. This is possible only if you have \u201cAuditing\u201d enabled for that respective entity. So from the audit history we can re-create deleted records in CRM. Let us take an example, supposing some\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[20],"tags":[176,494,1419],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2011","tag-auditing","tag-delete","tag-recreate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/16\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}