ODATA filter query doesn't work, neither Title eq, substringof() or startswith()

[taylorhickem]

Describe the Bug with repro steps

This file, along with others with similar name, exists in Sharepoint folder X, you can verify this in the detailed API response with filter removed that indeed the file exists in the folder

TW - Completed Projects_Nov24.xlsx

I create a logic app with Sharepoint list files (properties only) to list files in the folder X, and I get the correct results.

When I add a filter query, neither of these work

substringof('Completed Projects', Title) --> returns empty list

startswith(Title, 'TW') --> returns empty list

Title eq 'TW - Completed Projects_Nov24.xlsx' --> returns empty list

REQUEST (without filter)

{

"method": "get",

"queries": {

"folderPath": "/Shared Documents/Current/Contract"

},

"path": "/datasets/https%253A%252F%252Fmwhtreatmentltd.sharepoint.com%252Fsites%252FMWHProjectControlsReporting/tables/5d4880e0-391f-4b97-b2ed-1cc935cb6913/getfileitems",

"host": {

"connection": {

"name": "/subscriptions/b2cd812f-7af4-4fa8-a4ad-4a55b7f4f559/resourceGroups/rg-dataplatform/providers/Microsoft.Web/connections/sharepointonline-1"

}

}

}

RESPONSE (without filter)

{

"statusCode": 200,

"headers": {

"Cache-Control": "max-age=0, private",

"Transfer-Encoding": "chunked",

"Vary": "Origin,Accept-Encoding",

"X-NetworkStatistics": "0,525568,0,0,35322,0,39703,107",

"X-SharePointHealthScore": "3",

"X-MS-SPConnector": "1",

"X-SP-SERVERSTATE": "ReadOnly=0",

"DATASERVICEVERSION": "3.0",

"SPClientServiceRequestDuration": "151",

"SPRequestDuration": "151",

"X-DataBoundary": "EU",

"X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",

"X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0",

"SPRequestGuid": "1e313cbe-fa34-40fc-9cfd-6d88273bd9a5",

"request-id": "1e313cbe-fa34-40fc-9cfd-6d88273bd9a5",

"MS-CV": "oXmZDhegALAKadpIlL3JRA.0",

"Alt-Svc": "h3=":443"",

"Strict-Transport-Security": "max-age=31536000",

"X-Frame-Options": "SAMEORIGIN",

"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com app.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",

"MicrosoftSharePointTeamServices": "16.0.0.25611",

"X-Content-Type-Options": "nosniff",

"X-MS-InvokeApp": "1; RequireReadOnly",

"P3P": "CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"",

"X-AspNet-Version": "4.0.30319",

"X-Powered-By": "ASP.NET",

"x-ms-dlp-re": "-|-",

"x-ms-dlp-gu": "-|-",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "false",

"x-ms-apihub-obo": "false",

"Date": "Tue, 21 Jan 2025 05:44:27 GMT",

"Content-Type": "application/json; charset=utf-8",

"Content-Length": "37349",

"Expires": "Mon, 06 Jan 2025 05:44:27 GMT",

"Last-Modified": "Tue, 21 Jan 2025 05:44:27 GMT"

},

"body": {

"value": [

{

"@odata.etag": ""16"",

"ItemInternalId": "298",

"ID": 298,

"Modified": "2024-11-29T11:01:22Z",

"Editor": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Editor#Claims": "i:0#.f|membership|[email protected]",

"SharedWithUsers": [],

"[email protected]": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",

"SharedWithUsers#Claims": [],

"SharedWithUsers#[email protected]": "#Collection(String)",

"Created": "2024-02-12T07:56:19Z",

"Author": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Matthew Tingley",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "312 - Operations Thames",

"JobTitle": "Digital Delivery Lead"

},

"Author#Claims": "i:0#.f|membership|[email protected]",

"OData__DisplayName": "",

"{Identifier}": "Shared%2bDocuments%252fCurrent%252fContract%252fTW-Completed%2bProjects%2bfor%2bKPIs%2b-%2bRev.1.xlsx",

"{IsFolder}": false,

"{Thumbnail}": {

"Large": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEAV5HJGD466IVDI46HJ43RYUMEU%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=800&height=800",

"Medium": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEAV5HJGD466IVDI46HJ43RYUMEU%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=176&height=176",

"Small": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEAV5HJGD466IVDI46HJ43RYUMEU%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=96&height=96"

},

"{Link}": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/Shared%20Documents/Current/Contract/TW-Completed%20Projects%20for%20KPIs%20-%20Rev.1.xlsx?d=w61d2e915def346458e78e9e6e38a3094",

"{Name}": "TW-Completed Projects for KPIs - Rev.1",

"{FilenameWithExtension}": "TW-Completed Projects for KPIs - Rev.1.xlsx",

"{Path}": "Shared Documents/Current/Contract/",

"{FullPath}": "Shared Documents/Current/Contract/TW-Completed Projects for KPIs - Rev.1.xlsx",

"{IsCheckedOut}": false,

"{DriveId}": "b!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT",

"{DriveItemId}": "01NRHWNEAV5HJGD466IVDI46HJ43RYUMEU",

"{VersionNumber}": "12.0"

},

{

"@odata.etag": ""23"",

"ItemInternalId": "355",

"ID": 355,

"Modified": "2024-08-15T14:43:17Z",

"Editor": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Editor#Claims": "i:0#.f|membership|[email protected]",

"SharedWithUsers": [],

"[email protected]": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",

"SharedWithUsers#Claims": [],

"SharedWithUsers#[email protected]": "#Collection(String)",

"Created": "2024-04-02T13:19:49Z",

"Author": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Author#Claims": "i:0#.f|membership|[email protected]",

"OData__DisplayName": "",

"{Identifier}": "Shared%2bDocuments%252fCurrent%252fContract%252fST-Completed%2bProjects%2bfor%2bKPIs%2b-%2bRev_Mar24.xlsx",

"{IsFolder}": false,

"{Thumbnail}": {

"Large": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEH6V3WIDKVJTZFZWQMSVBMO232R%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=800&height=800",

"Medium": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEH6V3WIDKVJTZFZWQMSVBMO232R%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=176&height=176",

"Small": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEH6V3WIDKVJTZFZWQMSVBMO232R%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=96&height=96"

},

"{Link}": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/Shared%20Documents/Current/Contract/ST-Completed%20Projects%20for%20KPIs%20-%20Rev\_Mar24.xlsx?d=w81ecaefea9aa4b9e9b4192a858ed6f51",

"{Name}": "ST-Completed Projects for KPIs - Rev_Mar24",

"{FilenameWithExtension}": "ST-Completed Projects for KPIs - Rev_Mar24.xlsx",

"{Path}": "Shared Documents/Current/Contract/",

"{FullPath}": "Shared Documents/Current/Contract/ST-Completed Projects for KPIs - Rev_Mar24.xlsx",

"{IsCheckedOut}": false,

"{DriveId}": "b!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT",

"{DriveItemId}": "01NRHWNEH6V3WIDKVJTZFZWQMSVBMO232R",

"{VersionNumber}": "10.0"

},

{

"@odata.etag": ""14"",

"ItemInternalId": "839",

"ID": 839,

"Modified": "2025-01-03T13:35:11Z",

"Editor": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Editor#Claims": "i:0#.f|membership|[email protected]",

"SharedWithUsers": [],

"[email protected]": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",

"SharedWithUsers#Claims": [],

"SharedWithUsers#[email protected]": "#Collection(String)",

"Created": "2024-12-24T11:27:04Z",

"Author": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Author#Claims": "i:0#.f|membership|[email protected]",

"OData__DisplayName": "",

"{Identifier}": "Shared%2bDocuments%252fCurrent%252fContract%252fST%2b-%2bCompleted%2bProjects%2bfor%2bKPIs%2bDec24%2b-%2bFinal.xlsx",

"{IsFolder}": false,

"{Thumbnail}": {

"Large": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEBPXMEYMU2NEJF2J2OKV5B4BR2I%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=800&height=800",

"Medium": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEBPXMEYMU2NEJF2J2OKV5B4BR2I%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=176&height=176",

"Small": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEBPXMEYMU2NEJF2J2OKV5B4BR2I%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=96&height=96"

},

"{Link}": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/Shared%20Documents/Current/Contract/ST%20-%20Completed%20Projects%20for%20KPIs%20Dec24%20-%20Final.xlsx?d=w8609bb2f4d534b22a4e9caaf43c0c748",

"{Name}": "ST - Completed Projects for KPIs Dec24 - Final",

"{FilenameWithExtension}": "ST - Completed Projects for KPIs Dec24 - Final.xlsx",

"{Path}": "Shared Documents/Current/Contract/",

"{FullPath}": "Shared Documents/Current/Contract/ST - Completed Projects for KPIs Dec24 - Final.xlsx",

"{IsCheckedOut}": false,

"{DriveId}": "b!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT",

"{DriveItemId}": "01NRHWNEBPXMEYMU2NEJF2J2OKV5B4BR2I",

"{VersionNumber}": "7.0"

},

{

"@odata.etag": ""6"",

"ItemInternalId": "846",

"ID": 846,

"Modified": "2025-01-10T11:54:05Z",

"Editor": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Editor#Claims": "i:0#.f|membership|[email protected]",

"SharedWithUsers": [],

"[email protected]": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",

"SharedWithUsers#Claims": [],

"SharedWithUsers#[email protected]": "#Collection(String)",

"Created": "2025-01-06T14:29:07Z",

"Author": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Author#Claims": "i:0#.f|membership|[email protected]",

"OData__DisplayName": "",

"{Identifier}": "Shared%2bDocuments%252fCurrent%252fContract%252fST%2b-%2bCompleted%2bProjects_Dec24.xlsx",

"{IsFolder}": false,

"{Thumbnail}": {

"Large": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEH7GEDJ3ZPC7JBIYYKUCJRDMY52%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=800&height=800",

"Medium": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEH7GEDJ3ZPC7JBIYYKUCJRDMY52%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=176&height=176",

"Small": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEH7GEDJ3ZPC7JBIYYKUCJRDMY52%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=96&height=96"

},

"{Link}": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/Shared%20Documents/Current/Contract/ST%20-%20Completed%20Projects\_Dec24.xlsx?d=w9d0631ffe2e542fa8c615412623663ba",

"{Name}": "ST - Completed Projects_Dec24",

"{FilenameWithExtension}": "ST - Completed Projects_Dec24.xlsx",

"{Path}": "Shared Documents/Current/Contract/",

"{FullPath}": "Shared Documents/Current/Contract/ST - Completed Projects_Dec24.xlsx",

"{IsCheckedOut}": false,

"{DriveId}": "b!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT",

"{DriveItemId}": "01NRHWNEH7GEDJ3ZPC7JBIYYKUCJRDMY52",

"{VersionNumber}": "5.0"

},

{

"@odata.etag": ""7"",

"ItemInternalId": "849",

"ID": 849,

"Modified": "2025-01-10T11:54:05Z",

"Editor": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Editor#Claims": "i:0#.f|membership|[email protected]",

"SharedWithUsers": [],

"[email protected]": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",

"SharedWithUsers#Claims": [],

"SharedWithUsers#[email protected]": "#Collection(String)",

"Created": "2025-01-06T19:18:00Z",

"Author": {

"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

"Claims": "i:0#.f|membership|[email protected]",

"DisplayName": "Adeola Bakare",

"Email": "[email protected]",

"Picture": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/\_layouts/15/UserPhoto.aspx?Size=L&[email protected]",

"Department": "220 - Information Systems",

"JobTitle": "BI Developer"

},

"Author#Claims": "i:0#.f|membership|[email protected]",

"OData__DisplayName": "",

"{Identifier}": "Shared%2bDocuments%252fCurrent%252fContract%252fTW%2b-%2bCompleted%2bProjects_Nov24.xlsx",

"{IsFolder}": false,

"{Thumbnail}": {

"Large": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEHQY76PSXL5GVFKY7CVEUF4K4YC%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=800&height=800",

"Medium": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEHQY76PSXL5GVFKY7CVEUF4K4YC%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=176&height=176",

"Small": "https://uksouth1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=xlsx&cs=N2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzfFNQTw&docid=https%3a%2f%2fmwhtreatmentltd.sharepoint.com%3a443%2f\_api%2fv2.0%2fdrives%2fb!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT%2fitems%2f01NRHWNEHQY76PSXL5GVFKY7CVEUF4K4YC%3fversion%3dPublished&access\_token=v1.eyJzaXRlaWQiOiJhMjY5YzBhMS0zYWZmLTRmZDAtOGE5Ni1hOGYzZjMwMmRiNDQiLCJhcHBfZGlzcGxheW5hbWUiOiJBcHAgU2VydmljZSIsImFwcGlkIjoiN2FiNzg2MmMtNGM1Ny00OTFlLThhNDUtZDUyYTdlMDIzOTgzIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL213aHRyZWF0bWVudGx0ZC5zaGFyZXBvaW50LmNvbUAzN2Y4NDNiYi01NmNmLTRhNmQtOThiOS0yZWFjMzZlYmI2MDYiLCJleHAiOiIxNzM3NDUwMDAwIn0.CgoKBHNuaWQSAjI2EgYI9vQ6EAEaDjUyLjE2Mi4xMTEuMTk0Kix3bytiVVgxcUgxUllHdzhubjVwSlZzcFJYRlNsZEZhRWJrZzlwcTRkN3I0PTB6OAFKEGhhc2hlZHByb29mdG9rZW5SCFsia21zaSJdcikwaC5mfG1lbWJlcnNoaXB8MTAwMzIwMDNkZmQyNGZkZEBsaXZlLmNvbXoBMoIBEgm7Q\_g3z1ZtShGYuS6sNuu2BpIBBlRheWxvcpoBBkhpY2tlbaIBHnRheWxvci5oaWNrZW1AbXdodHJlYXRtZW50LmNvbaoBEDEwMDMyMDAzREZEMjRGRESyAdYDYWxsZmlsZXMud3JpdGUgYWxsc2l0ZXMuZnVsbGNvbnRyb2wgYWxsc2l0ZXMucmVhZCBncm91cC53cml0ZSBzaGFyZXBvaW50dGVuYW50c2V0dGluZ3MucmVhZHdyaXRlLmFsbCBjb250YWluZXIuc2VsZWN0ZWQgZGFzaGJvYXJkY2FyZC5zZW5kLmFwcCBjb250YWluZXIubWFuYWdlLmFsbCBjb250YWluZXIubWFuYWdlLmFsbCBBZG1pbmlzdHJhdGl2ZS5NYW5hZ2UgQWRtaW5pc3RyYXRpdmUuUmVhZCBCYXNpY1Byb2plY3RBbGwuUmVhZCBCYXNpY1Byb2plY3RBbGwuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5SZWFkIEVudGVycHJpc2VSZXNvdXJjZXMuV3JpdGUgRW50ZXJwcmlzZVJlc291cmNlcy5CeXBhc3NEZWxlZ2F0ZSBTdGF0dXNpbmcuU3VibWl0U3RhdHVzIFJlcG9ydGluZy5SZWFkIGZhc3RTZWFyY2gucXVlcnlzcCBhbGxwcm9maWxlcy5mdWxsY29udHJvbCBhbGxwcm9maWxlcy53cml0ZSB0ZXJtc3RvcmUud3JpdGU.PefUScdrvomjygWXy-WGHujOyMkTmp3gVllluU6wvTI&width=96&height=96"

},

"{Link}": "https://mwhtreatmentltd.sharepoint.com/sites/MWHProjectControlsReporting/Shared%20Documents/Current/Contract/TW%20-%20Completed%20Projects\_Nov24.xlsx?d=wf9fcc7f07d5d4a35ac7c55250bc57302",

"{Name}": "TW - Completed Projects_Nov24",

"{FilenameWithExtension}": "TW - Completed Projects_Nov24.xlsx",

"{Path}": "Shared Documents/Current/Contract/",

"{FullPath}": "Shared Documents/Current/Contract/TW - Completed Projects_Nov24.xlsx",

"{IsCheckedOut}": false,

"{DriveId}": "b!ocBpov860E-Klqjz8wLbRGXFIbwghbZHlXLDnU5VA9PggEhdHzmXS7LtHMk1y2kT",

"{DriveItemId}": "01NRHWNEHQY76PSXL5GVFKY7CVEUF4K4YC",

"{VersionNumber}": "5.0"

}

]

}

}

REQUEST (with filter)

{

"method": "get",

"queries": {

"$filter": "Title eq 'TW - Completed Projects_Nov24.xlsx'",

"folderPath": "/Shared Documents/Current/Contract"

},

"path": "/datasets/https%253A%252F%252Fmwhtreatmentltd.sharepoint.com%252Fsites%252FMWHProjectControlsReporting/tables/5d4880e0-391f-4b97-b2ed-1cc935cb6913/getfileitems",

"host": {

"connection": {

"name": "/subscriptions/b2cd812f-7af4-4fa8-a4ad-4a55b7f4f559/resourceGroups/rg-dataplatform/providers/Microsoft.Web/connections/sharepointonline-1"

}

}

}

RESPONSE (with filter)

{

"statusCode": 200,

"headers": {

"Cache-Control": "max-age=0, private",

"Transfer-Encoding": "chunked",

"Vary": "Origin,Accept-Encoding",

"X-NetworkStatistics": "0,525568,0,0,39351,0,28659,103",

"X-SharePointHealthScore": "2",

"X-MS-SPConnector": "1",

"X-SP-SERVERSTATE": "ReadOnly=0",

"DATASERVICEVERSION": "3.0",

"SPClientServiceRequestDuration": "115",

"SPRequestDuration": "116",

"X-DataBoundary": "EU",

"X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",

"X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0",

"SPRequestGuid": "f1823485-899d-4c32-bf8a-e8036d8aa935",

"request-id": "f1823485-899d-4c32-bf8a-e8036d8aa935",

"MS-CV": "oXmYtLSAALAKad0njZkbQg.0",

"Alt-Svc": "h3=":443"",

"Strict-Transport-Security": "max-age=31536000",

"X-Frame-Options": "SAMEORIGIN",

"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com app.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",

"MicrosoftSharePointTeamServices": "16.0.0.25611",

"X-Content-Type-Options": "nosniff",

"X-MS-InvokeApp": "1; RequireReadOnly",

"P3P": "CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"",

"X-AspNet-Version": "4.0.30319",

"X-Powered-By": "ASP.NET",

"x-ms-dlp-re": "-|-",

"x-ms-dlp-gu": "-|-",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "false",

"x-ms-apihub-obo": "false",

"Date": "Tue, 21 Jan 2025 05:38:21 GMT",

"Content-Type": "application/json; charset=utf-8",

"Content-Length": "12",

"Expires": "Mon, 06 Jan 2025 05:38:21 GMT",

"Last-Modified": "Tue, 21 Jan 2025 05:38:21 GMT"

},

"body": {

"value": []

}

}

What type of Logic App Is this happening in?

Consumption (Portal)

Which operating system are you using?

Windows

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

Screenshots or Videos

No response

Browser

Edge

Additional context

No response