File Picker v8 Returns Non-Persistent URLs for SharePoint Files

[capedrolima]

Description:

We are experiencing an issue with the File Picker v8 for Microsoft 365 where the URLs and Id's returned for selected SharePoint files become invalid if the file is moved to another site and folders (for some type of files). The webUrl, webDavUrl and sharePoint.embedUrl fields in the returned JSON reference the file’s static location/ID out to the , which breaks upon relocation. This behavior is problematic as it prevents us from maintaining persistent links to files selected via the File Picker.

Steps to Reproduce:

• Open the File Picker v8 and select a file from SharePoint.
• Retrieve the webUrl from the returned JSON.
• Move the selected file to another SharePoint site.
• Attempt to access the file using the previously stored webUrl, webDavUrl and sharePoint.embedUrl.
  - Observe that the URL is no longer valid (results in a 404 error).

Expected Behavior:
The File Picker v8 should return a persistent URL or an identifier that allows accessing the file even after it is moved.

Suggested Improvement:
Include a field in the File Picker v8 JSON response that provides a persistent URL or a SharePoint/Graph API reference that remains valid even if the file is moved.

Supporting Information:
Below is an example of the JSON response returned by the File Picker v8:

{
	"command": "pick",
	"items": [
		{
			"name": "BMP File.bmp",
			"**webDavUrl**": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/BMP%20File.bmp",
			"**webUrl**": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/BMP%20File.bmp",
			"size": 1027510,
			"photo": {},
			"id": "01PVONFUT4LD4JGQDJPBHJC365AIHYMSHS",
			"parentReference": {
				"driveId": "b!W4aBre4LKUGBm1BEtBpdi3Z8XxKB1shNshOntucSKq_T6477cv7gQaVS3SnQlizM",
				"sharepointIds": {
					"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
					"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
					"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
					"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
				}
			},
			"sharepointIds": {
				"listItemUniqueId": "93f8587c-6940-4e78-916f-dd020f8648f2",
				"listItemId": "1345",
				"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
				"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
				"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
				"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
			},
			"@sharePoint.embedUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Embed.aspx?UniqueId=93f8587c%2D6940%2D4e78%2D916f%2Ddd020f8648f2",
			"@sharePoint.endpoint": "https://mydevelopment.sharepoint.com/_api/v2.0",
			"@sharePoint.listUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents"
		},
		{
			"name": "CCM Word Test Document - Enterprise2.docx",
			"webDavUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/CCM%20Word%20Test%20Document%20-%20Enterprise2.docx",
			"webUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Doc.aspx?sourcedoc=%7B9FA393E3-BB39-4903-8DFE-9B53719F351A%7D&file=CCM%20Word%20Test%20Document%20-%20Enterprise2.docx&action=default&mobileredirect=true",
			"size": 22126,
			"id": "01PVONFUXDSORZ6ON3ANEY37U3KNYZ6NI2",
			"parentReference": {
				"driveId": "b!W4aBre4LKUGBm1BEtBpdi3Z8XxKB1shNshOntucSKq_T6477cv7gQaVS3SnQlizM",
				"sharepointIds": {
					"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
					"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
					"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
					"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
				}
			},
			"sharepointIds": {
				"listItemUniqueId": "9fa393e3-bb39-4903-8dfe-9b53719f351a",
				"listItemId": "1329",
				"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
				"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
				"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
				"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
			},
			"@sharePoint.embedUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Embed.aspx?UniqueId=9fa393e3%2Dbb39%2D4903%2D8dfe%2D9b53719f351a",
			"@sharePoint.endpoint": "https://mydevelopment.sharepoint.com/_api/v2.0",
			"@sharePoint.listUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents"
		},
		{
			"name": "Email - Outlook - Bug Base assignment notice2.msg",
			"webDavUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/Email%20-%20Outlook%20-%20Bug%20Base%20assignment%20notice2.msg",
			"webUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/Email%20-%20Outlook%20-%20Bug%20Base%20assignment%20notice2.msg",
			"size": 55296,
			"id": "01PVONFUTLUQNDOH2ZZBDY5AI4EJVP3DM3",
			"parentReference": {
				"driveId": "b!W4aBre4LKUGBm1BEtBpdi3Z8XxKB1shNshOntucSKq_T6477cv7gQaVS3SnQlizM",
				"sharepointIds": {
					"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
					"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
					"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
					"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
				}
			},
			"sharepointIds": {
				"listItemUniqueId": "371aa46b-591f-47c8-8e81-1c226afd8d9b",
				"listItemId": "1351",
				"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
				"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
				"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
				"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
			},
			"@sharePoint.embedUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Embed.aspx?UniqueId=371aa46b%2D591f%2D47c8%2D8e81%2D1c226afd8d9b",
			"@sharePoint.endpoint": "https://mydevelopment.sharepoint.com/_api/v2.0",
			"@sharePoint.listUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents"
		},
		{
			"name": "Excel 97-2003 Test Worksheet2.xls",
			"webDavUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/Excel%2097-2003%20Test%20Worksheet2.xls",
			"webUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Doc.aspx?sourcedoc=%7B497A71BB-FCD2-4BE9-A7C8-6BDAAD7A2819%7D&file=Excel%2097-2003%20Test%20Worksheet2.xls&action=default&mobileredirect=true",
			"size": 43520,
			"id": "01PVONFUV3OF5ETUX45FF2PSDL3KWXUKAZ",
			"parentReference": {
				"driveId": "b!W4aBre4LKUGBm1BEtBpdi3Z8XxKB1shNshOntucSKq_T6477cv7gQaVS3SnQlizM",
				"sharepointIds": {
					"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
					"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
					"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
					"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
				}
			},
			"sharepointIds": {
				"listItemUniqueId": "497a71bb-fcd2-4be9-a7c8-6bdaad7a2819",
				"listItemId": "1341",
				"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
				"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
				"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
				"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
			},
			"@sharePoint.embedUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Embed.aspx?UniqueId=497a71bb%2Dfcd2%2D4be9%2Da7c8%2D6bdaad7a2819",
			"@sharePoint.endpoint": "https://mydevelopment.sharepoint.com/_api/v2.0",
			"@sharePoint.listUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents"
		},
		{
			"name": "filelist2.txt",
			"webDavUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/filelist2.txt",
			"webUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/filelist2.txt",
			"size": 5592,
			"id": "01PVONFURA3TJTHVNNKRGLKCO4OEUTFWD3",
			"parentReference": {
				"driveId": "b!W4aBre4LKUGBm1BEtBpdi3Z8XxKB1shNshOntucSKq_T6477cv7gQaVS3SnQlizM",
				"sharepointIds": {
					"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
					"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
					"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
					"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
				}
			},
			"sharepointIds": {
				"listItemUniqueId": "33d3dc20-add5-4c54-b509-dc712932d87b",
				"listItemId": "1361",
				"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
				"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
				"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
				"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
			},
			"@sharePoint.embedUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Embed.aspx?UniqueId=33d3dc20%2Dadd5%2D4c54%2Db509%2Ddc712932d87b",
			"@sharePoint.endpoint": "https://mydevelopment.sharepoint.com/_api/v2.0",
			"@sharePoint.listUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents"
		},
		{
			"name": "JPEG Test Image - eDOCS 16_52.JPG",
			"webDavUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/JPEG%20Test%20Image%20-%20eDOCS%2016_52.JPG",
			"webUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents/Testing%20SharePoint%20Links/JPEG%20Test%20Image%20-%20eDOCS%2016_52.JPG",
			"size": 22578,
			"photo": {},
			"id": "01PVONFUXOF5B4RXBYFJBJP7WIKYNTCQ3S",
			"parentReference": {
				"driveId": "b!W4aBre4LKUGBm1BEtBpdi3Z8XxKB1shNshOntucSKq_T6477cv7gQaVS3SnQlizM",
				"sharepointIds": {
					"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
					"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
					"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
					"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
				}
			},
			"sharepointIds": {
				"listItemUniqueId": "c8432fee-38dc-422a-97fe-c8561b314372",
				"listItemId": "1337",
				"listId": "fb8eebd3-fe72-41e0-a552-dd29d0962ccc",
				"webId": "125f7c76-d681-4dc8-b213-a7b6e7122aaf",
				"siteId": "ad81865b-0bee-4129-819b-5044b41a5d8b",
				"siteUrl": "https://mydevelopment.sharepoint.com/sites/Site1"
			},
			"@sharePoint.embedUrl": "https://mydevelopment.sharepoint.com/sites/Site1/_layouts/15/Embed.aspx?UniqueId=c8432fee%2D38dc%2D422a%2D97fe%2Dc8561b314372",
			"@sharePoint.endpoint": "https://mydevelopment.sharepoint.com/_api/v2.0",
			"@sharePoint.listUrl": "https://mydevelopment.sharepoint.com/sites/Site1/Shared%20Documents"
		}
	],
	"sites": [],
	"keepSharing": false
}

[JCrew0]

@capedrolima you should be able to use the Microsoft Graph API to dynamically fetch the URL of a file based on its ID. You'd have to make a GET to something like "https://graph.microsoft.com/v1.0/me/drive/items/{file_id}" I believe. Can you give that a try and let me know how it works?