You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by "Mani120998 (via GitHub)" <gi...@apache.org> on 2025/03/26 06:30:57 UTC
[D] Json input (hop)
GitHub user Mani120998 created a discussion: Json input
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.6
700","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)","FlagNa
me":"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","Curre
ncyName":"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.
GitHub link: https://github.com/apache/hop/discussions/5073
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Json input (hop)
Posted by "Mani120998 (via GitHub)" <gi...@apache.org>.
GitHub user Mani120998 added a comment to the discussion: Json input
I need to achieve this using apache hop
GitHub link: https://github.com/apache/hop/discussions/5073#discussioncomment-12623989
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] Json input (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
GitHub user bamaer added a comment to the discussion: Json input
https://github.com/apache/hop/issues/5074#issuecomment-2753451913
GitHub link: https://github.com/apache/hop/discussions/5073#discussioncomment-12624477
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org