It works if the id is single quoted.
Error with double quoted string:
{"status":500,"message":"Syntax error: Missing expression. To mitigate this issue, please refer to the troubleshooting guidelines here at https://aka.ms/azmcp/troubleshooting.","results":{"message":"Syntax error: Missing expression","stackTrace":" at Kusto.Cloud.Platform.Http.KustoHttpClient.ThrowKustoExceptionFromResponseMessageAsync(KustoExceptionContext exceptionContext, HttpResponseMessage responseMessage, ClientRequestProperties properties, Boolean shouldBuffer, Action\u00602 notify)\r\n at Kusto.Data.Net.Client.RestClient2.MakeHttpRequestAsyncImpl(String address, String csl, String ns, String databaseName, Boolean streaming, ClientRequestProperties properties, ServiceModelTimeoutKind timeoutKind, String clientRequestId, Stream body, StreamProperties streamProperties, CancellationToken cancellationToken, KustoProtocolRequest request, String hostHeaderOverride)\r\n at Kusto.Cloud.Platform.Utils.MonitoredActivity.InvokeAsync[TActivityType,TResult](TActivityType activityType, Func\u00601 func, String clientRequestId)\r\n at Kusto.Cloud.Platform.Utils.MonitoredActivity.InvokeAsync[TActivityType,TResult](TActivityType activityType, Func\u00601 func, String clientRequestId)\r\n at Kusto.Data.Net.Client.RestClient2.MakeHttpRequestAsync(ActivityType activityType, String baseAddress, String relativeAddress, String clientRequestIdPrefix, String ns, String databaseName, String csl, String addr, Boolean streaming, ClientRequestProperties properties, ServiceModelTimeoutKind timeoutKind, StreamProperties streamProperties, CancellationToken cancellationToken)\r\n at Kusto.Data.Net.Client.RestClient2.ExecuteQueryAsync(String databaseName, String query, ClientRequestProperties properties)\r\n at AzureMcp.Services.Azure.Kusto.KustoService.QueryItems(String clusterUri, String databaseName, String query, String tenant, Nullable\u00601 authMethod, RetryPolicyArguments retryPolicy) in D:\a\_work\1\s\src\Services\Azure\Kusto\KustoService.cs:line 286\r\n at AzureMcp.Commands.Kusto.QueryCommand.ExecuteAsync(CommandContext context, ParseResult parseResult) in D:\a\_work\1\s\src\Commands\Kusto\QueryCommand.cs:line 78","type":"SyntaxException"},"duration":0}
It works if the id is single quoted.
Error with double quoted string:
{"status":500,"message":"Syntax error: Missing expression. To mitigate this issue, please refer to the troubleshooting guidelines here at https://aka.ms/azmcp/troubleshooting.","results":{"message":"Syntax error: Missing expression","stackTrace":" at Kusto.Cloud.Platform.Http.KustoHttpClient.ThrowKustoExceptionFromResponseMessageAsync(KustoExceptionContext exceptionContext, HttpResponseMessage responseMessage, ClientRequestProperties properties, Boolean shouldBuffer, Action\u00602 notify)\r\n at Kusto.Data.Net.Client.RestClient2.MakeHttpRequestAsyncImpl(String address, String csl, String ns, String databaseName, Boolean streaming, ClientRequestProperties properties, ServiceModelTimeoutKind timeoutKind, String clientRequestId, Stream body, StreamProperties streamProperties, CancellationToken cancellationToken, KustoProtocolRequest request, String hostHeaderOverride)\r\n at Kusto.Cloud.Platform.Utils.MonitoredActivity.InvokeAsync[TActivityType,TResult](TActivityType activityType, Func\u00601 func, String clientRequestId)\r\n at Kusto.Cloud.Platform.Utils.MonitoredActivity.InvokeAsync[TActivityType,TResult](TActivityType activityType, Func\u00601 func, String clientRequestId)\r\n at Kusto.Data.Net.Client.RestClient2.MakeHttpRequestAsync(ActivityType activityType, String baseAddress, String relativeAddress, String clientRequestIdPrefix, String ns, String databaseName, String csl, String addr, Boolean streaming, ClientRequestProperties properties, ServiceModelTimeoutKind timeoutKind, StreamProperties streamProperties, CancellationToken cancellationToken)\r\n at Kusto.Data.Net.Client.RestClient2.ExecuteQueryAsync(String databaseName, String query, ClientRequestProperties properties)\r\n at AzureMcp.Services.Azure.Kusto.KustoService.QueryItems(String clusterUri, String databaseName, String query, String tenant, Nullable\u00601 authMethod, RetryPolicyArguments retryPolicy) in D:\a\_work\1\s\src\Services\Azure\Kusto\KustoService.cs:line 286\r\n at AzureMcp.Commands.Kusto.QueryCommand.ExecuteAsync(CommandContext context, ParseResult parseResult) in D:\a\_work\1\s\src\Commands\Kusto\QueryCommand.cs:line 78","type":"SyntaxException"},"duration":0}