使用PowerShell从SharePoint进口CSV

Question

希望有人能为此提供帮助。

我有一个通过多个站点集合运行的脚本，并在每个站点集合中获取一个特定的CSV文件。我将特定的CSV URL扔到数组中，然后想从该CSV中获取数据并在 foreach 中使用

它是我

Import-Module "\\path\Connect-SharePoint.psm1"


$SPListConnection = Connect-SharePoint -WebUrl "https://site.sharepoint.com/sites/edmsc/Internal" -CheckForAppCredentials
$SPListWeb = Get-PnPWeb -Connection $SPListConnection
$SPMasterList = Get-PnPList -Connection $SPListConnection -Web $SPListWeb -Identity "Site Collection Central"

$fields = @()
$fields += "ReportLocation"
$fields += "LastRunDate"

$permissionsReports = [System.Collections.ArrayList]::new()

try {
    $SPMasterListItems = Get-PnPListItem -Connection $SPListConnection -Web $SPListWeb -List $SPMasterList -Fields $fields -ScriptBlock {
        Param($items)

        $SPReportFoldersConnection = Connect-SharePoint -WebUrl "https://site.sharepoint.com/sites/edmsc/Corp/SiteCollectionReports/" -CheckForAppCredentials
        $SPReportFoldersWeb = Get-PnPWeb -Connection $SPReportFoldersConnection

        foreach ($item in $items) {
            try {
                $Report_Location = [string]$item.FieldValues['ReportLocation'].Url
                $LastRunDate = [DateTime]$item.FieldValues['LastRunDate']

                $officeLocation = ($Report_Location -split "/")[-1]
                $report_year = $LastRunDate.Year.ToString()
                $report_month = $LastRunDate.ToString("MMMM")

                $permissionsListLocation = Get-PnPFolderItem -Connection $SPReportFoldersConnection -Web $SPReportFoldersWeb -FolderSiteRelativeUrl "$officeLocation/$report_year/$report_month" -ItemType File
                
                foreach ($item in $permissionsListLocation) {
                    $item.Name
                    $fileURL = "https://site.sharepoint.com/sites/edmsc/Corp/SiteCollectionReports/$officeLocation/$report_year/$report_month/$($item.Name)"

                    if ($item.Name.Contains("permissions")) {
                        $permissionsReports.Add($fileURL)
                        }
                }

            }
            catch {

            }

        }
    }
}
catch {
    #Continue without doing anything
}

现在如何获得 CSV URL并导入每个CSV并在其中使用数据。这可能吗？

当我尝试这个错误时，

foreach ($item in $permissionsReports) {
      Import-Csv -Path $item
  }

我会有一个错误 import-csv：找不到驱动器。具有“ HTTPS”名称的驱动器不存在。

编辑： 添加$许可报告的输出

https://site.sharepoint.com/sites/edmsc/Corp/SiteCollectionReports/BCS/2022/March/bcs-permissions-03-24-2022.csv
https://site.sharepoint.com/sites/edmsc/Corp/SiteCollectionReports/DRR/2022/March/drr-permissions-03-24-2022.csv
https://site.sharepoint.com/sites/edmsc/Corp/SiteCollectionReports/CISR_Analytics/2022/March/cisr_analytics-permissions-03-24-2022.csv