Skip to Content
0

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

Mar 06, 2017 at 09:08 AM

362

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Harshal Vakil
Mar 06, 2017 at 12:15 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks, Harshal

I checked the web service in my service explorer. Where do I have to input the URL into ManageExchangeRateIn for it to work?

0

Hi,

Basically, you will have to

1) Set up communication system

2) Set up communication arrangement using the communication system and assign the scenario (ManageExchangeRateIn)

there could be option to it via cloud application studio as described in the link. (I am not familiar with this process, but the link could act as reference for you.)

https://archive.sap.com/discussions/thread/3589616

Regards,

Harshal

0
Aleksei BELOUSOV Mar 08, 2017 at 08:21 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 09, 2017 at 10:25 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Aleksei BELOUSOV Mar 11, 2017 at 08:10 PM
0

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

.

Share
10 |10000 characters needed characters left characters exceeded