How to fetch the JSON array data?

[devalvelociter]

I have a JSON array data as shown below:

[
    {
        "maskedAccountNo": "XXXXXXXX0255",
        "encryptedAccountno": "b+FEfnck2stUQrF717l5cg==",
        "originalAccountNo": "000405010255"
    },
    {
        "maskedAccountNo": "XXXXXXXX0310",
        "encryptedAccountno": "vAYKVrONThkhm+ojJNyxlA==",
        "originalAccountNo": "000405010310"
    },
    {
        "maskedAccountNo": "XXXXXXXX9777",
        "encryptedAccountno": "7s5LtrZOFNuXbWyK8uPuZw==",
        "originalAccountNo": "000405009777"
    },
    {
        "maskedAccountNo": "XXXXXXXX9537",
        "encryptedAccountno": "CA6OfyG4e5qilJNU8fidbg==",
        "originalAccountNo": "000401109537"
    },
    {
        "maskedAccountNo": "XXXXXXXX3460",
        "encryptedAccountno": "LghvCavQnj8qdU14ztVI+A==",
        "originalAccountNo": "000401113460"
    },
    {
        "maskedAccountNo": "XXXXXXXX6861",
        "encryptedAccountno": "gbowyGIyNARJs8fBNYSCew==",
        "originalAccountNo": "000401116861"
    },
    {
        "maskedAccountNo": "XXXXXXXX5288",
        "encryptedAccountno": "LRjDbvHN6/GQMzI+nAUNUg==",
        "originalAccountNo": "001805015288"
    },
    {
        "maskedAccountNo": "XXXXXXXX7715",
        "encryptedAccountno": "cRvrdsfsP93OIWLQ8qATLw==",
        "originalAccountNo": "628801537715"
    },
    {
        "maskedAccountNo": "XXXXXXXX0184",
        "encryptedAccountno": "NFPATcX88EAaUSaaKtdu2Q==",
        "originalAccountNo": "000319000184"
    },
    {
        "maskedAccountNo": "XXXXXXXX3586",
        "encryptedAccountno": "GDPSkzAzIKvWBzU99JG/nQ==",
        "originalAccountNo": "000401193586"
    },
    {
        "maskedAccountNo": "XXXXXXXX1139",
        "encryptedAccountno": "T6KpxvMopUUWM58lN0xTkA==",
        "originalAccountNo": "000405111139"
    },
    {
        "maskedAccountNo": "XXXXXXXX1186",
        "encryptedAccountno": "en8YgoFjMxAfaVDbSMVV2Q==",
        "originalAccountNo": "000405501186"
    },
    {
        "maskedAccountNo": "XXXXXXXX4994",
        "encryptedAccountno": "zGtoF8nzwth17pwiLsrdsQ==",
        "originalAccountNo": "000760004994"
    },
    {
        "maskedAccountNo": "XXXXXXXX5689",
        "encryptedAccountno": "rl/r918gcqR9fxQ5PwWA/A==",
        "originalAccountNo": "000805015689"
    },
    {
        "maskedAccountNo": "XXXXXXXX1320",
        "encryptedAccountno": "PMCqd48NUoCm/qO5Ck2+ng==",
        "originalAccountNo": "000813001320"
    },
    {
        "maskedAccountNo": "XXXXXXXX4982",
        "encryptedAccountno": "YJLMVfIM8l7da7Hb7G3g1w==",
        "originalAccountNo": "001105024982"
    },
    {
        "maskedAccountNo": "XXXXXXXX0623",
        "encryptedAccountno": "E6i+PxeUrv1zZBIqVlYnnQ==",
        "originalAccountNo": "001801080623"
    },
    {
        "maskedAccountNo": "XXXXXXXX2371",
        "encryptedAccountno": "OJ3pSfPa1cdq/L/hZl5Z2A==",
        "originalAccountNo": "001810042371"
    },
    {
        "maskedAccountNo": "XXXXXXXX5268",
        "encryptedAccountno": "WlthXvuui/BQUeKircVQvw==",
        "originalAccountNo": "001825075268"
    },
    {
        "maskedAccountNo": "XXXXXXXX9637",
        "encryptedAccountno": "Y94uyOwp1wLFvB9892Dg8g==",
        "originalAccountNo": "004214109637"
    },
    {
        "maskedAccountNo": "XXXXXXXX9638",
        "encryptedAccountno": "QuxxxLWwNCeIosmc9v/aqA==",
        "originalAccountNo": "004214109638"
    },
    {
        "maskedAccountNo": "XXXXXXXX0278",
        "encryptedAccountno": "pab//kSfNfRvCcnQM+M4hw==",
        "originalAccountNo": "010310000278"
    },
    {
        "maskedAccountNo": "XXXXXXXX4151",
        "encryptedAccountno": "kHJ28ZD8bowEdxN6XjpoGQ==",
        "originalAccountNo": "032501004151"
    },
    {
        "maskedAccountNo": "XXXXXXXX8102",
        "encryptedAccountno": "GEq9da051Jy55yXqlBqwGw==",
        "originalAccountNo": "044205008102"
    },
    {
        "maskedAccountNo": "XXXXXXXX0275",
        "encryptedAccountno": "2F3ZngaXpl3bbHV5z4L6/A==",
        "originalAccountNo": "105701000275"
    },
    {
        "maskedAccountNo": "XXXXXXXX5140",
        "encryptedAccountno": "lWqBrzaA4KclEPv/pfKMEg==",
        "originalAccountNo": "630010075140"
    }
]

Now i want to fetch all variables one by one and check the 4th and 5th digits from the original account number and set that data into the message. as shown below.

{
  "Accounts": {
    "type": "",
    "accNumber": "{maskedAccountNo}",
    "encAccNumber": "{encryptedAccountno}",
    "status": ""
  },
  {
    "type": "",
    "accNumber": "{maskedAccountNo}",
    "encAccNumber": "{encryptedAccountno}",
    "status": ""
  }
}

Can anyone help me how to do this part?

[#2]

you can use extract variable policy and get all parameters.

[devalvelociter]

Priyadarshi Ajitav Jena I used extract variable and tried to extract the data as shown below:

<JSONPayload>
        <Variable name="maskedAccountNo">
            <JSONPath>$.maskedAccountNo</JSONPath>
        </Variable>
        <Variable name="encryptedAccountno">
            <JSONPath>$.encryptedAccountno</JSONPath>
        </Variable>
        <Variable name="originalAccountNo">
            <JSONPath>$.originalAccountNo</JSONPath>
        </Variable>
</JSONPayload>
<br>

If there is any wrong please help me how to extract these all variables and set into that message as i mentioned above.

[#4 · Accepted solution]

it should look something like $.[0].maskedAccountNo