How should I get one item from Cosmos using the v3 API?

Question

I want to retrieve one item from Cosmos DB and there must be a better way than what I am doing here.

I've tried other commands, but this seems to actually work.

    public async Task<ToDoItem> GetAsync(string id)
    {
        FeedIterator<ToDoItem> results = container.GetItemQueryIterator<ToDoItem>("select top 1 * from Items i where i.id = '" + id + "'");

        FeedResponse<ToDoItem> item = await results.ReadNextAsync();

        return item.Resource.FirstOrDefault();
    }

I expect to be able to do this with one line that executes on the server and doesn't force me to look at a set of items.

The `container.ReadItem...` operations are for point-reads. – Matias Quaranta Jul 29 '19 at 18:06 — Matias Quaranta, Jul 29 '19 at 18:06

score 1 · Answer 1 · answered Jul 29 '19 at 01:54

1

Here is an example from the official document to query,

 using (ResponseMessage responseMessage = await container.ReadItemStreamAsync(
                partitionKey: new PartitionKey("Account1"),
                id: "SalesOrder1"))

answered Jul 29 '19 at 01:54

Sajeetharan

216,225
63
350
396

score 0 · Answer 2 · answered Jun 18 '20 at 05:31

The SDK is still in development - this may help:

using (ResponseMessage response = await _container.ReadItemStreamAsync(id: pageId, partitionKey: partitionKey))
{
    if (!response.IsSuccessStatusCode)
    {
        //Handle and log exception
    }

    await using (Stream stream = response.Content)
    {
        using (var streamReader = new StreamReader(stream))
        {
            string content = streamReader.ReadToEnd();
        }
    }
}

How should I get one item from Cosmos using the v3 API?

2 Answers2