Jump to content
We've recently updated our Privacy Statement, available here ×

How to read nested JSON files in Jasper?


vaishalibas09

Recommended Posts

JSON file for example:

{

  "financialInstitutionId" : "101",

  "processorId" : "201",

  "runDate" : "10/13/2018",

  "settlementDate" : "20/20/2020",

  "reportName" : "InterchangeIncomeExpense",

  "BillingDescriptionList" : [

    {

      "billingDescriptionName" : "Cirrus Interchange Fee Type",

      "TransactionType" : [

          {

            "Name": "Acquirer Fee",

            "acceptedCount": "2",

            "acceptedAmount": "2",

            "rejectedCount": "2",

            "rejectedAmount": "2",

            "reversedCount": "2",

            "reversedAmount": "2",

            "totalCount": "2",

            "totalAmount": "2"

          },

          {

            "Name": "Acquirer Fee",

            "acceptedCount": "2",

            "acceptedAmount": "2",

            "rejectedCount": "2",

            "rejectedAmount": "2",

            "reversedCount": "2",

            "reversedAmount": "2",

            "totalCount": "2",

            "totalAmount": "2"

          }

        ],

      "BillingDescriptionTotal" : {

        "acceptedCount": "4",

        "acceptedAmount": "4",

        "rejectedCount": "4",

        "rejectedAmount": "4",

        "reversedCount": "4",

        "reversedAmount": "4",

        "totalCount": "16",

        "totalAmount": "16"

      }

    },

    {

      "billingDescriptionName" : "Pulse At T-BillPay",

      "TransactionType" : [

        {

          "Name": "Acquirer Fee",

          "acceptedCount": "2",

          "acceptedAmount": "2",

          "rejectedCount": "2",

          "rejectedAmount": "2",

          "reversedCount": "2",

          "reversedAmount": "2",

          "totalCount": "2",

          "totalAmount": "2"

        },

        {

          "Name": "Acquirer Fee",

          "acceptedCount": "2",

          "acceptedAmount": "2",

          "rejectedCount": "2",

          "rejectedAmount": "2",

          "reversedCount": "2",

          "reversedAmount": "2",

          "totalCount": "2",

          "totalAmount": "2"

        }

      ],

      "BillingDescriptionTotal" : {

        "acceptedCount": "4",

        "acceptedAmount": "4",

        "rejectedCount": "4",

        "rejectedAmount": "4",

        "reversedCount": "4",

        "reversedAmount": "4",

        "totalCount": "4",

        "totalAmount": "4"

      }

    }

  ]

}

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...