Query Values from Cosmos DB and Return Value to a JSON File

Question

I need to be able to query values from a Cosmos DB table and display those values to a JSON file. Is this possible?

//Cosmos Table
{
"id": "usagecounters.mt",
"Logs": null,
"QnAMaker": 228,
"QnAMakerFixYes": 86,
"QnAMakerFixNo": 4,
"HolidayMenuCalls": 10,
"HolidayMenuFixYes": 18,
"HolidayMenuFixNo": 1,
"DCOpsMenuCalls": 19,
"DCOpsMenuFixYes": 15,
"DCOpsMenuFixNo": 0
}

//JSON File
{
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"type": "AdaptiveCard",
"version": "1.0",
"body": [
   {
  "type": "TextBlock",
  "text": "[QnA Maker Value]", //Value from Cosmos DB
  "weight": "bolder",
  "size": "medium"
},

I need to be able to query values from a Cosmos DB table and display those values to a JSON file.

Sajeetharan · Accepted Answer · 2019-10-07 17:28:40Z

1

Those 2 are two different things, you can just use where clause to query the data

 SELECT d.QnAMaker
    FROM doc d
    WHERE d.id = "usagecounters.mt"

and you could write the whole object to JSON file

answered Oct 7, 2019 at 17:28

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mdrichardson Over a year ago

I provide a similar answer here, with some additional options.

Collectives™ on Stack Overflow

Query Values from Cosmos DB and Return Value to a JSON File

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related