Thank you so much

Hello Team,

Here is the JSON which I want to convert into CSV format.

{
"text": "2468",
"children": [
{
"text": "Union Bank",
"data": {
"subTotPending": 0,
"subTotPosted": 140577.77,
"subTotal": 140577.77
}
},
{
"text": "Bank of America",
"data": {
"subTotPending": -251522.13,
"subTotPosted": 251522.13,
"subTotal": 0
}
},
{
"text": "SubTotal",
"data": {
"subTotPosted": 392099.9,
"subTotPending": -251522.13,
"subTotal": 140577.77
}
}
],
"data": {
"subTotPosted": 392099.9,
"subTotPending": -251522.13,
"subTotal": 140577.77
}
}

I am looking for converting this JSON in below format in CSV

Company,Bank Account,Posted,Pending,Ledger Balance
,,,,
2468,Union Bank,140577.77,0,140577.77
2468,Bank of America,251522.13,-251522.13,0
Sub Total,,392099.9,-251522.13,140577.77

How to write the code to convert it in above CSV format.

Regards,
Amol Lokhande

Currently we are in last phase of completing our project using Free license of JS Report framework. We would like to go for purchasing the license version of JS Report.

Here is our current infrastructure

1. Live Environment
2. Stage Environment
3. Two local workstations.

Based on this infrastructure need we would like to purchase the cost friendly license. Currently we are using On-Premise free license.

We would also like to know difference between On-Premise and On-SaaS license and which one is more suitable for us.

Regards,
Amol Lokhande