I am using Graph API to filter a SharePoint list by using $filter=fields/_ModerationStatus eq 0
. This gives me only the items whose most recent approval status is Approved.
I have some items that were approved and then some one made an edit to them so they are Pending approval status.
What I would like is some filter I could use on my api call that would return the approved versions of anything approved AND the approved version of anything that has a pending status.
We are able to get all the versions of a specific item (using /items/${itemId}/versions?expand=fields
) but this is one query for each item. Ideally we would be able to combine these so we can get just the approved versions of everything in the list.
Is this possible?