当我查询$GetCSV时，我得到了所有记录，当我查询$GetCSV.id时，它没有显示任何数据。
您可以使用下面修改的脚本，通过Azure自动化从**CSV**文件中获取特定记录。
在我的共享点中，我的示例CSV文件看起来像这样：
x1c 0d1x的数据

脚本：

$headers = Get-AuthToken
$graphurl = "https://graph.microsoft.com/beta"

#Sharepoint parameters
$SharePoint = "%Company%.sharepoint.com"
$SharePointSite = "%Site%"
$ItemPathFile = "file.csv"
$ItemPath = "Apps/Entra%20Automation/$ItemPathFile"

#Get the site from Graph API
$SharePointsitequery = "$graphurl/sites/$($SharePoint):/sites/$($SharePointSite)"
$SiteRequestCall = try{Invoke-RestMethod -Method GET -headers $headers -Uri $SharePointsitequery}catch{Write-output "Error SharePoint SiteId $($_.Exception.Response.StatusCode) $($_.Exception.Response.StatusDescription)"}
$SiteId = $SiteRequestCall.id.split(",")[1]

#Get the file to the documents library
$Querygetfile = "$graphurl/sites/$siteId/drive/items/root:/$($ItemPath):/content"
$GetCSV = try{Invoke-RestMethod -Method GET -Headers $headers -Uri $Querygetfile }catch{Write-output "Error SharePoint Get $($_.Exception.Response.StatusCode) $($_.Exception.Response.StatusDescription)"}

$CSV = $GetCSV | ConvertFrom-Csv -Delimiter ","

# Access the properties of the CSV file
$Numeric = $CSV.Numeric
$Numeric2 = $CSV.'Numeric-2'
$NumericSuffix = $CSV.'Numeric-Suffix'

$Numeric

字符串
上面的代码在我的Azure自动化环境中执行并读取第一列。

输出：

的