主頁 > .NET開發 > 以編程方式在JSON物件中查找和洗掉物件

以編程方式在JSON物件中查找和洗掉物件

2022-04-01 17:57:26 .NET開發

TL;DR 如何以編程方式搜索每個檔案可能不在同一位置的物件并將其洗掉?

如果我確切地知道物件在 JSON 中的位置,那很好,但如果它改變位置,則很難撰寫腳本。目前,我們以編程方式構建了一個 ARM 模板并將其推送到 Azure,但在我們進行比較之前,我們會比較它以查看云中的版本與新生成的檔案不同,如果有,請替換它或創建一個新的基于在它的版本上。

問題是當模板規范是用新版本的 Bicep 構建時,然后將資訊注入 JSON 檔案,然后調整versiontemplateHash值。可悲的是,我無法阻止這種情況發生。

          "metadata": {
            "_generator": {
              "name": "bicep",
              "version": "0.4.1008.15138",
              "templateHash": "17593852815978663805"
            }

我曾經在Compare-Object將這兩個檔案轉換為 PowerShell 物件后對它們進行比較,但是當二進制更改出現時,它就放棄了這個想法。然后我開始研究一個更復雜的 PowerShell 比較,它會忽略基于模式的行,但今天早上失敗并出現了一些我無法診斷的隨機錯誤,因為它位于 Azure DevOps 管道中。

Write-Host "`n`n##[debug]??`tLooking for changes  ??"
$bicepAlteredLines  = @()
$templateSpecChange = $false
$patterns           = @(
    '\"version\"'
    '\"templateHash\"'
)


# newFile (${currentDir}.json) goes into old oldFile (portal.json)
$compare = Compare-Object `
    -ReferenceObject  $(Get-Content -Path "./portal.json") `
    -DifferenceObject $(Get-Content -Path "./${currentDir}.json")

# find the values where new goes into old
foreach($result in ($compare | Where-Object { $_.SideIndicator -eq "=>" })) {

    # loop over patterns that should be excluded because of bicep binary update
    foreach($pattern in $patterns) {

    # for each bicep binary metadata pattern, check to see if the difference line matches that pattern
        if($result.InputObject -match $pattern) {

            # create variable of old oldFile which is referenced on the same line
            $comparedResult = $compare |
                Where-Object {
                    ($_.SideIndicator -eq "<=") -and
                    ($_.InputObject.ReadCount -eq $result.InputObject.Readcount)
                }

            # check to see if the variable also contains the pattern that should be excluded
            if($comparedResult.InputObject -match $pattern) {

                $selectSearch = Select-String -Path "./${currentDir}.json" -Pattern $pattern -Context 2 |
                    Where-Object {
                        $_.LineNumber -eq $result.InputObject.Readcount
                    }

                # validate if the pattern relates to bicep and not just random string that looks like what we want
                foreach($item in $selectSearch) {

                    # we do this by checking the lines above the pattern, as this will contain the word 'bicep':
                    # "metadata": {
                    #     "_generator": {
                    #       "name": "bicep",
                    #       "version": "0.4.1008.15138",                <- if this line was the pattern, 1 up contains 'bicep'
                    #       "templateHash": "9914162448113979868"       <- if this line was the pattern, 2 up contains 'bicep'
                    #     }
                    foreach($bicepCheck in $item.Context.PreContext) {
                        if($bicepCheck -match "bicep") {

                            # if 'bicep' has been found, add array for readout later
                            $bicepAlteredLines  = $item.LineNumber
                            Write-Host "Bicep binary change found at line $($item.LineNumber) for pattern ${pattern}. Adding to ignore list."
                        }
                        else {
                            # if the variable doesn't contain 'bicep', then obviously there's been a change in the JSON layout
                            $templateSpecChange = $true
                        }
                    }
                }
            }
            else {
                # if the variable doesn't contain the pattern, then obviously there's been a change in the JSON layout
                $templateSpecChange = $true
            }
        }
        else {
            # if the variable doesn't contain the pattern, then obviously there's been a change in the JSON layout
            $templateSpecChange = $true
        }
    }
}


Write-Host "`nThe following lines are ignored due Bicep binary change:"
$bicepAlteredLines | Sort-Object -Unique

Write-Host "`n`n##[debug]??`tDifference found in file comparison = ${templateSpecChange}"

所以我想要么;

  • 忽略元資料,只比較周圍資訊
  • 在它自己放置的所有實體中完全洗掉元資料物件(理想的解決方案)
{
  "$schema": "https://schema.management.azure.com/schemas/2018-05-01/subscriptionDeploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "metadata": {
    "_generator": {
      "name": "bicep",
      "version": "0.4.1111.15138",
      "templateHash": "asdfasdfasdf"
    }
  },
  "parameters": {
    "p_vnetPeeringsCompute": {
      "type": "array",
      "metadata": {
        "description": "List of peerings to the virtual network."
      }
    },
    "p_vnetPeeringsStorage": {
      "type": "array",
      "metadata": {
        "description": "List of peerings to the virtual network."
      }
    },
    "p_vnetPeeringsLinkFile": {
      "type": "array",
      "metadata": {
        "description": "List of peerings to the virtual network."
      }
    },
    "p_tags": {
      "type": "object",
      "defaultValue": {},
      "metadata": {
        "description": "List of tags applied to resources."
      }
    }
  },
  "functions": [],
  "variables": {
    "v_longLocation": "uksouth",
    "v_shortLocation": "uks",
    "v_templateDescription": "Azure Private DNS Template Spec",
    "v_templateDisplayName": "privateDns",
    "v_templateName": "privateDns",
    "v_templateVersion": "2.0.0",
    "v_templateTags": {
      "tsName": "[variables('v_templateName')]",
      "tsVersion": "[variables('v_templateVersion')]"
    },
    "v_tags": "[union(parameters('p_tags'), variables('v_templateTags'))]"
  },
  "resources": [
    {
      "type": "Microsoft.Resources/resourceGroups",
      "apiVersion": "2021-01-01",
      "name": "[format('{0}-{1}-compute-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "location": "[variables('v_longLocation')]",
      "tags": "[variables('v_tags')]"
    },
    {
      "type": "Microsoft.Resources/resourceGroups",
      "apiVersion": "2021-01-01",
      "name": "[format('{0}-{1}-link-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "location": "[variables('v_longLocation')]",
      "tags": "[variables('v_tags')]"
    },
    {
      "type": "Microsoft.Resources/resourceGroups",
      "apiVersion": "2021-01-01",
      "name": "[format('{0}-{1}-storage-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "location": "[variables('v_longLocation')]",
      "tags": "[variables('v_tags')]"
    },
    {
      "type": "Microsoft.Resources/deployments",
      "apiVersion": "2020-06-01",
      "name": "privateCompute",
      "resourceGroup": "[format('{0}-{1}-compute-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "properties": {
        "expressionEvaluationOptions": {
          "scope": "inner"
        },
        "mode": "Incremental",
        "parameters": {
          "p_tags": {
            "value": "[variables('v_tags')]"
          },
          "p_vnetPeeringsCompute": {
            "value": "[parameters('p_vnetPeeringsCompute')]"
          }
        },
        "template": {
          "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
          "contentVersion": "1.0.0.0",
          "metadata": {
            "_generator": {
              "name": "bicep",
              "version": "0.4.1008.15138",
              "templateHash": "17593852815978663805"
            }
          },
          "parameters": {
            "p_tags": {
              "type": "object",
              "defaultValue": {},
              "metadata": {
                "description": "List of tags applied to resources."
              }
            },
            "p_vnetPeeringsCompute": {
              "type": "array",
              "metadata": {
                "description": "List of peerings to the virtual network."
              }
            }
          },
          "functions": [],
          "resources": [
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "compute.bld.local",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            },
            {
              "copy": {
                "name": "vnl",
                "count": "[length(parameters('p_vnetPeeringsCompute'))]"
              },
              "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
              "apiVersion": "2020-06-01",
              "name": "[format('{0}/{1}', 'compute.bld.local', last(split(parameters('p_vnetPeeringsCompute')[copyIndex()].id, '/')))]",
              "tags": "[parameters('p_tags')]",
              "location": "Global",
              "properties": {
                "virtualNetwork": {
                  "id": "[parameters('p_vnetPeeringsCompute')[copyIndex()].id]"
                },
                "registrationEnabled": false
              },
              "dependsOn": [
                "[resourceId('Microsoft.Network/privateDnsZones', 'compute.bld.local')]"
              ]
            }
          ]
        }
      },
      "dependsOn": [
        "[subscriptionResourceId('Microsoft.Resources/resourceGroups', format('{0}-{1}-compute-rsg', variables('v_shortLocation'), subscription().displayName))]"
      ]
    },
    {
      "type": "Microsoft.Resources/deployments",
      "apiVersion": "2020-06-01",
      "name": "privateLink",
      "resourceGroup": "[format('{0}-{1}-link-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "properties": {
        "expressionEvaluationOptions": {
          "scope": "inner"
        },
        "mode": "Incremental",
        "parameters": {
          "p_vnetPeeringsLinkFile": {
            "value": "[parameters('p_vnetPeeringsLinkFile')]"
          },
          "p_tags": {
            "value": "[variables('v_tags')]"
          }
        },
        "template": {
          "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
          "contentVersion": "1.0.0.0",
          "metadata": {
            "_generator": {
              "name": "bicep",
              "version": "0.4.1008.15138",
              "templateHash": "14603239311913824090"
            }
          },
          "parameters": {
            "p_vnetPeeringsLinkFile": {
              "type": "array",
              "metadata": {
                "description": "List of peerings to the virtual network."
              }
            },
            "p_tags": {
              "type": "object",
              "defaultValue": {},
              "metadata": {
                "description": "List of tags applied to resources."
              }
            }
          },
          "functions": [],
          "resources": [
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "[format('privatelink.file.{0}', environment().suffixes.storage)]",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            },
            {
              "copy": {
                "name": "vnl",
                "count": "[length(parameters('p_vnetPeeringsLinkFile'))]"
              },
              "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
              "apiVersion": "2020-06-01",
              "name": "[format('{0}/{1}', format('privatelink.file.{0}', environment().suffixes.storage), last(split(parameters('p_vnetPeeringsLinkFile')[copyIndex()].id, '/')))]",
              "tags": "[parameters('p_tags')]",
              "location": "Global",
              "properties": {
                "virtualNetwork": {
                  "id": "[parameters('p_vnetPeeringsLinkFile')[copyIndex()].id]"
                },
                "registrationEnabled": false
              },
              "dependsOn": [
                "[resourceId('Microsoft.Network/privateDnsZones', format('privatelink.file.{0}', environment().suffixes.storage))]"
              ]
            },
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "[format('privatelink{0}', environment().suffixes.sqlServerHostname)]",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            }
          ]
        }
      },
      "dependsOn": [
        "[subscriptionResourceId('Microsoft.Resources/resourceGroups', format('{0}-{1}-link-rsg', variables('v_shortLocation'), subscription().displayName))]"
      ]
    },
    {
      "type": "Microsoft.Resources/deployments",
      "apiVersion": "2020-06-01",
      "name": "privateStorage",
      "resourceGroup": "[format('{0}-{1}-storage-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "properties": {
        "expressionEvaluationOptions": {
          "scope": "inner"
        },
        "mode": "Incremental",
        "parameters": {
          "p_tags": {
            "value": "[variables('v_tags')]"
          },
          "p_vnetPeeringsStorage": {
            "value": "[parameters('p_vnetPeeringsStorage')]"
          }
        },
        "template": {
          "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
          "contentVersion": "1.0.0.0",
          "metadata": {
            "_generator": {
              "name": "bicep",
              "version": "0.4.1008.15138",
              "templateHash": "12131108274222647600"
            }
          },
          "parameters": {
            "p_tags": {
              "type": "object",
              "defaultValue": {},
              "metadata": {
                "description": "List of tags applied to resources."
              }
            },
            "p_vnetPeeringsStorage": {
              "type": "array",
              "metadata": {
                "description": "List of peerings to the virtual network."
              }
            }
          },
          "functions": [],
          "resources": [
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "storage.bld.local",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            },
            {
              "copy": {
                "name": "vnl",
                "count": "[length(parameters('p_vnetPeeringsStorage'))]"
              },
              "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
              "apiVersion": "2020-06-01",
              "name": "[format('{0}/{1}', 'storage.bld.local', last(split(parameters('p_vnetPeeringsStorage')[copyIndex()].id, '/')))]",
              "tags": "[parameters('p_tags')]",
              "location": "Global",
              "properties": {
                "virtualNetwork": {
                  "id": "[parameters('p_vnetPeeringsStorage')[copyIndex()].id]"
                },
                "registrationEnabled": false
              },
              "dependsOn": [
                "[resourceId('Microsoft.Network/privateDnsZones', 'storage.bld.local')]"
              ]
            }
          ]
        }
      },
      "dependsOn": [
        "[subscriptionResourceId('Microsoft.Resources/resourceGroups', format('{0}-{1}-storage-rsg', variables('v_shortLocation'), subscription().displayName))]"
      ]
    }
  ]
}

目前我知道它在 2 個標準位置,但我不確定它是否會出現在其他位置。

? $asdf.resources.properties.template.metadata

_generator
----------
@{name=bicep; version=0.4.1008.15138; templateHash=17593852815978663805}
@{name=bicep; version=0.4.1008.15138; templateHash=14603239311913824090}
@{name=bicep; version=0.4.1008.15138; templateHash=12131108274222647600}

compare
? $asdf.metadata

_generator
----------
@{name=bicep; version=0.4.1111.15138; templateHash=asdfasdfasdf}

如果 PowerShell 中有一個選項來查找命名物件的所有實體并洗掉它們,那會更理想metadata,但我在 PowerShell 中找不到這樣的選項。任何想法/想法都會很棒。

在任何人提到我應該洗掉 and 的所有實體之前$asdf.resources.properties.template.metadata$asdf.metadata我想知道如何搜索*.metadata可能/可能出現在其他位置的任何實體。更多的是“查找所有*.metadata物件并從物件中洗掉,無論它在哪里”。

uj5u.com熱心網友回復:

jq被標記,可以walk用來遍歷JSON檔案,如果遇到物件,應用del洗掉任意.metadata欄位:

jq 'walk(if type == "object" then del(.metadata) else . end)' file.json
{
  "$schema": "https://schema.management.azure.com/schemas/2018-05-01/subscriptionDeploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "p_vnetPeeringsCompute": {
      "type": "array"
    },
    "p_vnetPeeringsStorage": {
      "type": "array"
    },
    "p_vnetPeeringsLinkFile": {
      "type": "array"
    },
    "p_tags": {
      "type": "object",
      "defaultValue": {}
    }
  },
  "functions": [],
  "variables": {
    "v_longLocation": "uksouth",
    "v_shortLocation": "uks",
    "v_templateDescription": "Azure Private DNS Template Spec",
    "v_templateDisplayName": "privateDns",
    "v_templateName": "privateDns",
    "v_templateVersion": "2.0.0",
    "v_templateTags": {
      "tsName": "[variables('v_templateName')]",
      "tsVersion": "[variables('v_templateVersion')]"
    },
    "v_tags": "[union(parameters('p_tags'), variables('v_templateTags'))]"
  },
  "resources": [
    {
      "type": "Microsoft.Resources/resourceGroups",
      "apiVersion": "2021-01-01",
      "name": "[format('{0}-{1}-compute-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "location": "[variables('v_longLocation')]",
      "tags": "[variables('v_tags')]"
    },
    {
      "type": "Microsoft.Resources/resourceGroups",
      "apiVersion": "2021-01-01",
      "name": "[format('{0}-{1}-link-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "location": "[variables('v_longLocation')]",
      "tags": "[variables('v_tags')]"
    },
    {
      "type": "Microsoft.Resources/resourceGroups",
      "apiVersion": "2021-01-01",
      "name": "[format('{0}-{1}-storage-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "location": "[variables('v_longLocation')]",
      "tags": "[variables('v_tags')]"
    },
    {
      "type": "Microsoft.Resources/deployments",
      "apiVersion": "2020-06-01",
      "name": "privateCompute",
      "resourceGroup": "[format('{0}-{1}-compute-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "properties": {
        "expressionEvaluationOptions": {
          "scope": "inner"
        },
        "mode": "Incremental",
        "parameters": {
          "p_tags": {
            "value": "[variables('v_tags')]"
          },
          "p_vnetPeeringsCompute": {
            "value": "[parameters('p_vnetPeeringsCompute')]"
          }
        },
        "template": {
          "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
          "contentVersion": "1.0.0.0",
          "parameters": {
            "p_tags": {
              "type": "object",
              "defaultValue": {}
            },
            "p_vnetPeeringsCompute": {
              "type": "array"
            }
          },
          "functions": [],
          "resources": [
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "compute.bld.local",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            },
            {
              "copy": {
                "name": "vnl",
                "count": "[length(parameters('p_vnetPeeringsCompute'))]"
              },
              "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
              "apiVersion": "2020-06-01",
              "name": "[format('{0}/{1}', 'compute.bld.local', last(split(parameters('p_vnetPeeringsCompute')[copyIndex()].id, '/')))]",
              "tags": "[parameters('p_tags')]",
              "location": "Global",
              "properties": {
                "virtualNetwork": {
                  "id": "[parameters('p_vnetPeeringsCompute')[copyIndex()].id]"
                },
                "registrationEnabled": false
              },
              "dependsOn": [
                "[resourceId('Microsoft.Network/privateDnsZones', 'compute.bld.local')]"
              ]
            }
          ]
        }
      },
      "dependsOn": [
        "[subscriptionResourceId('Microsoft.Resources/resourceGroups', format('{0}-{1}-compute-rsg', variables('v_shortLocation'), subscription().displayName))]"
      ]
    },
    {
      "type": "Microsoft.Resources/deployments",
      "apiVersion": "2020-06-01",
      "name": "privateLink",
      "resourceGroup": "[format('{0}-{1}-link-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "properties": {
        "expressionEvaluationOptions": {
          "scope": "inner"
        },
        "mode": "Incremental",
        "parameters": {
          "p_vnetPeeringsLinkFile": {
            "value": "[parameters('p_vnetPeeringsLinkFile')]"
          },
          "p_tags": {
            "value": "[variables('v_tags')]"
          }
        },
        "template": {
          "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
          "contentVersion": "1.0.0.0",
          "parameters": {
            "p_vnetPeeringsLinkFile": {
              "type": "array"
            },
            "p_tags": {
              "type": "object",
              "defaultValue": {}
            }
          },
          "functions": [],
          "resources": [
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "[format('privatelink.file.{0}', environment().suffixes.storage)]",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            },
            {
              "copy": {
                "name": "vnl",
                "count": "[length(parameters('p_vnetPeeringsLinkFile'))]"
              },
              "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
              "apiVersion": "2020-06-01",
              "name": "[format('{0}/{1}', format('privatelink.file.{0}', environment().suffixes.storage), last(split(parameters('p_vnetPeeringsLinkFile')[copyIndex()].id, '/')))]",
              "tags": "[parameters('p_tags')]",
              "location": "Global",
              "properties": {
                "virtualNetwork": {
                  "id": "[parameters('p_vnetPeeringsLinkFile')[copyIndex()].id]"
                },
                "registrationEnabled": false
              },
              "dependsOn": [
                "[resourceId('Microsoft.Network/privateDnsZones', format('privatelink.file.{0}', environment().suffixes.storage))]"
              ]
            },
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "[format('privatelink{0}', environment().suffixes.sqlServerHostname)]",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            }
          ]
        }
      },
      "dependsOn": [
        "[subscriptionResourceId('Microsoft.Resources/resourceGroups', format('{0}-{1}-link-rsg', variables('v_shortLocation'), subscription().displayName))]"
      ]
    },
    {
      "type": "Microsoft.Resources/deployments",
      "apiVersion": "2020-06-01",
      "name": "privateStorage",
      "resourceGroup": "[format('{0}-{1}-storage-rsg', variables('v_shortLocation'), subscription().displayName)]",
      "properties": {
        "expressionEvaluationOptions": {
          "scope": "inner"
        },
        "mode": "Incremental",
        "parameters": {
          "p_tags": {
            "value": "[variables('v_tags')]"
          },
          "p_vnetPeeringsStorage": {
            "value": "[parameters('p_vnetPeeringsStorage')]"
          }
        },
        "template": {
          "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
          "contentVersion": "1.0.0.0",
          "parameters": {
            "p_tags": {
              "type": "object",
              "defaultValue": {}
            },
            "p_vnetPeeringsStorage": {
              "type": "array"
            }
          },
          "functions": [],
          "resources": [
            {
              "type": "Microsoft.Network/privateDnsZones",
              "apiVersion": "2020-06-01",
              "name": "storage.bld.local",
              "tags": "[parameters('p_tags')]",
              "location": "Global"
            },
            {
              "copy": {
                "name": "vnl",
                "count": "[length(parameters('p_vnetPeeringsStorage'))]"
              },
              "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
              "apiVersion": "2020-06-01",
              "name": "[format('{0}/{1}', 'storage.bld.local', last(split(parameters('p_vnetPeeringsStorage')[copyIndex()].id, '/')))]",
              "tags": "[parameters('p_tags')]",
              "location": "Global",
              "properties": {
                "virtualNetwork": {
                  "id": "[parameters('p_vnetPeeringsStorage')[copyIndex()].id]"
                },
                "registrationEnabled": false
              },
              "dependsOn": [
                "[resourceId('Microsoft.Network/privateDnsZones', 'storage.bld.local')]"
              ]
            }
          ]
        }
      },
      "dependsOn": [
        "[subscriptionResourceId('Microsoft.Resources/resourceGroups', format('{0}-{1}-storage-rsg', variables('v_shortLocation'), subscription().displayName))]"
      ]
    }
  ]
}

演示

uj5u.com熱心網友回復:

在純 PowerShell 中,您可以使用遞回函式從任何嵌套深度的物件中清除任何"metadata"屬性。

function StripMetadata {
    param($node)

    if ($node -is [pscustomobject]) {
        foreach ($prop in $node.PSObject.Properties) {
            if ($prop.Name -eq "metadata") {
                $node.PSObject.Properties.Remove($prop.Name)
            } else {
                StripMetadata $prop.Value
            }
        }
    } elseif ($node -is [array]) {
        foreach ($item in $node) {
            StripMetadata $item
        }
    }
}

請注意,這會就地修改物件,沒有結果值。

$data = $yourJson | ConvertFrom-Json 
StripMetadata $data
$result = $data | ConvertTo-Json -Depth 100 -Compress

$result是(格式化):

{
    "$schema": "https://schema.management.azure.com/schemas/2018-05-01/subscriptionDeploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "parameters": {
        "p_vnetPeeringsCompute": {
            "type": "array"
        },
        "p_vnetPeeringsStorage": {
            "type": "array"
        },
        "p_vnetPeeringsLinkFile": {
            "type": "array"
        },
        "p_tags": {
            "type": "object",
            "defaultValue": {}
        }
    },
    "functions": [],
    "variables": {
        "v_longLocation": "uksouth",
        "v_shortLocation": "uks",
        "v_templateDescription": "Azure Private DNS Template Spec",
        "v_templateDisplayName": "privateDns",
        "v_templateName": "privateDns",
        "v_templateVersion": "2.0.0",
        "v_templateTags": {
            "tsName": "[variables(\u0027v_templateName\u0027)]",
            "tsVersion": "[variables(\u0027v_templateVersion\u0027)]"
        },
        "v_tags": "[union(parameters(\u0027p_tags\u0027), variables(\u0027v_templateTags\u0027))]"
    },
    "resources": [{
        "type": "Microsoft.Resources/resourceGroups",
        "apiVersion": "2021-01-01",
        "name": "[format(\u0027{0}-{1}-compute-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName)]",
        "location": "[variables(\u0027v_longLocation\u0027)]",
        "tags": "[variables(\u0027v_tags\u0027)]"
    }, {
        "type": "Microsoft.Resources/resourceGroups",
        "apiVersion": "2021-01-01",
        "name": "[format(\u0027{0}-{1}-link-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName)]",
        "location": "[variables(\u0027v_longLocation\u0027)]",
        "tags": "[variables(\u0027v_tags\u0027)]"
    }, {
        "type": "Microsoft.Resources/resourceGroups",
        "apiVersion": "2021-01-01",
        "name": "[format(\u0027{0}-{1}-storage-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName)]",
        "location": "[variables(\u0027v_longLocation\u0027)]",
        "tags": "[variables(\u0027v_tags\u0027)]"
    }, {
        "type": "Microsoft.Resources/deployments",
        "apiVersion": "2020-06-01",
        "name": "privateCompute",
        "resourceGroup": "[format(\u0027{0}-{1}-compute-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName)]",
        "properties": {
            "expressionEvaluationOptions": {
                "scope": "inner"
            },
            "mode": "Incremental",
            "parameters": {
                "p_tags": {
                    "value": "[variables(\u0027v_tags\u0027)]"
                },
                "p_vnetPeeringsCompute": {
                    "value": "[parameters(\u0027p_vnetPeeringsCompute\u0027)]"
                }
            },
            "template": {
                "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
                "contentVersion": "1.0.0.0",
                "parameters": {
                    "p_tags": {
                        "type": "object",
                        "defaultValue": {}
                    },
                    "p_vnetPeeringsCompute": {
                        "type": "array"
                    }
                },
                "functions": [],
                "resources": [{
                    "type": "Microsoft.Network/privateDnsZones",
                    "apiVersion": "2020-06-01",
                    "name": "compute.bld.local",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global"
                }, {
                    "copy": {
                        "name": "vnl",
                        "count": "[length(parameters(\u0027p_vnetPeeringsCompute\u0027))]"
                    },
                    "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
                    "apiVersion": "2020-06-01",
                    "name": "[format(\u0027{0}/{1}\u0027, \u0027compute.bld.local\u0027, last(split(parameters(\u0027p_vnetPeeringsCompute\u0027)[copyIndex()].id, \u0027/\u0027)))]",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global",
                    "properties": {
                        "virtualNetwork": {
                            "id": "[parameters(\u0027p_vnetPeeringsCompute\u0027)[copyIndex()].id]"
                        },
                        "registrationEnabled": false
                    },
                    "dependsOn": ["[resourceId(\u0027Microsoft.Network/privateDnsZones\u0027, \u0027compute.bld.local\u0027)]"]
                }]
            }
        },
        "dependsOn": ["[subscriptionResourceId(\u0027Microsoft.Resources/resourceGroups\u0027, format(\u0027{0}-{1}-compute-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName))]"]
    }, {
        "type": "Microsoft.Resources/deployments",
        "apiVersion": "2020-06-01",
        "name": "privateLink",
        "resourceGroup": "[format(\u0027{0}-{1}-link-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName)]",
        "properties": {
            "expressionEvaluationOptions": {
                "scope": "inner"
            },
            "mode": "Incremental",
            "parameters": {
                "p_vnetPeeringsLinkFile": {
                    "value": "[parameters(\u0027p_vnetPeeringsLinkFile\u0027)]"
                },
                "p_tags": {
                    "value": "[variables(\u0027v_tags\u0027)]"
                }
            },
            "template": {
                "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
                "contentVersion": "1.0.0.0",
                "parameters": {
                    "p_vnetPeeringsLinkFile": {
                        "type": "array"
                    },
                    "p_tags": {
                        "type": "object",
                        "defaultValue": {}
                    }
                },
                "functions": [],
                "resources": [{
                    "type": "Microsoft.Network/privateDnsZones",
                    "apiVersion": "2020-06-01",
                    "name": "[format(\u0027privatelink.file.{0}\u0027, environment().suffixes.storage)]",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global"
                }, {
                    "copy": {
                        "name": "vnl",
                        "count": "[length(parameters(\u0027p_vnetPeeringsLinkFile\u0027))]"
                    },
                    "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
                    "apiVersion": "2020-06-01",
                    "name": "[format(\u0027{0}/{1}\u0027, format(\u0027privatelink.file.{0}\u0027, environment().suffixes.storage), last(split(parameters(\u0027p_vnetPeeringsLinkFile\u0027)[copyIndex()].id, \u0027/\u0027)))]",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global",
                    "properties": {
                        "virtualNetwork": {
                            "id": "[parameters(\u0027p_vnetPeeringsLinkFile\u0027)[copyIndex()].id]"
                        },
                        "registrationEnabled": false
                    },
                    "dependsOn": ["[resourceId(\u0027Microsoft.Network/privateDnsZones\u0027, format(\u0027privatelink.file.{0}\u0027, environment().suffixes.storage))]"]
                }, {
                    "type": "Microsoft.Network/privateDnsZones",
                    "apiVersion": "2020-06-01",
                    "name": "[format(\u0027privatelink{0}\u0027, environment().suffixes.sqlServerHostname)]",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global"
                }]
            }
        },
        "dependsOn": ["[subscriptionResourceId(\u0027Microsoft.Resources/resourceGroups\u0027, format(\u0027{0}-{1}-link-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName))]"]
    }, {
        "type": "Microsoft.Resources/deployments",
        "apiVersion": "2020-06-01",
        "name": "privateStorage",
        "resourceGroup": "[format(\u0027{0}-{1}-storage-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName)]",
        "properties": {
            "expressionEvaluationOptions": {
                "scope": "inner"
            },
            "mode": "Incremental",
            "parameters": {
                "p_tags": {
                    "value": "[variables(\u0027v_tags\u0027)]"
                },
                "p_vnetPeeringsStorage": {
                    "value": "[parameters(\u0027p_vnetPeeringsStorage\u0027)]"
                }
            },
            "template": {
                "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
                "contentVersion": "1.0.0.0",
                "parameters": {
                    "p_tags": {
                        "type": "object",
                        "defaultValue": {}
                    },
                    "p_vnetPeeringsStorage": {
                        "type": "array"
                    }
                },
                "functions": [],
                "resources": [{
                    "type": "Microsoft.Network/privateDnsZones",
                    "apiVersion": "2020-06-01",
                    "name": "storage.bld.local",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global"
                }, {
                    "copy": {
                        "name": "vnl",
                        "count": "[length(parameters(\u0027p_vnetPeeringsStorage\u0027))]"
                    },
                    "type": "Microsoft.Network/privateDnsZones/virtualNetworkLinks",
                    "apiVersion": "2020-06-01",
                    "name": "[format(\u0027{0}/{1}\u0027, \u0027storage.bld.local\u0027, last(split(parameters(\u0027p_vnetPeeringsStorage\u0027)[copyIndex()].id, \u0027/\u0027)))]",
                    "tags": "[parameters(\u0027p_tags\u0027)]",
                    "location": "Global",
                    "properties": {
                        "virtualNetwork": {
                            "id": "[parameters(\u0027p_vnetPeeringsStorage\u0027)[copyIndex()].id]"
                        },
                        "registrationEnabled": false
                    },
                    "dependsOn": ["[resourceId(\u0027Microsoft.Network/privateDnsZones\u0027, \u0027storage.bld.local\u0027)]"]
                }]
            }
        },
        "dependsOn": ["[subscriptionResourceId(\u0027Microsoft.Resources/resourceGroups\u0027, format(\u0027{0}-{1}-storage-rsg\u0027, variables(\u0027v_shortLocation\u0027), subscription().displayName))]"]
    }]
}

轉載請註明出處,本文鏈接:https://www.uj5u.com/net/454119.html

標籤:json 电源外壳 jq

上一篇:“中斷”導致PowerShell腳本失敗

下一篇:使用csv更新EmployeeID屬性

標籤雲
其他(157675) Python(38076) JavaScript(25376) Java(17977) C(15215) 區塊鏈(8255) C#(7972) AI(7469) 爪哇(7425) MySQL(7132) html(6777) 基礎類(6313) sql(6102) 熊猫(6058) PHP(5869) 数组(5741) R(5409) Linux(5327) 反应(5209) 腳本語言(PerlPython)(5129) 非技術區(4971) Android(4554) 数据框(4311) css(4259) 节点.js(4032) C語言(3288) json(3245) 列表(3129) 扑(3119) C++語言(3117) 安卓(2998) 打字稿(2995) VBA(2789) Java相關(2746) 疑難問題(2699) 细绳(2522) 單片機工控(2479) iOS(2429) ASP.NET(2402) MongoDB(2323) 麻木的(2285) 正则表达式(2254) 字典(2211) 循环(2198) 迅速(2185) 擅长(2169) 镖(2155) 功能(1967) .NET技术(1958) Web開發(1951) python-3.x(1918) HtmlCss(1915) 弹簧靴(1913) C++(1909) xml(1889) PostgreSQL(1872) .NETCore(1853) 谷歌表格(1846) Unity3D(1843) for循环(1842)

熱門瀏覽
  • WebAPI簡介

    Web體系結構: 有三個核心:資源(resource),URL(統一資源識別符號)和表示 他們的關系是這樣的:一個資源由一個URL進行標識,HTTP客戶端使用URL定位資源,表示是從資源回傳資料,媒體型別是資源回傳的資料格式。 接下來我們說下HTTP. HTTP協議的系統是一種無狀態的方式,使用請求/ ......

    uj5u.com 2020-09-09 22:07:47 more
  • asp.net core 3.1 入口:Program.cs中的Main函式

    本文分析Program.cs 中Main()函式中代碼的運行順序分析asp.net core程式的啟動,重點不是剖析原始碼,而是理清程式開始時執行的順序。到呼叫了哪些實體,哪些法方。asp.net core 3.1 的程式入口在專案Program.cs檔案里,如下。ususing System; us ......

    uj5u.com 2020-09-09 22:07:49 more
  • asp.net網站作為websocket服務端的應用該如何寫

    最近被websocket的一個問題困擾了很久,有一個需求是在web網站中搭建websocket服務。客戶端通過網頁與服務器建立連接,然后服務器根據ip給客戶端網頁發送資訊。 其實,這個需求并不難,只是剛開始對websocket的內容不太了解。上網搜索了一下,有通過asp.net core 實作的、有 ......

    uj5u.com 2020-09-09 22:08:02 more
  • ASP.NET 開源匯入匯出庫Magicodes.IE Docker中使用

    Magicodes.IE在Docker中使用 更新歷史 2019.02.13 【Nuget】版本更新到2.0.2 【匯入】修復單列匯入的Bug,單元測驗“OneColumnImporter_Test”。問題見(https://github.com/dotnetcore/Magicodes.IE/is ......

    uj5u.com 2020-09-09 22:08:05 more
  • 在webform中使用ajax

    如果你用過Asp.net webform, 說明你也算是.NET 開發的老兵了。WEBform應該是2011 2013左右,當時還用visual studio 2005、 visual studio 2008。后來基本都用的是MVC。 如果是新開發的專案,估計沒人會用webform技術。但是有些舊版 ......

    uj5u.com 2020-09-09 22:08:50 more
  • iis添加asp.net網站,訪問提示:由于擴展配置問題而無法提供您請求的

    今天在iis服務器配置asp.net網站,遇到一個問題,記錄一下: 問題:由于擴展配置問題而無法提供您請求的頁面。如果該頁面是腳本,請添加處理程式。如果應下載檔案,請添加 MIME 映射。 WindowServer2012服務器,添加角色安裝完.netframework和iis之后,運行aspx頁面 ......

    uj5u.com 2020-09-09 22:10:00 more
  • WebAPI-處理架構

    帶著問題去思考,大家好! 問題1:HTTP請求和回傳相應的HTTP回應資訊之間發生了什么? 1:首先是最底層,托管層,位于WebAPI和底層HTTP堆疊之間 2:其次是 訊息處理程式管道層,這里比如日志和快取。OWIN的參考是將訊息處理程式管道的一些功能下移到堆疊下端的OWIN中間件了。 3:控制器處理 ......

    uj5u.com 2020-09-09 22:11:13 more
  • 微信門戶開發框架-使用指導說明書

    微信門戶應用管理系統,采用基于 MVC + Bootstrap + Ajax + Enterprise Library的技術路線,界面層采用Boostrap + Metronic組合的前端框架,資料訪問層支持Oracle、SQLServer、MySQL、PostgreSQL等資料庫。框架以MVC5,... ......

    uj5u.com 2020-09-09 22:15:18 more
  • WebAPI-HTTP編程模型

    帶著問題去思考,大家好!它是什么?它包含什么?它能干什么? 訊息 HTTP編程模型的核心就是訊息抽象,表示為:HttPRequestMessage,HttpResponseMessage.用于客戶端和服務端之間交換請求和回應訊息。 HttpMethod類包含了一組靜態屬性: private stat ......

    uj5u.com 2020-09-09 22:15:23 more
  • 部署WebApi隨筆

    一、跨域 NuGet參考Microsoft.AspNet.WebApi.Cors WebApiConfig.cs中配置: // Web API 配置和服務 config.EnableCors(new EnableCorsAttribute("*", "*", "*")); 二、清除默認回傳XML格式 ......

    uj5u.com 2020-09-09 22:15:48 more
最新发布
  • C#多執行緒學習(二) 如何操縱一個執行緒

    <a href="https://www.cnblogs.com/x-zhi/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/2943582/20220801082530.png" alt="" /></...

    uj5u.com 2023-04-19 09:17:20 more
  • C#多執行緒學習(二) 如何操縱一個執行緒

    C#多執行緒學習(二) 如何操縱一個執行緒 執行緒學習第一篇:C#多執行緒學習(一) 多執行緒的相關概念 下面我們就動手來創建一個執行緒,使用Thread類創建執行緒時,只需提供執行緒入口即可。(執行緒入口使程式知道該讓這個執行緒干什么事) 在C#中,執行緒入口是通過ThreadStart代理(delegate)來提供的 ......

    uj5u.com 2023-04-19 09:16:49 more
  • 記一次 .NET某醫療器械清洗系統 卡死分析

    <a href="https://www.cnblogs.com/huangxincheng/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/214741/20200614104537.png" alt="" /&g...

    uj5u.com 2023-04-18 08:39:04 more
  • 記一次 .NET某醫療器械清洗系統 卡死分析

    一:背景 1. 講故事 前段時間協助訓練營里的一位朋友分析了一個程式卡死的問題,回過頭來看這個案例比較經典,這篇稍微整理一下供后來者少踩坑吧。 二:WinDbg 分析 1. 為什么會卡死 因為是表單程式,理所當然就是看主執行緒此時正在做什么? 可以用 ~0s ; k 看一下便知。 0:000> k # ......

    uj5u.com 2023-04-18 08:33:10 more
  • SignalR, No Connection with that ID,IIS

    <a href="https://www.cnblogs.com/smartstar/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/u36196.jpg" alt="" /></a>...

    uj5u.com 2023-03-30 17:21:52 more
  • 一次對pool的誤用導致的.net頻繁gc的診斷分析

    <a href="https://www.cnblogs.com/dotnet-diagnostic/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/3115652/20230225090434.png" alt=""...

    uj5u.com 2023-03-28 10:15:33 more
  • 一次對pool的誤用導致的.net頻繁gc的診斷分析

    <a href="https://www.cnblogs.com/dotnet-diagnostic/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/3115652/20230225090434.png" alt=""...

    uj5u.com 2023-03-28 10:13:31 more
  • C#遍歷指定檔案夾中所有檔案的3種方法

    <a href="https://www.cnblogs.com/xbhp/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/957602/20230310105611.png" alt="" /></a&...

    uj5u.com 2023-03-27 14:46:55 more
  • C#/VB.NET:如何將PDF轉為PDF/A

    <a href="https://www.cnblogs.com/Carina-baby/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/2859233/20220427162558.png" alt="" />...

    uj5u.com 2023-03-27 14:46:35 more
  • 武裝你的WEBAPI-OData聚合查詢

    <a href="https://www.cnblogs.com/podolski/" target="_blank"><img width="48" height="48" class="pfs" src="https://pic.cnblogs.com/face/616093/20140323000327.png" alt="" /><...

    uj5u.com 2023-03-27 14:46:16 more