'Query Nested DynamoDB Attributes using c#

In the below example ConsumerID is Range Key & RetailerID is Sort Key. Besides this, I want to query the JSON using a specific item_id (ex: item_id = "3dc8dbfa-fc12-4fd1-8485-be768b2c464d"). Is this possible with just query & not use Scan operation in DynamoDB?

{
"ConsumerID":"DHDHDHDHD",
"RetailerID":"szdfdzzf",  
"ConsumerInfo": {
  "IsReferred": 1,
  "IsSecReceipt": "N",
  "IsSplitLimit": 0,
  "ReceiptStatus": "Y",
  "ReferralStatus": "Inprogress",
  "SplitStatus": "Open",
  "TempID2": null,
  "TempID3": null,
  "TempID4": null,
  "itemMapping": 
  [
   {
    "issubscribed": 0,
    "ratingstatus": "Open",
    "internal_id": null,
    "isratinglimit": 0,
    "item_id": "79214470-b639-4edd-9218-abee1755708e",
    "subscribestatus": "Open"
   },
   {
    "issubscribed": 0,
    "ratingstatus": "Open",
    "internal_id": null,
    "isratinglimit": 0,
    "item_id": "3dc8dbfa-fc12-4fd1-8485-be768b2c464d",
    "subscribestatus": "Open"
   }
   ]
}
}


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source