title: Python how to parse output of Amazon RDS Data Service
body: <p>I'm struggling to parse output of ExecuteStatement action using Amazon RDS Data service <a href="https://docs.aws.amazon.com/rdsdataservice/latest/APIReference/API_ExecuteStatement.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/rdsdataservice/latest/APIReference/API_ExecuteStatement.html</a></p>
  
  <p>Documentation is very poor and I can't find any meaningful examples.</p>
  
  <p>I'm using Aurora MySql DB </p>
  
  <p>Output is returned like this. This example is 2 rows of data returned by SELECT statement, I've replaced actual data with word "data" </p>
  
  <pre><code> {'ResponseMetadata': {'RequestId': '955a6aee-5bad-4f87-a455-b83a10a8a31b', 'HTTPStatusCode': 200, 'HTTPHeaders': {'x-amzn-requestid': '955a6aee-5bad-4f87-a455-b83a10a8a31b', 'content-type': 'application/json', 'content-length': '809', 'date': 'Tue, 02 Jun 2020 05:39:22 GMT'}, 'RetryAttempts': 0}, 'numberOfRecordsUpdated': 0, 'records': [[{'stringValue': 'data'}, {'longValue': data}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': ''}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}], [{'stringValue': 'data'}, {'longValue': data}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': ''}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}, {'stringValue': 'data'}]]}
  </code></pre>
  
  <p>I need to extract actually only this data fields, so I can use them for INSERT statement in another table. </p>
  
  <p>As per documentation original response is dictionary data type, so I get 3 keys here 'ResponseMetadata', 'numberOfRecordsUpdated' and 'records'. 
  As per documentation 'records' is Type: Array of arrays of Field objects and here is where I stuck. How I can extract Field objects from array of arrays inside dictionary? </p>