title: How to convert json to FoxPro cursor
body: <p>File contains invoice list in json format like:</p>
  
  <pre>{
      "status": "OK", "statusCode": 200, "messages": null,
      "data": [{
          "payment_type": "banktransfer", "fine": "0.200000", "quote_id": null, "order_id": null, "prepayment_id": null, "credited_invoices": [],
          "interested_party_address_id": 279, "project_id": 875, "currency": "EUR", "owner_id": 3, "date": "2019-03-15", "deadline": "2019-03-20",
      },
  
      {
          "payment_type": "banktransfer", "fine": "0.30000", "quote_id": null, "order_id": null, "prepayment_id": null, "credited_invoices": [],
          "interested_party_address_id": 79, "project_id": 85, "currency": "EUR", "owner_id": 3, "date": "2019-04-15", "deadline": "2019-43-20",
      }
      .... more same type elements
      ]
  }
  </pre>
  
  <p>How to convert it to FoxPRo cursor ?
  Cursor should contain payment_type, fine, quote_id etc columns.</p>
  
  <p>I tried</p>
  
  <p><a href="https://archive.codeplex.com/?p=qdfoxjson" rel="nofollow noreferrer">https://archive.codeplex.com/?p=qdfoxjson</a></p>
  
  <p>and</p>
  
  <p><a href="http://www.sweetpotatosoftware.com/blog/index.php/2008/12/19/visual-foxpro-json-class-update/" rel="nofollow noreferrer">http://www.sweetpotatosoftware.com/blog/index.php/2008/12/19/visual-foxpro-json-class-update/</a></p>
  
  <p>but it looks like they require json to be in different format than my json.</p>
  
  <p>Andrus</p>