title: Extract data from array - Python
body: <p>I am using the unleashed_py library to extract Unleashed data.</p>
  <p>The sample of the output is as below where there could be several items in the invoice:</p>
  <pre><code>[{
   'OrderNumber': 'SO-00000742',
    'QuoteNumber': None,
    'InvoiceDate': '/Date(1658496322067)/',
    'InvoiceLines': [{'LineNumber': 1,
      'LineType': None},
     {'LineNumber': 2,
      'LineType': None}],
    'Guid': '8f6b89da-1e6e-42288a24-902a-038041e04f06',
    'LastModifiedOn': '/Date(1658496322221)/'}]
  </code></pre>
  <p>I need to get a df:</p>
  <p><a href="https://i.stack.imgur.com/K8rUW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K8rUW.png" alt="enter image description here" /></a></p>
  <p>If I run the below script, the invoice lines just get appended with the common fields such as ordernumber, quotenumber, invoicedate, guide, and lastmodifiedon not getting repeated.</p>
  <pre><code>order_number = []
  quote_number = []
  invoice_date = []
  invoicelines = []
  invoice_line_number = []
  invoice_line_type = []
  guid = []
  last_modified = []
  
  
  for item in df:
      order_number.append(item.get('OrderNumber'))
      quote_number.append(item.get('QuoteNumber'))
      invoice_date.append(item.get('InvoiceDate'))
      guid.append(item.get('Guid'))
      last_modified.append(item.get('LastModifiedOn'))
      lines = item.get('InvoiceLines')
      for item_sub_2 in lines:
          invoice_line_number.append('LineNumber')
          invoice_line_type.append('LineType')
  
  df_order_number = pd.DataFrame(order_number)
  df_quote_number = pd.DataFrame(quote_number)
  df_invoice_date = pd.DataFrame(invoice_date)
  df_invoice_line_number  = pd.DataFrame(invoice_line_number)
  df_invoice_line_type = pd.DataFrame(invoice_line_type)
  df_guid = pd.DataFrame(guid)
  df_last_modified = pd.DataFrame(last_modified)
  
  df_row = pd.concat([
  df_order_number,
  df_quote_number,
  df_invoice_date,
  df_invoice_line_number,
  df_invoice_line_type,
  df_guid,
  df_last_modified
  ], axis = 1)
  </code></pre>
  <p>What am I doing wrong?</p>