title: Parse json from Facebook API response using Python
body: <p>I get repsonse from facebook API which look like</p>
  <pre><code>{
     &quot;data&quot;: [
        {
           &quot;query_id&quot;: &quot;72254xxxxxxxxxxxxxxxxbe1d18e4f&quot;,
           &quot;results&quot;: [
              {
                 &quot;time&quot;: &quot;2022-01-17T08:00:00+0000&quot;,
                 &quot;metric&quot;: &quot;fb_ad_network_revenue&quot;,
                 &quot;breakdowns&quot;: [
                    {
                       &quot;key&quot;: &quot;property&quot;,
                       &quot;value&quot;: &quot;123456&quot;
                    },
                    {
                       &quot;key&quot;: &quot;placement&quot;,
                       &quot;value&quot;: &quot;12345678&quot;
                    },
                    {
                       &quot;key&quot;: &quot;placement_name&quot;,
                       &quot;value&quot;: &quot;Placement for Page 1234567&quot;
                    }
                 ],
                 &quot;value&quot;: &quot;8900.28367527&quot;
              },
              {
                 &quot;time&quot;: &quot;2022-01-17T08:00:00+0000&quot;,
                 &quot;metric&quot;: &quot;fb_ad_network_revenue&quot;,
                 &quot;breakdowns&quot;: [
                    {
                       &quot;key&quot;: &quot;property&quot;,
                       &quot;value&quot;: &quot;7654321&quot;
                    },
                    {
                       &quot;key&quot;: &quot;placement&quot;,
                       &quot;value&quot;: &quot;876543&quot;
                    },
                    {
                       &quot;key&quot;: &quot;placement_name&quot;,
                       &quot;value&quot;: &quot;FIA - Recirculation Ad&quot;
                    }
                 ],
                 &quot;value&quot;: &quot;8900.55334339&quot;
              },
  </code></pre>
  <p>I need to convert that to dataframe
  <a href="https://i.stack.imgur.com/8htjx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8htjx.png" alt="enter image description here" /></a></p>
  <p>My code doesn't work properly, because of repetitions of key, value in &quot;breakdowns&quot; section</p>
  <pre><code>json_normalize(data['data'],['results','breakdowns',],meta=[['results','metric'],['results','value'],['results','time']])
  </code></pre>
  <p><a href="https://i.stack.imgur.com/5H4EO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5H4EO.png" alt="enter image description here" /></a></p>
  <p><strong>Thanks in advance for any ideas how to convert this json to desired form of pandas df.</strong></p>