TEXT TO myjson noshow { "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" }] } ENDTEXT oJson = nfJsonread(m.myjson) create cursor myCursor ( payment_Type v(20), fine v(20), date c(10) ) for each oRow in oJson.data insert into myCursor from name oRow endfor browseCheck this thread to find some techniques I shared to work with complex objects: