Getting a DriveItem object from msgraph using relative path

[mikisDeWitte]

I'm trying to download a file from sharepoint using the microsoft SDK for python msgraph-sdk (https://github.com/microsoftgraph/msgrap.../tree/main).

According to the documentation, there are two primary ways of addressing a driveItem resource:
* By the driveItem unique identifier using drive/items/{item-id}
* By file system path using /drive/root:/path/to/file

I'm using the 2nd approach (which points here: https://learn.microsoft.com/en-us/graph/...driveitems)
The webUrl to my file = https://myCompany.sharepoint.com/:x:/r/sites/MySite/Shared%20Documents/Relative/Path/To/file.xlsx
So I would expect that my graph url would be
https://graph.microsoft.com/v1.0/sites/myCompany.sharepoint.com:/drives/{id of Shared%20Documents}/root:/Relative/Path/To/file.xlsx

I originally went ahead with the approach here:
https://stackoverflow.com/questions/7896...m-onedrive

childItems = await self.client.drives.by_drive_id(drive_id)
               .items.by_drive_item_id('root').children.get()

But this only gets the folders directly under my Shared Documents folder (in my case, the Relative folder)
I guess I could start writing a recursive function to follow the crumbs, but that feels like a hack for a super common feature?

This is essentially my code:

from msgraph import GraphServiceClient
from azure.identity.aio import ClientSecretCredential
import asyncio

site_domain = "myCompany.sharepoint.com"
api_base_url = "https://graph.microsoft.com/v1.0"

# get the site id
async def get_site_id_by_name(client: GraphServiceClient, site_name: str) -> str:
    # this works nicely
    raw_url = f'{api_base_url}/{site_domain}:/sites/{site_name}'
    site_with_raw_url = await .client.sites.with_url(raw_url=raw_url).get()
    return site_with_raw_url.additional_data.get('id', '')

async def get_file_from_web_url(client: GraphServiceClient, site_id: str, web_url: str) -> Optional[DriveItem]:
    query_params = GetAllSitesRequestBuilder.GetAllSitesRequestBuilderGetQueryParameters(
        filter=f"webUrl eq '{web_url}'",
    )
    request_configuration = RequestConfiguration(query_parameters=query_params)

    drive = await client.sites.by_site_id(site_id).drive.get(request_configuration=request_configuration)

    #What I thought would work, but doesn't:
    from urllib.parse import quote
    # https://graph.microsoft.com/v1.0/sites/myCompany.sharepoint.com:/drive/[driveID]:/Relative/Path/To/file.xlsx
    raw_url = f'{self.api_base_url}/{self.site_domain}:/drives/{drive.id}/root:/{quote(web_url)}'
    result = await (
        client
        .drives.by_drive_id(drive.id)
        .with_url(raw_url=web_url)
        .get()
    )

async def execute_functions(client: GraphServiceClient):
    site_id = await get_site_id_by_name(client, "MySite")
    file = await get_file_from_web_url(site_id, "Relative/Path/To/file.xlsx")


credentials = ClientSecretCredential(
            tenant_id='tenant_id',
            client_id='client_id',
            client_secret='client_secret'
)
client = GraphServiceClient(
	credentials=credentials,
	scopes=['https://graph.microsoft.com/.default']
)

asyncio.run(execute_functions(client))

But I keep getting
error: MainError(..., message='Url specified is invalid.', target=None)

Anybody having any clue as to how I can easily turn my webUrl into a DriveItem object

[mikisDeWitte]

Perhaps this can help someone in the future...

The URL should be

api_base_url = "https://graph.microsoft.com/v1.0"
site_domain = "myCompany.sharepoint.com"
from urllib.parse import quote

raw_url = f'{api_base_url}/{site_domain}/drives/{drive.id}/root:/{quote(web_url)}:/content'

So drives/root should've been drives/drive_id/root (doesn't feel very well documented)