Skip to Content

How to get exchange rates from European Central Bank into ByD.

Hello All

The problem is how to get exchange rates from https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml into SAP Business ByDesign daily. It can be via some development in Cloud Applications Studio. Is there any solution?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 06, 2017 at 12:15 PM

    Hi Aleksei,

    Within Business ByDesign system, We have provided the web service : ManageExchangeRateIn to import the exchange rate from the external source.

    Go to Application and user management

    Service explorer view

    Search for the service interface : ManageExchangeRateIn

    Select the row and click on Link for the documentation.

    Can you please check this. Let me know if you need further details.'

    Regards,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 08, 2017 at 08:21 PM

    Hello Harshal,

    We are really stuck on this task. What I found out :

    Template 'Web service' only gives possibility to read or create entries of standard BO 'ExchangeRate' in ByD, that is, gives an access (R/W) to the BO (actually a simple table) from external systems (in this case BO 'ExchangeRate' looks as a Web Service on the internet and the external system itself has to initiate read / create operations.

    Our task is such that ByD (rather a scheduled process in ByD) itself must ask the external service for the data. To get data from external source (in our case https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml), we should use template 'External Web Service Integration' together with 'Communication Scenario'.

    (app) SoapUI can easily work with the eurofxref as with a Web Service - SoapUI sends empty (or whatever) request and gets the xml-content as a response.

    I would like ByD to work in the same manner. It would suit me if I could get all the content as a string into a simple custom BO having the only element (string type) for this content. But I suspect ByD will try to parse the content according to some scheme (according to wsdl? custom BO structure?). Unfortunately I have not found any proper wsdl-file for this xml-content. And I do not know what structure of my custom BO should be to receive and arrange this content properly.

    Now I got an error 'SoapFaultCode:2 Wrong SOAP Version' during Test Service Operations of the external web service

    Are there any ideas?

    Thank you.

    Best wishes,

    Aleksei

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 10:25 AM

    Dear Aleksei,

    we have already implemented the Exchange Rates Sync between SAP Business ByDesign and Open Exchange Rates. What works quite well, is the integration between openexchangerates.com and SAP Business ByDesign. What we did not try yet, is the integration with ecb.europa.eu Anyway, we are happy to share our experience with you.

    Feel free to send me a PM in case.

    Kind regards Martin

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 11, 2017 at 08:10 PM

    Hello Martin,

    Thank you for your info.

    openexchangerates.com looks interesting, not free of charge, though (as far as I understood).

    Many thanks, anyway.

    Best wishes,

    Aleksei

    .

    Add comment
    10|10000 characters needed characters exceeded