Using Microsoft Graph Explorer to Debug SharePoint Filters in Link Enterprise Middleware

4 min

1\ purpose demonstrated how to use microsoft graph explorer to debug sharepoint filters in link enterprise middleware this helps identify whether issues originate from microsoft graph or the middleware layer 2\ tools & references graph explorer https //developer microsoft com/en us/graph/graph explorer demo tenant (yourtenant) sharepoint com sample site id https //graph microsoft com/v1 0/sites/(yourtenant) sharepoint com /sites/vfsgmiddleware sample library /vfsgmiddleware/equip/ 3\ benefits of using graph explorer test filters instantly without restarting middleware isolate root causes between graph and link enterprise discover internal sharepoint field names simulate customer scenarios for debugging 4\ corrected graph api filter example correct syntax https //graph microsoft com/v1 0/sites/ /list/items?$expand=fields&$filter=fields/sapfacility eq 'complete' and fields/linketnerprisesaplinkerror0 ne 'true' url encoded version (for code) ?$expand=fields&$filter=fields/sapfacility%20eq%20'complete'%20and%20fields/linketnerprisesaplinkerror0%20ne%20'true' 5\ boolean field values value boolean 0 false 1 true 6\ common pitfalls mistake result using = instead of eq filter ignored missing fields/ prefix query fails or returns incorrect results unindexed fields filter errors unless workaround header used null boolean values ignored by graph api