Using jq to suffix a string to a field in an object not containing it

Question

I have a json as follows:

{
  "$schema": "http://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "batchPools": {
      "value": [
        {
          "networkConfiguration": {
            "subnetId": "/subscriptions/xxxx/resourceGroups/xxx/providers/Microsoft.Network/virtualNetworks/xxxxx/subnets/sample-name-batch",
            "subnetAddressPrefix": ""
          }
        },
        {
          "networkConfiguration": {
            "subnetId": "/subscriptions/xxxx/resourceGroups/xxx/providers/Microsoft.Network/virtualNetworks/xxxxx/subnets/sample-name",
            "subnetAddressPrefix": ""
          }
        }
      ]
    }
  }
}

I need to check if any of the networkConfiguration.subnetID under the array value contains the string batch. If yes then nothing needs to be done. Else, append -batch to the existing value. In this case, only the second networkConfiguration.subnetID of the array should be updated.

I tried the following:

I get the following error: jq: error (at :38): Cannot index string with string "networkConfiguration" exit status 5

I tried this:

This worked fine and replaced the entire subnetId with someValue. I am not able to figure out why the previous command is not working out. Please help.

user_5291015 · Answer

You don't need to use the whole path of subnetId again. You've already selected that node from the pipeline before. Just use the += append operator to suffix the required string

( .parameters.batchPools.value[] | 
  select(.networkConfiguration.subnetId | contains("batch") | not) | 
  .networkConfiguration.subnetId ) += "-batch"

^{jqplay - Online demo}

Using jq to suffix a string to a field in an object not containing it

1 Answers