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.