How can I use the Get-PnPFile or Get-PnPListItems commands to get data from a URL with the structure /_layouts/15/Doc.aspx?sourcedoc=?

Question

Good morning.

I hope you are.

I am trying to get information from files that are in SharePoint document libraries. But many of the URLs I have have the following structure:

https://<tenant>.sharepoint.com/:w:/r/sites/<site url>/_layouts/15/Doc.aspx?sourcedoc=xxxxx-xxxx-xxxx-xxxxx&file=xxxxxxxxxxxxx.docx&action=default&mobileredirect=true

I have not been able to use the sourcedoc or file parameter with the Get-PnPFile or Get-PnPListItems commands.

Is there any way I can get information with SharePoint Online PnP commands from a file that has a URL with this structure?

I hope you can help me.

Answer 1

Hi @Jairo Javier Baleta Cali，

Could try to use GetFileByUrl to resolve the issue. Please refer to following script

$credential = Get-Credential
Connect-PnPOnline –Url "https://contoso.sharepoint.com" –Credentials $credential
$ctx = Get-PnPContext  
$web = Get-PnPWeb 
Write-Host "Web: " $web.Url
$item = $web.GetFileByUrl("https://<tenant>.sharepoint.com/:w:/r/sites/<site url>......")
$ctx.Load($item)
$ctx.ExecuteQuery()
Write-Host "Item:" $item.Name
$ctx = $null

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

There is no Get-PnPFile command for SharePoint that I'm aware of. Are you referring to the third party library PnP? If so then you need to contact the developers of that library as they can better support you.