How to store and fetch nested json data from dynamodb in java

Question

I want to maintain a book library. At a time i want to fetch the records to find out books available in library based on **available** flag.
Sample json to maintain book details.

```
{
    "totalNumberOfBooks":"30",
    "booksTypes":[
        {
        "language":"english",
        "books":[
            {
                "bookID":"1223",
                "booName":"XYZ",
                "available":false
            },            {
                "bookID":"2223",
                "booName":"ABC",
                "available":true
            }
        ]

    },{
        "language":"Spanish",
        "books":[
            {
                "bookID":"67666",
                "booName":"DEF",
                "available":false
            },            {
                "bookID":"56567",
                "booName":"GHEE",
                "available":true
            }
        ]

    }
    ]

}
```

Please help me to represent this in dynamodb. I want to store and fetch record in java language.

I tried to use dynamDBDocument for the internal json, ans tried to use filter expression as books.available, but i am not able to filter the records based on this.
```
{
                "bookID":"1223",
                "booName":"XYZ",
                "available":false
}
```

Comments

Hi, @Saswat,

Are you facing any error executing your code? What is wrong happening with the code or do you want an exact customized code regarding your query?