Empty results on query for table output

[gsacavdm]

Are there any special considerations with -o table that I should be aware of? Why does this not return any results?

az vm list --query "[].{id:id}" -o table

Yet this does:

az vm list --query "[].{id:id}" -o json

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 48273ba7-da5a-95f0-7ffc-8c6d5282313d
• Version Independent ID: 83d348f9-fd1f-1041-0304-d8634e5526d4
• Content
• Content Source
• Service: multiple

[sptramer]

It looks like this is related to a known issue which is considered a feature request (Azure/azure-cli#5434). Because there are multiple values contained within an array, the table output doesn't seem to know how to appropriately handle it.

I'll make sure to update documentation to indicate that these issues are there, and that table may not work with sub-arrays and sub-dictionaries.

[sptramer]

Correction: This is definitely a separate issue! Some fields are filtered out by name. Updated the documentation to reflect this.

[sptramer]

The output format information has been updated to indicate that the id key is always stripped from table output.