Filtering with Azure CLI and JMESPath for network vnet peering list

Question

I'm using the Azure CLI to get a list of vnet peerings: az network vnet peering list. This returns json in the following structure:

[
  {
    ...
    "name": "prefix1-name",
    ...
  },
  {
    ...
    "name": "prefix2-name",
    ...
  }
]

I am trying to filter the results by names starting with some prefix. I have tried various combinations of the following: az network vnet peering list --resource-group my-rg --vnet-name my-vnet --query "[?starts_with(name,'prefix1-')].{name}" However this always fails with a message like ].{name} was unexpected at this time.

What am I missing?

Answer 1

Try to use az network vnet peering list --resource-group my-rg --vnet-name my-vnet --query "[?starts_with(name,'prefix1-')].name". You do not need to include the {}in the name. This works on my side.

Edit

For the error message, I can reproduce it with these Azure CLI commands in PowerShell locally on the windows 10 machine. But this does not appear in my local Linux Bash Shell as the above screenshots. This error also does not appear on PowerShell and Bash in the Azure cloud shell.

By my validation, It looks like a specific scenario on local PowerShell. When you filter with JMESPath, I just tried that the function starts_with or contains requires a space between the function, it works like these:

--query "[?starts_with(name, 'vnet')].name" --query "[?starts_with (name,'vnet')].name" --query "[?starts_with(name,'vnet') ].name" --query "[?starts_with(name,'vnet')] .name"

but this does not work as below.

--query "[?starts_with(name,'vnet')].name"