c# - 如何使用 Core(SQL) API 从 Azure Cosmos Db 检索数据

Question

美好的一天，

我正在 Visual Studio 中使用 .net Framework/V1 开发一个 azure 函数，我想从 Azure 函数上的 TestData 集合中检索 clientDetails 数据，我的函数是HttpTrigger。

我尝试了此链接中的示例:Azure Cosmos DB bindings for Azure Functions 1.x

我创建了两个属性类:

    public class DocumentClient
    {
        [JsonProperty("clientDetails")]
        public List<ClientDetails> clientDetails { get; set; }
    }

    public class ClientDetails
    {
        public string domain { get; set; }
        public string channel { get; set; }
        public string retailer { get; set; }
        public string store { get; set; }
        public string auth { get; set; }
    }

这是构造函数:

public static async Task<HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function), Disable()]HttpRequestMessage req, [DocumentDB(
        databaseName: "Client",
        collectionName: "TestData",
        ConnectionStringSetting = "CosmosDBConnection"
       )] DocumentClient client, TraceWriter log)

但是当我运行该函数时，但每当我尝试添加时，我都会遇到错误 Id is required

Id ="{Hardcoded - the TestData's Id}"

触发函数时，我遇到错误“必须为此操作提供 PartitionKey 值”

我将其添加到我的 local.settings.json 中:

"CosmosDBConnection": "AccountEndpoint=https://test.com:443/;AccountKey=testkey==;"

问候

Answer 1

I am having an error "PartitionKey value must be supplied for this operation" when the function is triggered

根据这个错误消息，我认为你需要在你的function.json文件中设置partitionKey。请引用这个supported properties list .

PartitionKey Specifies the partition key value for the lookup. May include binding parameters.

这是一个示例:

{
    "name": "inputDocument",
    "type": "documentDB",
    "databaseName": "MyDatabase",
    "collectionName": "MyCollection",
    "id" : "{queueTrigger}",
    "partitionKey": "{partition key value}",
    "connection": "MyAccount_COSMOSDB",
    "direction": "in"
}