az functionapp list returns incorrect null values

[BrianBaro]

Describe the bug
When using the "az functionapp list" command the returned json contains values that should not be null, such as siteConfig.minTlsVersion
To Reproduce
Run a command along these lines:
az functionapp list --output json --query "[].{hostName:defaultHostName, httpsOnly:httpsOnly, minTlsVersion: siteConfig.minTlsVersion}" -o table
Expected behavior
The returned minTLSVersion should not be null.
Environment summary
Using the Azure Cloud Shell or a local bash client

Additional context
Using the Resource Explorer it can be confirmed that the values are not null and other commands, such as "az functionapp config show" return the correct values. It seems to be the "list" command that has the issue.

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc Ahmed Elnably (@ahmedelnably), Fabio Cavalcante (@fabiocav).

Issue Details

---

Describe the bug
When using the "az functionapp list" command the returned json contains values that should not be null, such as siteConfig.minTlsVersion
To Reproduce
Run a command along these lines:
az functionapp list --output json --query "[].{hostName:defaultHostName, httpsOnly:httpsOnly, minTlsVersion: siteConfig.minTlsVersion}" -o table
Expected behavior
The returned minTLSVersion should not be null.
Environment summary
Using the Azure Cloud Shell or a local bash client

Additional context
Using the Resource Explorer it can be confirmed that the values are not null and other commands, such as "az functionapp config show" return the correct values. It seems to be the "list" command that has the issue.

Author:	BrianBaro
Assignees:	-
Labels:	Functions, Service Attention, needs-triage, question
Milestone:	-

[yungezz]

route to appropriate team

[apawast]

Graham Zuber (@gzuber) could you please investigate this?

[junaidahmed92]

Any update on this as I am also facing kind of same issue with az webapp list --query "[?name=='web_app_where_health_check_is_enabled']" where it's showing null value for siteConfig.healthCheckPath but it shouldn't actually

[dtriana]

Looking at #21548 , my understanding is this is by design, to address performance concerns, the list query doesn't resolve the nested properties,

In that same issue there is a workaround, doing a first list to get the Ids, then do a show command with the list of Ids, I just tried it for a different purpose and works fine