Azure Table Storage - 501 Not Implemented

Question

I'm following this guide for using Azure Tables: https://learn.microsoft.com/en-us/dotnet/api/overview/azure/data.tables-readme-pre which uses the Azure.Data.Tables NuGet package.

I can successfully save a row and see it in the storage explorer within the Azure portal, however when trying to do a simple query, I'm getting back:

Unhandled exception. Azure.RequestFailedException: Service request failed.
Status: 501 (Not Implemented)

Content:
{"odata.error":{"code":"NotImplemented","message":{"lang":"en-US","value":"The requested operation is not implemented on the specified resource.\nRequestId:0137da3a-f002-0031-19
d6-5234ab000000\nTime:2021-05-27T08:59:39.8919922Z"}}}

My code for the query is:

    var entities = _tableClient
        .Query<TableEntity>(t => t.PartitionKey == PartitionKey)
        .ToList();

TableQuery query = new TableQuery().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, partitionKey)); this one? — Sajeetharan, May 27 '21 at 09:28
Maybe the SDK isn't fully functional yet as it's stated to still be in beta. Doing the same with the `Microsoft.Azure.Cosmos.Table` package using `var query = table.CreateQuery().Where(x => x.PartitionKey == "test").ToList();` seems to work without issue for me. Haven't tried the beta package. — NotFound, May 27 '21 at 10:05
Have to say the number of client libraries makes this very confusing — David Masters, May 27 '21 at 10:44
I am able to run the code above without any issues against a table in my storage account. Can you share your complete code or provide more details? — Gaurav Mantri, May 27 '21 at 11:39
In my case, the problem was with connection_string, in the endpoint I've included the table name as well, that's why it wasn't working. After just giving the the url without table it is working fine. — Indrajeet Singh, Apr 04 '22 at 11:24

score 2 · Answer 1 · answered Oct 06 '21 at 04:00

I ran in to this exact problem as well, and although it doesn't seem to be documented anywhere, the following worked for me:

var token = new DefaultAzureCredential();
var tableServiceClient = new TableServiceClient(new Uri($"https://{storageAccountName}.table.core.windows.net/"), token);
var client = tableServiceClient.GetTableClient(tableName);
var entities = client.Query<MyEntity>(filter: $"PartitionKey eq '{partKey}'");

I don't exactly understand why the direct creation of TableClient:

new TableClient(new Uri($"https://{storageAccountName}.table.core.windows.net/{tableName}"), tableName, token);

doesn't work, but going through TableServiceClient first worked for me. Give that a try.

score 1 · Answer 2 · answered Nov 18 '21 at 18:35

I had this issue in the java SDK when i created the client like so:

new TableClientBuilder()   
        .endpoint("https://{storageAccountName}.table.core.windows.net/{tableName}")
                .sasToken(sas)
                .tableName(tableName)
                .buildClient()

So what i did wrong was putting the table name as part of the endpoint and removing it stopped the exception.

Azure Table Storage - 501 Not Implemented

2 Answers2