I have a dynamic URL(website) where the currency rates are updated on a daily basis .
where *** - is the dynamic value which will be passed from SAP ECC
then follows the /2017/11/06 - Current date
- I dont want to use HTTP_GET to get the dollar value and update it in SAP table .
- I want to use PI where i will be passing this link http://cbrates.rbc.ru/tsv/***/2017/11/06.tsv in a dynamic way and fetch values from website and update in SAP tables .
Can anyone suggest an idea how to achieve it via PI ?