How to pull down an schema-less JSON document from CosmosDB in Xamarin App

Question

I am creating an app in Xamarin and am having issues querying a general JSON document from my CosmosDB. I am able to query my DB with a known structure (very similar to what we see in the Xamarin ToDo Example):

public async static Task<List<ToDoItem>> GetToDoItems()
{
var todos = new List<ToDoItem>();

if (!await Initialize())
    return todos;

**var todoQuery = docClient.CreateDocumentQuery<ToDoItem>(
    UriFactory.CreateDocumentCollectionUri(databaseName, collectionName),
    new FeedOptions { MaxItemCount = -1, EnableCrossPartitionQuery = true })
    .Where(todo => todo.Completed == false)
    .AsDocumentQuery();**

while (todoQuery.HasMoreResults)
{
    var queryResults = await todoQuery.ExecuteNextAsync<ToDoItem>();

    todos.AddRange(queryResults);
}

return todos;
}

The problem I see with this "code fixed scheme" approach is that if the scheme of your JSON file changes throughout development, older versions of code will overwrite the newer scheme in CosmosDB since writes to the DB are on a document level and not a property level. Instead, it would be helpful for older versions of the code to be able to pull down the latest scheme and work with the properties that it knows about without having to force the user to update.

Does anyone know how to query a schema-less JSON document out of CosmosDB? Thanks!

question from:https://stackoverflow.com/questions/66054513/how-to-pull-down-an-schema-less-json-document-from-cosmosdb-in-xamarin-app

Answer 1

Use JObject as the type to query a schema-less JSON document out of CosmosDB, and use following code to pull the raw JSON data into your object:

JsonConvert.DeserializeObject<Class>(JSONString);