title: Json normalize Facebook graph API
body: <p>I'm trying to normalize json request from Facebook Graph into a dataframe but only get 1 row with 4 columns as per table bellow.</p>
  <p>I pull the request using request method</p>
  <pre><code>import requests
  from pandas import json_normalize
  url = 'https://graph.facebook.com/v14.0/act_1135563643203528/campaigns?fields=name,date_preset=last_7d,insights{actions,action_values,conversions,conversion_values,impressions}&amp;access_token='+my_access_token
  
  response = requests.get(url)
  dictr = response.json()
  df = json_normalize(dictr)
  
  </code></pre>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>data</th>
  <th>paging.cursors.before</th>
  <th>paging.cursors.after</th>
  <th>paging.next</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>[{'name': 'SALES CAMPAIG</td>
  <td>QVVVV</td>
  <td>QQQQQ</td>
  <td>https://graph.facebook.com/v14.0/act_....</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I'd like to have a df as bellow table with all actions for analytics (results from request bellow)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>post_reaction</th>
  <th>.....</th>
  <th>omni_purchase</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>CAMPAIGN 1</td>
  <td>200</td>
  <td>...</td>
  <td>500</td>
  </tr>
  <tr>
  <td>CAMPAIGN 2</td>
  <td>111</td>
  <td>...</td>
  <td>222</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Json response</p>
  <pre><code>{'data': [{'name': 'SALES CAMPAIGN 1',
     'insights': {'data': [{'actions': [{'action_type': 'comment',
          'value': '11'},
         {'action_type': 'link_click', 'value': '440'},
         {'action_type': 'post_reaction', 'value': '48'},
         {'action_type': 'onsite_conversion.post_save', 'value': '2'},
         {'action_type': 'offsite_conversion.fb_pixel_purchase', 'value': '10'},
         {'action_type': 'offsite_conversion.fb_pixel_view_content',
          'value': '16'},
         {'action_type': 'offsite_conversion.fb_pixel_initiate_checkout',
          'value': '8'},
         {'action_type': 'landing_page_view', 'value': '282'},
         {'action_type': 'offsite_conversion.fb_pixel_search', 'value': '74'},
         {'action_type': 'post_engagement', 'value': '501'},
         {'action_type': 'page_engagement', 'value': '501'},
         {'action_type': 'omni_purchase', 'value': '10'},
         {'action_type': 'omni_view_content', 'value': '16'},
         {'action_type': 'omni_initiated_checkout', 'value': '8'},
         {'action_type': 'omni_search', 'value': '74'},
         {'action_type': 'purchase', 'value': '10'},
         {'action_type': 'view_content', 'value': '16'},
         {'action_type': 'initiate_checkout', 'value': '8'},
         {'action_type': 'search', 'value': '74'}],
        'action_values': [{'action_type': 'offsite_conversion.fb_pixel_purchase',
          'value': '18532'},
         {'action_type': 'offsite_conversion.fb_pixel_view_content',
          'value': '12135'},
         {'action_type': 'offsite_conversion.fb_pixel_initiate_checkout',
          'value': '6530'},
         {'action_type': 'omni_purchase', 'value': '18532'},
         {'action_type': 'omni_view_content', 'value': '12135'},
         {'action_type': 'omni_initiated_checkout', 'value': '6530'},
         {'action_type': 'initiate_checkout', 'value': '6530'}],
        'impressions': '85349',
        'date_start': '2022-05-22',
        'date_stop': '2022-06-20'}],
      'paging': {'cursors': {'before': 'MAZDZD', 'after': 'MAZDZD'}}},
     'id': '2372040507'},
  ...
    {'name': 'SALES CAMPAIGN 5',
     'insights': {'data': [{'actions': [{'action_type': 'onsite_conversion.post_save',
          'value': '2'},
         {'action_type': 'post', 'value': '3'},
         {'action_type': 'comment', 'value': '21'},
         {'action_type': 'link_click', 'value': '1387'},
         {'action_type': 'post_reaction', 'value': '64'},
         {'action_type': 'landing_page_view', 'value': '934'},
         {'action_type': 'offsite_conversion.fb_pixel_purchase', 'value': '20'},
         {'action_type': 'offsite_conversion.fb_pixel_view_content',
          'value': '42'},
         {'action_type': 'offsite_conversion.fb_pixel_initiate_checkout',
          'value': '15'},
         {'action_type': 'offsite_conversion.fb_pixel_search', 'value': '192'},
         {'action_type': 'post_engagement', 'value': '1477'},
         {'action_type': 'page_engagement', 'value': '1477'},
         {'action_type': 'omni_purchase', 'value': '20'},
         {'action_type': 'omni_view_content', 'value': '42'},
         {'action_type': 'omni_initiated_checkout', 'value': '15'},
         {'action_type': 'omni_search', 'value': '192'},
         {'action_type': 'purchase', 'value': '20'},
         {'action_type': 'view_content', 'value': '42'},
         {'action_type': 'initiate_checkout', 'value': '15'},
         {'action_type': 'search', 'value': '192'}],
        'action_values': [{'action_type': 'offsite_conversion.fb_pixel_purchase',
          'value': '48140'},
         {'action_type': 'offsite_conversion.fb_pixel_view_content',
          'value': '36319'},
         {'action_type': 'offsite_conversion.fb_pixel_initiate_checkout',
          'value': '11716'},
         {'action_type': 'omni_purchase', 'value': '48140'},
         {'action_type': 'omni_view_content', 'value': '36319'},
         {'action_type': 'omni_initiated_checkout', 'value': '11716'},
         {'action_type': 'initiate_checkout', 'value': '11716'}],
        'impressions': '280587',
        'date_start': '2022-05-22',
        'date_stop': '2022-06-20'}],
      'paging': {'cursors': {'before': 'MAZDZD', 'after': 'MAZDZD'}}},
    ],
   'paging': {'cursors': {'before': 'QVVVV',
     'after': 'QQQQ'},
    'next': 'https://graph.facebook.com/v14.0/act_111111111/campaigns?access_token=TOKEN#'}}
  
  
  </code></pre>