Get retention policy labels from files or libraries on SharePoint online

Hi @xp ,

I apply a label on a file and I could get it through below endpoint:

More references:

• https://sharepoint.stackexchange.com/questions/284004/how-to-read-retention-label-applied-column-using-rest-api-or-caml-query

Best Regards,
Baker Kong

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.

The other way is using PowerShell

This way I make a report with the retention labels in a Library

NOTE: Requiere to install PnP.PowerShell
cmdlet: Install-Module -Name PnP.PowerShell

# To Create Report file localy  
$CSVFile = "C:\ReportLocation\ListItem.csv"  
  
    $SiteURL = "https://companysite.sharepoint.com/sites/SiteNaame"  
    $xmlQuery =  "<View Scope='RecursiveAll'><RowLimit>5000</RowLimit></View>"  
      
    Connect-PnPOnline -Url $SiteURL -UseWebLogin  
    $Lists= Get-PnPList | Where {$_.BaseTemplate -eq 101 -and $_.Hidden -eq $false}  
      
       foreach ($List in $Lists){   
          $ListItems = Get-PnPListItem -List $List.Title -PageSize 5000 -Query $xmlQuery  
               ForEach($Item in $ListItems) {   
                  #Collect Documents Data  
                   $Data = new-object PSObject  
                   $Data | Add-member NoteProperty -Name "ID" -Value $List.Id  
                   $Data | Add-member NoteProperty -Name "List Title" -Value $List.Title  
                   $Data | Add-member NoteProperty -Name "File URL" -Value $Item.fieldvalues.FileRef  
                   $Data | Add-member NoteProperty -Name "File Name" -Value $Item.FieldValues.FileLeafRef  
                   $Data | Add-member NoteProperty -Name "Type" -Value $Item.FieldValues.FSObjType  
                   $Data | Add-member NoteProperty -Name "Label" -Value $Item.FieldValues._ComplianceTag  
                    $ListInventory += $Data  
              }  
     }  
  
# Save Report locally  
$ListInventory | Export-CSV $CSVFile -NoTypeInformation  

 
      

such endpoint may not be available publicly: we faced with similar issue when needed to get list of sensitivity labels settings (like does each label allows external users or should group be public or private). There is no public API for that currently.

However what you can try is to analyze network traffic with Fiddler or browser network tab on the form where you see list of all retention labels. It may be so that you will find some non-public API calls which return what you need.