ODP|ODB: OneDrive API query for driveItem details fails to respond with data despite being requested in select statement

[abraunegg]

Category

• Question
• Documentation issue
• Bug

Expected or Desired Behavior

@ificator
The GetPathDetailsByID API query should return ALL details as specified in the query submission.

Observed Behavior

@ificator
As per https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_get?view=odsp-graph-online the following API query is being used:

https://graph.microsoft.com/v1.0/drives/cbbc790e554348af/items/CBBC790E554348AF!38760?select=id,name,eTag,cTag,deleted,file,folder,root,fileSystemInfo,remoteItem,parentReference,size,webUrl,lastModifiedBy,lastModifiedDateTime

The actual response provided by the OneDrive API is missing (for this query item) the 'folder' response .. despite:

1. The path online is a folder
2. The request contains in the select statement to respond with the folder element.

The response being observed from the OneDrive API is as follows:

{"@odata.context":"https:\/\/graph.microsoft.com\/v1.0\/$metadata#drives('cbbc790e554348af')\/items\/$entity","cTag":"adDpDQkJDNzkwRTU1NDM0OEFGITM4NzYwLjYzODU3NTEyMDU3ODkzMDAwMA","eTag":"aQ0JCQzc5MEU1NTQzNDhBRiEzODc2MC4w","fileSystemInfo":{"createdDateTime":"2024-04-29T06:10:48.173Z","lastModifiedDateTime":"2024-04-29T06:10:48.173Z"},"id":"CBBC790E554348AF!38760","lastModifiedBy":{"application":{"displayName":"MSOffice15","id":"480728c5"},"user":{"displayName":"Benjamin Diethelm","id":"cbbc790e554348af"}},"lastModifiedDateTime":"2024-07-25T13:47:37.893Z","name":"ETH","parentReference":{"driveId":"cbbc790e554348af","driveType":"personal","id":"CBBC790E554348AF!106","name":"Dokumente","path":"\/drive\/root:\/Dokumente"},"size":12362247,"webUrl":"https:\/\/1drv.ms\/o\/s!AK9IQ1UOebzLgq5o"}

This is being observed against European Data Centres (which always seem to have API response consistency issues).

A full request|response sequence is below:

DEBUG: createLocalPathStructure input onedriveJSONItem: {"cTag":"aYzpDQkJDNzkwRTU1NDM0OEFGITM5MTE0Ljg2MDY5","eTag":"aQ0JCQzc5MEU1NTQzNDhBRiEzOTExNC41NTk","file":{"mimeType":"application\/msonenote"},"fileSystemInfo":{"createdDateTime":"2024-06-03T07:33:34.533Z","lastModifiedDateTime":"2024-06-11T07:06:37.11Z"},"id":"CBBC790E554348AF!39114","name":"notes.one","parentReference":{"driveId":"cbbc790e554348af","driveType":"personal","id":"CBBC790E554348AF!38760","name":"ETH","path":"\/drive\/root:\/Dokumente\/ETH"},"size":6176970}
DEBUG: Request URL = https://graph.microsoft.com/v1.0/drives/cbbc790e554348af/items/CBBC790E554348AF!38760?select=id,name,eTag,cTag,deleted,file,folder,root,fileSystemInfo,remoteItem,parentReference,size,webUrl,lastModifiedBy,lastModifiedDateTime
DEBUG: Existing Microsoft OneDrive Access Token Expires: 2024-Oct-30 11:32:09.8395797
DEBUG: HTTP Response Headers: ["strict-transport-security":"max-age=31536000", "x-ms-ags-diagnostic":"{\"ServerInfo\":{\"DataCenter\":\"Switzerland North\",\"Slice\":\"E\",\"Ring\":\"3\",\"ScaleUnit\":\"002\",\"RoleInstance\":\"ZR2PEPF00000239\"}}", "odata-version":"4.0", "date":"Wed, 30 Oct 2024 09:32:12 GMT", "client-request-id":"5d7ba54b-f3eb-4501-bcc7-7fd717ca4fa2", "request-id":"5d7ba54b-f3eb-4501-bcc7-7fd717ca4fa2", "cache-control":"private", "content-type":"application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false;charset=utf-8"]
DEBUG: HTTP Status Line: 200  (2.0)
DEBUG: CurlEngine cleanup() called on instance id: EcRdbJjy9exT5lUt
DEBUG: saveItem - creating DB item from this JSON: {"@odata.context":"https:\/\/graph.microsoft.com\/v1.0\/$metadata#drives('cbbc790e554348af')\/items\/$entity","cTag":"adDpDQkJDNzkwRTU1NDM0OEFGITM4NzYwLjYzODU3NTEyMDU3ODkzMDAwMA","eTag":"aQ0JCQzc5MEU1NTQzNDhBRiEzODc2MC4w","fileSystemInfo":{"createdDateTime":"2024-04-29T06:10:48.173Z","lastModifiedDateTime":"2024-04-29T06:10:48.173Z"},"id":"CBBC790E554348AF!38760","lastModifiedBy":{"application":{"displayName":"MSOffice15","id":"480728c5"},"user":{"displayName":"Benjamin Diethelm","id":"cbbc790e554348af"}},"lastModifiedDateTime":"2024-07-25T13:47:37.893Z","name":"ETH","parentReference":{"driveId":"cbbc790e554348af","driveType":"personal","id":"CBBC790E554348AF!106","name":"Dokumente","path":"\/drive\/root:\/Dokumente"},"size":12362247,"webUrl":"https:\/\/1drv.ms\/o\/s!AK9IQ1UOebzLgq5o"}

Steps to Reproduce

@ificator
Construct a drive idem query using the driveid and itemid and submit that query against a European Data Centre.

[ ]: http://aka.ms/onedrive-api-issues
[x]: http://aka.ms/onedrive-api-issues