How i can write the dynamo query

I have created a table and inserted values

{
 "programname": {
 "S": "progressive"
  },
 "statecode": {
  "S": "TX"
 },
"ziprule": {
 "M": {
  "reason": {
    "S": "This policy is not eligible since the property address is in zip list"
  },
  "response": {
    "S": "No"
  },
  "zip": {
    "L": [
      {
        "S": "682040"
      },
      {
        "S": "682041"
      },
      {
        "S": "682042"
      },
      {
        "S": "682043"
      },
      {
        "S": "682044"
      },
      {
        "S": "682045"
      },
      {
        "S": "682046"
      },
      {
        "S": "682047"
      },
      {
        "S": "682048"
      },
      {
        "S": "682049"
       }
      ]
     }
    }
    }
  }

I need to check the following zip (682045)in the zip list.Can i get the result in a single query or i need to write the code for json array iteration for finding the zip. Please help me to write a query for this.is there any better way to design the dynamo DB

from Recent Questions - Stack Overflow https://ift.tt/2TFVV6k
https://ift.tt/eA8V8J