powershell-json文件解析

发布时间 2023-04-10 13:42:44作者: GrayLiang

.psobject.properties.name 可以获取当前节点下的name(***)

而.***获取该name 冒号后的内容

$path = "C:\Users\2\Desktop\R360_TCM_Report_Annie\Local\AnnieCaseReport.json"
#$path = "C:\Users\2\Desktop\DDDDD\De1.json"
$content= (Get-Content $path -Encoding Ascii) -join"`n" | ConvertFrom-Json
$contentName = $content.caselist.psobject.properties.name # | Get-Member
foreach($caseName in $contentName)
{
"caseName :" + $caseName
#foreach($case1 in $content.caseList)
#{
#"SKUIDa :" + $case1."$caseName".skuID[-1]
#}
foreach($case in $content.caseList."$caseName")
{
"case :" + $case
"SKUID :" + $case.skuID
"notes :" + $case.notes
"attachment :" + $case.attachment
"pims :" + $case.attachment
"status :" + $case.attachment
"comment :" + $case.attachment
}
}