• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

How to get Sharepoint File Name from File URL using API

corprodoc

Member
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

Well-known member
Staff member
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

Member
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.

1733901050220.png
 

Preeti Paryani

Well-known member
Staff member
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.

1733917095679.png


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.
 
Top