title: How do i access JSON data to send to Pandas?
body: <p>I make a call to an API and get a JSON response. For the better half of 2 days i have been trying to access the data, and send it to a CSV file, or push it to Pandas with no luck. I have gone through page after page of assistance, but something is just not clicking. </p>
  
  <p>Below is the JSON data, all i need are the following elements <strong>singleLineAddress</strong>, <strong>isAgentsAdvice</strong> &amp; <strong>contractDate</strong></p>
  
  <pre><code>[
    {
      "_embedded":{
        "propertySummaryList":[
          {
            "propertySummary":{
              "address":{
                "singleLineAddress":"Example St"
              },
              "id":47328284,
              "lastSaleDetail":{
                "contractDate":"Example",
                "isAgentsAdvice":Yes,
                "isArmsLength":0,
                "isPriceWithheld":0,
  </code></pre>
  
  <p>The ideal end result would be a csv export that had the following column names</p>
  
  <p><strong>Address</strong> | <strong>AA</strong> | <strong>Contract_Date</strong></p>
  
  <p>So far i've tried to create a simple dataframe in python, however it seems to always print on singular lines, so i moved over to attempting to 'flatten' the file for easier processing, but no data was extracted at all in those attempts.</p>
  
  <p>I attempted to follow a few github recipes, but the overall theme seemed to be just flattening the data, which as above didnt seem to work well with my json file.</p>
  
  <p>I attempted the normal dataframe route but didnt have much luck, my main focus has been in both json_normalize, and flatten_json type work, but if someone wants to offer a better solution, i am all ears. </p>
  
  <p>Any help is appreciated. I'd appreciate any leads on what may be 'missing' from my knowledge base around JSON and Pandas as it's been quite handy the last few weeks.</p>
  
  <p>Cheers</p>