Unable to Retrieve Deleting User Email from IChangeItem DeleteObject Event in GetChanges()

[Joaolfelicio]

Category

• Domain model extension

Describe the domain model extension

We have a function (Function A) that invokes GetChanges() and processes only IChangeItem changes. Each change is published to a single queue, where another function (Function B) picks it up, enriches the data, and distributes it to a different system.

The issue arises when handling DeleteObject events. In Function B, we need to retrieve the email of the user who deleted the item for enrichment.

Challenges Faced:

• Initially, we attempted to fetch the recycle bin item by matching the deleted time with the change time. However, this approach fails when multiple users delete different files within the same second.
• We considered filtering further using ServerRelativeUrl from IChangeItem, but it is always an empty string.
• Another approach involved using Editor and EditorEmailHint from IChangeItem, and avoiding the need to query the RecycleBin, but these values are also always null or empty.

Model

Model: IChangeItem
Properties: DeleteObject, ServerRelativeUrl, Editor, EditorEmailHint

APIs

API: https://<tenant>.sharepoint.com/sites/<site>/_api/web/lists(guid'<listId>')/GetChanges()

Additional Information

• Enumerating changes that happened in SharePoint
• Looking for a reliable method to associate a DeleteObject change with the correct user when multiple deletions occur at the same timestamp.