How to get drive item by path

[susanYYT]

Hi,

I'm using Graph v6, and I want to get DriveItem by path.

In v5, I use:
DriveItem item = graphClient.sites(site.id).drives(d.id).root().itemWithPath(itemPath).buildRequest().get();
Now I use
DriveItem item = graphClient.drives().byDriveId(d.getId()).items().byDriveItemId(itemPath).get();
But I received error:
com.microsoft.graph.models.odataerrors.ODataError: Item not found

Does the input itemPath has something special in format?

For example, if my siteUrl is myshare.sharepoint.com/sites/test1, then if I get site by path, I can use myshare.sharepoint.com:/sites/test1: as input. While for drive item, the sheet relative path is /test1/AdapterOffice365/DPtest.xls/int. Could you please give me an example?

Best regards,
Susan

[Ndiritu]

Hi @susanYYT
Thank you for reaching out.
Please see a similar issue here
The relative path for your drive item should be root:/test1/AdapterOffice365/DPtest.xls/int:

Please let me know if this helps

[susanYYT]

Could the relative path contains _ ? I actually try root:/A_test1/AdapterOffice365/DPtest.xls/int: , but it doesn't work.

[susanYYT]

@Ndiritu Could you give some suggestions?

[Ndiritu]

Sorry for the delay @susanYYT.

Yes, based on the guidance here, underscores are allowed.

I'm wondering if your path is correct, is the /int at the end of the URL valid?

You can test your request path using https://developer.microsoft.com/en-us/graph/graph-explorer to double-check.

If you still have trouble, you can pass a custom URL using withUrl() to override the entire request URL:

graphClient.drives().byDriveId("").items().byDriveItemId("").withUrl(
    "https://graph.microsoft.com/v1.0/..."
).get();

[susanYYT]

Dear @Ndiritu,

Thanks for your reply. Maybe I have some misunderstanding about the root:/path/to/file. int is a sheet in the DPtest.xls. I've changed the path to /root:/A_test1/AdapterOffice365/DPtest.xls: . But still have some trouble. Could you correct me?

The site url is: https://test.sharepoint.com/sites/A_test1
So I can download the file if I visit weburl https://test.sharepoint.com/sites/A_test1/AdapterOffice365/DPtest.xls

I tried the graph explorer, https://graph.microsoft.com/v1.0/drive/root:/A_test1/AdapterOffice365/DPtest.xls: , but it reports assess denied.

I want to consent to permissions but it shows "Retry again". Any suggestions?