title: Formatting DynamoDB data to normal JSON in API gateway
body: <p>just like the question <a href="https://stackoverflow.com/questions/32712675/formatting-dynamodb-data-to-normal-json-in-aws-lambda">asked here</a></p>
  
  <p>I do a query or scan operation on dynamoDB using dynamoDB proxy service on AWS API Gateway to read data for the Client and I get DynamoDB formatted JSON data in reply.</p>
  
  <p>Although I can use the "Method Response" to convert but when the Data is above 1000 records - I cannot handle it due to the limitation of foreach loop in Method Response.</p>
  
  <p>Is there a flag or a setting somewhere in dynamodb or in api gateway such that I get normal json rather than the dynamoDB formatted JSON ?</p>
  
  <p>DynamoDB Formatted JSON example</p>
  
  <pre><code>{
    "videos": [
      {
        "file": {
          "S": "file1.mp4"
        },
        "id": {
          "S": "1"
        },
        "canvas": {
          "S": "This is Canvas1"
        }
      },
      {
        "file": {
          "S": "main.mp4"
        },
        "id": {
          "S": "0"
        },
        "canvas": {
          "S": "this is a canvas"
        }
      }
    ]
  }
  </code></pre>
  
  <p>Normal Json example of the same</p>
  
  <pre><code>{
    "videos": [
      {
        "file": "file1.mp4",
        "id": "1",
        "canvas": "This is Canvas1"
      },
      {
        "file": main.mp4",
        "id": "0",
        "canvas": "this is a canvas"
      }
    ]
  }
  </code></pre>