How to query in DynamoDb using a parameter which is a field inside JSON?

[Monica Shiralkar]

I created a DynamoDb table ProductCatalog. Next, I created a item with id (primary key) as 1, title as 'Book 210 Title' and vendorInfo as the below JSON:

{
    "V01": {
        "Name": "Acme Books",
        "Offices": [ "Seattle" ]
    },
    "V02": {
        "Name": "New Publishers, Inc.",
        "Offices": ["London", "New York"
        ]
    },
    "V03": {
        "Name": "Better Buy Books",
        "Offices": [ "Tokyo", "Los Angeles", "Sydney"
        ]
    }
}

This constitutes one item.


I did a scan on the table which displayed the item. Next, I did a query by specifying id as 1, it returned the item as result.

I am now trying to query using a parameter which is inside the JSON (for example : name under VO1 which has the value 'Acme Books').
I tried by specifying VO1.name but it did not return results.

I have seen such kind of querying in CosmosDb which is also a document oriented NoSql database like DynamoDb.


How do I try such kind of query ?
Thanks.