Nested Loop/code for converting JSON in predefined CSV format



  • 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


  • administrators

    hi @Amol-Lokhande

    here you have some example code that gets you an idea about how to do it.

    https://playground.jsreport.net/w/anon/9LO89XVj



  • Thank you so much


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.