How to get Sharepoint File Name from File URL using API

[corprodoc]

Hey,

I have an App in Glide. My client adds a sharepoint URL in the app. We want to extract/get file Name from this URL. I believe this can be done only using API.
Here is an example link: https://{examplesite}.sharepoint.com//s/TestTeam/EcdKY-JIzxBAvKf-08gsUaABJ1yo-CXh968uPsyYl-J7gw?e=GVXxzt

I have no idea how to do this. Can someone help me? We use Pabbly connect for all our automation requirements / API calls.

 

[Preeti Paryani]

Hello @corprodoc

Could you confirm if the file name is included in the URL, or if it contains a file ID? If so, please point out the specific part of the URL where it's mentioned. This will help us guide you better in extracting the required information.

 

[corprodoc]

It does not contain File Name. It must be having some Item ID or File ID. While going through some of the articles on internet, I understand that, this Sharepoint URL has some Item ID, Drive ID and Site ID.

 

[Preeti Paryani]

Hello @corprodoc,

You can try using the following endpoint to retrieve the file information based on the file ID:

https://graph.microsoft.com/v1.0/me/drive/items/{file-id}

To implement this, you can extract the file ID from the SharePoint URL using the text formatter. Once extracted, you can map it to the endpoint.

For this setup, you will need to establish a connection with Microsoft Excel and use the Custom API Request action in Pabbly Connect. This will allow you to pass the file ID to the endpoint and retrieve the file details.