Sharepoint CSOM Change Log query is not displaying item deleted logs

Sonith Chebathini (LARSEN & TOUBRO INFOTECH LIMIT) 1

Hi, I want to get deleted items/files from a SharePoint list using the change query logs.

Below is the code snippet I have tried to get the logs.

The changequery returns items/files that are added or updated but not deleted.

Can somebody help me on this where am I going wrong?

1 answer

RaytheonXie_MSFT 31,071 Reputation points Microsoft Vendor

2022-04-05T08:42:45.19+00:00
Hi @Sonith Chebathini (LARSEN & TOUBRO INFOTECH LIMIT) ,
We can refer to following code to get deleted logs

foreach (Change change in changes) { if (change is Microsoft.SharePoint.Client.ChangeItem) { ChangeItem ci = change as ChangeItem; changeType = ci.ChangeType.ToString(); itemId = ci.ItemId.ToString(); Console.WriteLine("{0}: {1}", itemId, changeType); } }

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Sonith Chebathini (LARSEN & TOUBRO INFOTECH LIMIT) 1 Reputation point

2022-04-05T11:38:00.6+00:00

Hi @RaytheonXie_MSFT ,

I may have explained the issue incorrectly. The issue here is that ChangeCollection for a list does not return "delete" change type events. It returns only "Add" & "Update" with Change Query.

In the below code sample, the ChangeCollection is not returning deleted item changes.

ChangeQuery cq = new ChangeQuery(false, false); cq.Item = true; //cq.File = true; cq.DeleteObject = true; cq.Add = true; cq.Update = true; cq.ChangeTokenStart = new ChangeToken(); cq.ChangeTokenStart.StringValue = string.Format("1;3;{0};{1};-1", list.Id.ToString(), DateTime.Now.AddDays(-4).ToUniversalTime().Ticks.ToString()); ChangeCollection coll = list.GetChanges(cq); cc.Load(coll); cc.ExecuteQuery();

RaytheonXie_MSFT 31,071 Reputation points Microsoft Vendor

2022-04-15T02:25:34.84+00:00

Hi @Sonith Chebathini (LARSEN & TOUBRO INFOTECH LIMIT) ,
Per my test, I can retrieve deleted item by following code. You can make a reference

using (ClientContext ctx = new ClientContext(weburl)) { ctx.Credentials = credentials; Web oweb = ctx.Web; ListCollection lists = oweb.Lists; List targetList = lists.GetByTitle(listTitle); ListItem targetItem = targetList.GetItemById(itemid); //ChangeQuery helps the method gets the changes by setting appropriate property as true ChangeQuery cq = new ChangeQuery(); cq.Item = true; cq.Add = true; cq.Update = true; cq.DeleteObject = true; //SP.ListItem.GetChanges(ChangeQuery) - Method available from CSOM Assembly version - 16.1.4727.1200 ChangeCollection cc = targetItem.GetChanges(cq); ctx.Load(cc); ctx.ExecuteQuery(); Console.WriteLine(cc.Count.ToString()); }

RaytheonXie_MSFT 31,071 Reputation points Microsoft Vendor

2022-04-18T08:09:11.137+00:00

Hi @Sonith Chebathini (LARSEN & TOUBRO INFOTECH LIMIT) ,
Have you tried the solution I proposed?

If you have any questions or progress, you can contact me in time.

Looking forward to your reply

Have a lucky day!

Thanks,
Raytheon Xie

RaytheonXie_MSFT 31,071 Reputation points Microsoft Vendor

2022-05-10T09:50:06.717+00:00

Hi @Sonith Chebathini (LARSEN & TOUBRO INFOTECH LIMIT) ,
Did the answer help you? If you have any question about the issue, please feel free to reply.
Sign in to comment