Hi Angelika
Ideally you would have a button on a dashboard in onestream that you just press to retrieve the rates from the ECB. Or even, a task scheduler that retrieves overnight the rates for you.
It is possible to achieve that in OneStream by using the api from the ECB.
You would need to write a business rule connector to connect to the ECB api and update the FX rates. But first, investigate to which api from ECB you will need to connect. Which api as the correct information? what you are looking for is a kind of URL : https://data.ecb.europa.eu/help/data-examples
I have done connection to ECB in the past.
Have a good day.
Nic
Hi Nicolas,
NicolasArgente wrote:Hi Angelika
Ideally you would have a button on a dashboard in onestream that you just press to retrieve the rates from the ECB. Or even, a task scheduler that retrieves overnight the rates for you.
It is possible to achieve that in OneStream by using the api from the ECB.
You would need to write a business rule connector to connect to the ECB api and update the FX rates. But first, investigate to which api from ECB you will need to connect. Which api as the correct information? what you are looking for is a kind of URL : https://data.ecb.europa.eu/help/data-examples
I have done connection to ECB in the past.
Have a good day.
Nic
Hi @Nicolas,thank you very much, great help. Do you load data via connector from ECB 1 time in a month - different currecy convert to USD? Are you calculating in OS average monthly rate (daily rates in month) and YTD rate (monthly average Rate)?
Thank you
Angelika
