Node.js-TS Express服务读取Azure表存储失败，报错请求操作未实现

使用Node.js-TS Express服务，通过@azure/data-tables SDK读取Azure表存储（表名tracker，PartitionKey为tracker）时，调用listEntities或getEntities方法报错：

The requested operation is not implemented on the specified resource.

• 已确认可正常写入该表，使用SAS令牌调用也出现相同错误
• 相同凭据在SpringBoot项目中可正常读取该表

原代码 #

import { AzureNamedKeyCredential, TableClient, TableServiceClient, odata , AzureSASCredential, generateTableSas } from "@azure/data-tables";
import { Mail, MailEntity } from "../models/mail";
import { DefaultAzureCredential } from "@azure/identity";

const accountName = process.env.ACCOUNT_NAME || "";
const accountKey = process.env.ACCOUNT_KEY || "";
const tablesUrl = process.env.TABLES_URL || "";
const tableName = process.env.TABLE_NAME || "";
const sas_token = process.env.SAS_TOKEN || "";

const creds = new AzureNamedKeyCredential(accountName, accountKey)

const client = new TableClient(tablesUrl, tableName, creds);


client.listEntities({
    queryOptions: { filter: odata`PartitionKey eq tracker` }
  }).next().then((result)=>{
    result.value.entities.forEach((res:MailEntity)=>{
        console.log(res)
    })
  }).catch((error)=>{
    console.log(error.message)
    console.log("Error listing all entities")
  })

1. 修正OData过滤器的字符串格式 #

OData表达式中字符串值必须用单引号包裹，原代码中PartitionKey eq tracker缺少单引号，会导致过滤器解析错误，进而引发异常。修改后的过滤器：

queryOptions: { filter: odata`PartitionKey eq 'tracker'` }

2. 确认Table服务URL格式 #

确保tablesUrl的格式与你的Azure表存储类型匹配：

• 传统Azure Table Storage：格式应为https://<account-name>.table.core.windows.net
• Azure Cosmos DB Table API：格式应为https://<account-name>.documents.azure.com:443/
  如果URL格式错误，SDK可能无法正确识别服务类型，导致不支持的操作请求。

3. 切换到@azure/storage-tables SDK #

@azure/data-tables是统一的表服务SDK，但部分场景下与传统Azure Table Storage存在兼容性问题。而SpringBoot使用的是针对传统Table Storage优化的SDK，可尝试切换到专门的@azure/storage-tables：

安装依赖 #

npm install @azure/storage-tables

修改后的读取代码 #

import { TableClient, AzureNamedKeyCredential } from "@azure/storage-tables";
import { MailEntity } from "../models/mail";

const accountName = process.env.ACCOUNT_NAME || "";
const accountKey = process.env.ACCOUNT_KEY || "";
const tableName = process.env.TABLE_NAME || "";

const creds = new AzureNamedKeyCredential(accountName, accountKey);
const client = new TableClient(`https://${accountName}.table.core.windows.net`, tableName, creds);

async function listEntities() {
  try {
    const entities = client.listEntities({
      filter: "PartitionKey eq 'tracker'"
    });
    for await (const entity of entities) {
      console.log(entity as MailEntity);
    }
  } catch (error) {
    console.log((error as Error).message);
    console.log("Error listing all entities");
  }
}

listEntities();

4. 验证SAS令牌权限（若使用） #

如果使用SAS令牌访问，确保令牌包含读取权限（r），生成SAS时需指定permissions: "r"或包含r的权限组合（如"rw"）。

内容的提问来源于stack exchange，提问作者Sudhanva Kote