Json input

[manisalai10D]

My doubt is related to apache hop.

"Data":[{"BranchName":"KLANG BRANCH","BranchCode":"MY0100001","Rates":[{"Country":"AUSTRALIA","Rate":"9.9000","Unit":"1","CurrencyCd":"AUD","CurrencyName":"AUSTRALIAN DOLLAR","FlagName":"Australia.png","ModifiedDate":"3/17/2025 2:44:06 PM"},{"Country":"BANGLADESH - BANK ACC.","Rate":"27.6200","Unit":"1","CurrencyCd":"BDT","CurrencyName":"BANGLADESH - BANK ACC.","FlagName":"Bangladesh.png","ModifiedDate":"3/4/2025 3:01:26 PM"},{"Country":"BANGLADESH - CASH PICK UP","Rate":"27.6200","Unit":"1","CurrencyCd":"BDT","CurrencyName":"BANGLADESH - CASH PICK UP","FlagName":"Bangladesh.png","ModifiedDate":"3/4/2025 3:01:26 PM"},{"Country":"BKASH (MOBILE WALLET)","Rate":"27.6200","Unit":"1","CurrencyCd":"BDT","CurrencyName":"BKASH (MOBILE WALLET)","FlagName":"Bkash.png","ModifiedDate":"3/4/2025 3:01:26 PM"},{"Country":"CHINA","Rate":"1.5509","Unit":"1","CurrencyCd":"CNY","CurrencyName":"CHINESE YUAN","FlagName":"China.png","ModifiedDate":"8/10/2023 3:39:53 PM"},{"Country":"HONG KONG","Rate":"1.6700","Unit":"1","CurrencyCd":"HKD","CurrencyName":"HONG KONG DOLLAR","FlagName":"hk.png","ModifiedDate":"10/19/2022 1:34:17 PM"},{"Country":"INDONESIA","Rate":"3403.0200","Unit":"1","CurrencyCd":"IDR","CurrencyName":"INDONESIAN RUPIAH","FlagName":"Indonesia.png","ModifiedDate":"6/11/2024 2:10:18 PM"},{"Country":"INDIA","Rate":"18.5000","Unit":"1","CurrencyCd":"INR","CurrencyName":"INDIAN RUPEES","FlagName":"India.png","ModifiedDate":"10/18/2023 4:13:03 PM"},{"Country":"JAPAN","Rate":"27.2533","Unit":"1","CurrencyCd":"JPY","CurrencyName":"JAPAN YEN","FlagName":"jp.png","ModifiedDate":"3/11/2022 11:40:05 AM"},{"Country":"CAMBODIA","Rate":"0.2080","Unit":"1","CurrencyCd":"USD","CurrencyName":"CAMBODIA (US DOLLAR)","FlagName":"kh.png","ModifiedDate":"6/11/2024 1:37:13 PM"},{"Country":"SOUTH KOREA","Rate":"272.4929","Unit":"1","CurrencyCd":"KRW","CurrencyName":"SOUTH KOREAN WON","FlagName":"kr.png","ModifiedDate":"3/11/2022 11:39:24 AM"},{"Country":"SRI LANKA","Rate":"56.0000","Unit":"1","CurrencyCd":"LKR","CurrencyName":"SRILANKAN RUPEE","FlagName":"Sri Lanka.png","ModifiedDate":"3/17/2025 2:49:46 PM"},{"Country":"MYANMAR","Rate":"479.5000","Unit":"1","CurrencyCd":"MMK","CurrencyName":"MYANMAR KYAT","FlagName":"Myanmar(Burma).png","ModifiedDate":"10/16/2024 12:31:14 PM"},{"Country":"NEPAL","Rate":"30.0000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"NEPALESE RUPEES","FlagName":"Nepal.png","ModifiedDate":"10/25/2024 1:44:08 PM"},{"Country":"CITY EXPRESS (NEPALESE RUPEES)","Rate":"28.5000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"CITY EXPRESS (NEPALESE RUPEES)","FlagName":"CityExpress.png","ModifiedDate":"9/23/2024 10:35:39 AM"},{"Country":"IPAY REMIT (NEPALESE RUPEES)","Rate":"31.4000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"IPAY REMIT (NEPALESE RUPEES)","FlagName":"IPay.png","ModifiedDate":"2/18/2025 6:59:02 PM"},{"Country":"HIMALAYAN (NEPALESE RUPEES)","Rate":"28.5000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"HIMALAYAN (NEPALESE RUPEES)","FlagName":"Himal.png","ModifiedDate":"9/23/2024 10:35:47 AM"},{"Country":"GME REMIT (NEPALESE RUPEES)","Rate":"28.5000","Unit":"1","CurrencyCd":"NPR","CurrencyName":"GME REMIT (NEPALESE RUPEES)","FlagName":"GME.png","ModifiedDate":"9/23/2024 10:35:43 AM"},{"Country":"PHILIPPINES","Rate":"12.4000","Unit":"1","CurrencyCd":"PHP","CurrencyName":"PHILIPPINE PESO","FlagName":"Philippines.png","ModifiedDate":"10/9/2024 10:39:49 AM"},{"Country":"PAKISTAN","Rate":"212.4500","Unit":"1","CurrencyCd":"PKR","CurrencyName":"PAKISTANI RUPEE","FlagName":"Pakistan.png","ModifiedDate":"9/6/2024 6:30:34 PM"},{"Country":"SINGAPORE","Rate":"0.3100","Unit":"1","CurrencyCd":"SGD","CurrencyName":"SINGAPORE DOLLAR","FlagName":"Singapore.png","ModifiedDate":"8/16/2024 11:16:37 AM"},{"Country":"THAILAND","Rate":"7.5500","Unit":"1","CurrencyCd":"THB","CurrencyName":"THAI BAHT","FlagName":"th.png","ModifiedDate":"12/10/2024 12:42:44 PM"},{"Country":"UNITED KINGDOM","Rate":"0.1789","Unit":"1","CurrencyCd":"GBP","CurrencyName":"GREAT BRITAIN POUND","FlagName":"United Kingdom(Great Britain).png","ModifiedDate":"3/10/2022 11:34:24 AM"},{"Country":"UNITED STATES","Rate":"0.2381","Unit":"1","CurrencyCd":"USD","CurrencyName":"US DOLLAR","FlagName":"United States of America (USA).png","ModifiedDate":"6/21/2019 12:52:45 PM"},{"Country":"VIETNAM","Rate":"5385.0000","Unit":"1","CurrencyCd":"VND","CurrencyName":"VIETNAMESE DONG","FlagName":"Viet Nam.png","ModifiedDate":"10/17/2024 12:25:26 PM"}]}

This is my input data receiving from rest client transform, So goal is to iterate the json data based on branch name and branch code. consider branchname and code as parent, inside Rates json there are so many dictinories are there So I need to retrieve the data row by row and insert in the table. for eg: Inside rates json having 20 records means the same length I need to save in the table but branchname and code should be repeat for that 20 record why because of this, the rates array is belong to that particular branchname and code, like this more branch I will receive the same rules I need to follow.

So please provide me the correct transform to achieve this.

[manisalai10D]

I need to achieve this using apache hop

[bamaer]

#5074 (comment)