OData Filtering for az cognitiveservices usage list does nothing

[sharkymcdongles]

Describe the bug

I want to use the documented filter using odata as described in docs. When I run the command the flag is ignored.

Related command

az cognitiveservices usage list -l westeurope --filter "name.value eq 'OpenAI.Standard.text-embedding-ada-002')"

Errors

No errors are returned. Seems like flag is just ignored completely.

Issue script & Debug output

cli.knack.cli: Command arguments: ['cognitiveservices', 'usage', 'list', '-l', 'westeurope', '--filter', "name.value eq 'OpenAI.Standard.text-embedding-ada-002')", '--debug']
cli.knack.cli: __init__ debug log:
Enable color in terminal.
cli.knack.cli: Event: Cli.PreExecute []
cli.knack.cli: Event: CommandParser.OnGlobalArgumentsCreate [<function CLILogging.on_global_arguments at 0x7fe27d558040>, <function OutputProducer.on_global_arguments at 0x7fe27d4fa160>, <function CLIQuery.on_global_arguments at 0x7fe27d52fc40>]
cli.knack.cli: Event: CommandInvoker.OnPreCommandTableCreate []
cli.azure.cli.core: Modules found from index for 'cognitiveservices': ['azure.cli.command_modules.cognitiveservices']
cli.azure.cli.core: Loading command modules:
cli.azure.cli.core: Name                  Load Time    Groups  Commands
cli.azure.cli.core: cognitiveservices         0.002        10        33
cli.azure.cli.core: Total (1)                 0.002        10        33
cli.azure.cli.core: Loaded 10 groups, 33 commands.
cli.azure.cli.core: Found a match in the command table.
cli.azure.cli.core: Raw command  : cognitiveservices usage list
cli.azure.cli.core: Command table: cognitiveservices usage list
cli.knack.cli: Event: CommandInvoker.OnPreCommandTableTruncate [<function AzCliLogging.init_command_file_logging at 0x7fe27c415bc0>]
cli.azure.cli.core.azlogging: metadata file logging enabled - writing logs to '/home/bh/.azure/commands/2024-03-13.13-40-35.cognitiveservices_usage_list.85653.log'.
az_command_data_logger: command args: cognitiveservices usage list -l {} --filter {} --debug
cli.knack.cli: Event: CommandInvoker.OnPreArgumentLoad [<function register_global_subscription_argument.<locals>.add_subscription_parameter at 0x7fe27c45eca0>]
cli.knack.cli: Event: CommandInvoker.OnPostArgumentLoad []
cli.knack.cli: Event: CommandInvoker.OnPostCommandTableCreate [<function register_ids_argument.<locals>.add_ids_arguments at 0x7fe27c481ee0>, <function register_cache_arguments.<locals>.add_cache_arguments at 0x7fe27c482020>]
cli.knack.cli: Event: CommandInvoker.OnCommandTableLoaded []
cli.knack.cli: Event: CommandInvoker.OnPreParseArgs []
cli.knack.cli: Event: CommandInvoker.OnPostParseArgs [<function OutputProducer.handle_output_argument at 0x7fe27d4fa200>, <function CLIQuery.handle_query_parameter at 0x7fe27d52fce0>, <function register_ids_argument.<locals>.parse_ids_arguments at 0x7fe27c481f80>]
cli.azure.cli.core.commands.client_factory: Getting management service client client_type=CognitiveServicesManagementClient
cli.azure.cli.core.auth.persistence: build_persistence: location='/home/bh/.azure/msal_token_cache.json', encrypt=False
cli.azure.cli.core.auth.binary_cache: load: /home/bh/.azure/msal_http_cache.bin
urllib3.util.retry: Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
msal.authority: openid_config = {'token_endpoint': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/oauth2/v2.0/token', 'token_endpoint_auth_methods_supported': ['client_secret_post', 'private_key_jwt', 'client_secret_basic'], 'jwks_uri': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/discovery/v2.0/keys', 'response_modes_supported': ['query', 'fragment', 'form_post'], 'subject_types_supported': ['pairwise'], 'id_token_signing_alg_values_supported': ['RS256'], 'response_types_supported': ['code', 'id_token', 'code id_token', 'id_token token'], 'scopes_supported': ['openid', 'profile', 'email', 'offline_access'], 'issuer': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/v2.0', 'request_uri_parameter_supported': False, 'userinfo_endpoint': 'https://graph.microsoft.com/oidc/userinfo', 'authorization_endpoint': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/oauth2/v2.0/authorize', 'device_authorization_endpoint': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/oauth2/v2.0/devicecode', 'http_logout_supported': True, 'frontchannel_logout_supported': True, 'end_session_endpoint': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/oauth2/v2.0/logout', 'claims_supported': ['sub', 'iss', 'cloud_instance_name', 'cloud_instance_host_name', 'cloud_graph_host_name', 'msgraph_host', 'aud', 'exp', 'iat', 'auth_time', 'acr', 'nonce', 'preferred_username', 'name', 'tid', 'ver', 'at_hash', 'c_hash', 'email'], 'kerberos_endpoint': 'https://login.microsoftonline.com/077c802f-5028-475f-8896-4fad80cca77b/kerberos', 'tenant_region_scope': 'EU', 'cloud_instance_name': 'microsoftonline.com', 'cloud_graph_host_name': 'graph.windows.net', 'msgraph_host': 'graph.microsoft.com', 'rbac_url': 'https://pas.windows.net'}
msal.application: Broker enabled? None
cli.azure.cli.core.auth.credential_adaptor: CredentialAdaptor.get_token: scopes=('https://management.core.windows.net//.default',), kwargs={}
cli.azure.cli.core.auth.msal_authentication: UserCredential.get_token: scopes=('https://management.core.windows.net//.default',), claims=None, kwargs={}
msal.application: Cache hit an AT
msal.telemetry: Generate or reuse correlation_id: 814caa06-4b19-4fa2-8124-f4d625796b40
cli.azure.cli.core.sdk.policies: Request URL: 'https://management.azure.com/subscriptions/SUB/providers/Microsoft.CognitiveServices/locations/westeurope/usages?api-version=2023-05-01&$filter=name.value%20eq%20%27OpenAI.Standard.text-embedding-ada-002%27%29'
cli.azure.cli.core.sdk.policies: Request method: 'GET'
cli.azure.cli.core.sdk.policies: Request headers:
cli.azure.cli.core.sdk.policies:     'Accept': 'application/json'
cli.azure.cli.core.sdk.policies:     'x-ms-client-request-id': 'e3a39b35-e136-11ee-893c-00155d10da08'
cli.azure.cli.core.sdk.policies:     'CommandName': 'cognitiveservices usage list'
cli.azure.cli.core.sdk.policies:     'ParameterSetName': '-l --filter --debug'
cli.azure.cli.core.sdk.policies:     'User-Agent': 'AZURECLI/2.58.0 (DEB) azsdk-python-core/1.28.0 Python/3.11.7 (Linux-5.15.133.1-microsoft-standard-WSL2-x86_64-with-glibc2.37)'
cli.azure.cli.core.sdk.policies:     'Authorization': '*****'
cli.azure.cli.core.sdk.policies: Request body:
cli.azure.cli.core.sdk.policies: This request has no body
urllib3.connectionpool: Starting new HTTPS connection (1): management.azure.com:443
urllib3.connectionpool: https://management.azure.com:443 "GET /subscriptions/SUB/providers/Microsoft.CognitiveServices/locations/westeurope/usages?api-version=2023-05-01&$filter=name.value%20eq%20%27OpenAI.Standard.text-embedding-ada-002%27%29 HTTP/1.1" 200 6488
cli.azure.cli.core.sdk.policies: Response status: 200
cli.azure.cli.core.sdk.policies: Response headers:
cli.azure.cli.core.sdk.policies:     'Cache-Control': 'no-cache'
cli.azure.cli.core.sdk.policies:     'Pragma': 'no-cache'
cli.azure.cli.core.sdk.policies:     'Content-Length': '6488'
cli.azure.cli.core.sdk.policies:     'Content-Type': 'application/json; charset=utf-8'
cli.azure.cli.core.sdk.policies:     'Expires': '-1'
cli.azure.cli.core.sdk.policies:     'X-Content-Type-Options': 'nosniff'
cli.azure.cli.core.sdk.policies:     'x-ms-request-id': 'a6821844-5c5d-461f-ada9-315b17917ff7'
cli.azure.cli.core.sdk.policies:     'x-envoy-upstream-service-time': '45'
cli.azure.cli.core.sdk.policies:     'Server': 'istio-envoy'
cli.azure.cli.core.sdk.policies:     'x-ms-ratelimit-remaining-subscription-reads': '11950'
cli.azure.cli.core.sdk.policies:     'x-ms-correlation-request-id': '6b986fc4-e301-4ca0-bac4-9d05056ad6ee'
cli.azure.cli.core.sdk.policies:     'x-ms-routing-request-id': 'GERMANYNORTH:20240313T124036Z:6b986fc4-e301-4ca0-bac4-9d05056ad6ee'
cli.azure.cli.core.sdk.policies:     'Strict-Transport-Security': 'max-age=31536000; includeSubDomains'
cli.azure.cli.core.sdk.policies:     'Date': 'Wed, 13 Mar 2024 12:40:36 GMT'
cli.azure.cli.core.sdk.policies: Response content:
cli.azure.cli.core.sdk.policies: {"value":[{"name":{"value":"OpenAI.Standard.code-cushman-001","localizedValue":"Tokens Per Minute (thousands) - Code-Cushman-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-cushman-fine-tune-002","localizedValue":"Tokens Per Minute (thousands) - code-cushman-fine-tune-002"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.FineTuned.Deployments","localizedValue":"Standard Fine-Tuned Deployments"},"currentValue":0,"limit":5,"unit":"Count"},{"name":{"value":"OpenAI.S0.AccountCount","localizedValue":"Maximum resources for OpenAI S0 sku."},"currentValue":14,"limit":30,"unit":"Count"},{"name":{"value":"OpenAI.Standard.whisper","localizedValue":"Requests Per Minute - whisper"},"currentValue":0,"limit":3,"unit":"Count"},{"name":{"value":"OpenAI.Standard.gpt-35-turbo","localizedValue":"Tokens Per Minute (thousands) - GPT-35-Turbo"},"currentValue":120,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.ada","localizedValue":"Tokens Per Minute (thousands) - Ada"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-search-ada-code-001","localizedValue":"Tokens Per Minute (thousands) - Code-Search-Ada-Code-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-search-ada-text-001","localizedValue":"Tokens Per Minute (thousands) - Code-Search-Ada-Text-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-ada-001","localizedValue":"Tokens Per Minute (thousands) - Text-Ada-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-embedding-ada-002","localizedValue":"Tokens Per Minute (thousands) - Text-Embedding-Ada-002"},"currentValue":940,"limit":940,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-ada-doc-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Ada-Doc-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-ada-query-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Ada-Query-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-similarity-ada-001","localizedValue":"Tokens Per Minute (thousands) - Text-Similarity-Ada-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.babbage","localizedValue":"Tokens Per Minute (thousands) - Babbage"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-search-babbage-code-001","localizedValue":"Tokens Per Minute (thousands) - Code-Search-Babbage-Code-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-search-babbage-text-001","localizedValue":"Tokens Per Minute (thousands) - Code-Search-Babbage-Text-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-babbage-001","localizedValue":"Tokens Per Minute (thousands) - Text-Babbage-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-babbage-doc-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Babbage-Doc-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-babbage-query-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Babbage-Query-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-similarity-babbage-001","localizedValue":"Tokens Per Minute (thousands) - Text-Similarity-Babbage-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.curie","localizedValue":"Tokens Per Minute (thousands) - Curie"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-curie-001","localizedValue":"Tokens Per Minute (thousands) - Text-Curie-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-curie-doc-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Curie-Doc-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-curie-query-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Curie-Query-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-similarity-curie-001","localizedValue":"Tokens Per Minute (thousands) - Text-Similarity-Curie-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-davinci-002","localizedValue":"Tokens Per Minute (thousands) - Code-Davinci-002"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.code-davinci-fine-tune-002","localizedValue":"Tokens Per Minute (thousands) - Code-Davinci-Fine-Tune-002"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.davinci","localizedValue":"Tokens Per Minute (thousands) - Davinci"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-davinci-001","localizedValue":"Tokens Per Minute (thousands) - Text-Davinci-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-davinci-002","localizedValue":"Tokens Per Minute (thousands) - Text-Davinci-002"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-davinci-003","localizedValue":"Tokens Per Minute (thousands) - Text-Davinci-003"},"currentValue":120,"limit":120,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-davinci-fine-tune-002","localizedValue":"Tokens Per Minute (thousands) - Text-Davinci-Fine-Tune-002"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-davinci-doc-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Davinci-Doc-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-search-davinci-query-001","localizedValue":"Tokens Per Minute (thousands) - Text-Search-Davinci-Query-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"OpenAI.Standard.text-similarity-davinci-001","localizedValue":"Tokens Per Minute (thousands) - Text-Similarity-Davinci-001"},"currentValue":0,"limit":240,"unit":"Count"},{"name":{"value":"AIServices.S0.AccountCount","localizedValue":"Maximum resources for AIServices S0 sku."},"currentValue":0,"limit":50,"unit":"Count"},{"name":{"value":"AccountCount","localizedValue":"Maximum Resources per Region"},"currentValue":14,"limit":200,"unit":"Count"}]}
cli.knack.cli: Event: CommandInvoker.OnTransformResult [<function _resource_group_transform at 0x7fe27c45f100>, <function _x509_from_base64_to_hex_transform at 0x7fe27c45f1a0>]
cli.knack.cli: Event: CommandInvoker.OnFilterResult []

Expected behavior

Filter should work as documented

Environment Summary

azure-cli 2.58.0

core 2.58.0
telemetry 1.1.0

Dependencies:
msal 1.26.0
azure-mgmt-resource 23.1.0b2

Python location '/opt/az/bin/python3'
Extensions directory '/home/bh/.azure/cliextensions'

Python (Linux) 3.11.7 (main, Feb 29 2024, 02:08:19) [GCC 11.4.0]

Legal docs and information: aka.ms/AzureCliLegal

Your CLI is up-to-date.

Additional context

No response

[yonzhan]

Thank you for opening this issue, we will look into it.

[david-koleckar]

any progress? CLI api for openai deployments is rather poor.