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 36,821 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 36,821 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 36,821 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 36,821 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

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Sharepoint CSOM Change Log query is not displaying item deleted logs

1 answer

Your answer