Skip to Content
0

Webservice call from PI for exchange rate

Mar 12 at 09:44 AM

61

avatar image
Former Member

I have a requirements to get the exchange rate from ECB using a web service and update the exchange rate in ECC as .xml file

The ECC will be configured as receiver and ECB will be configured as sender. In the sender communication channel, the SOAP adapter will be used and in the receiver channel side, the SOAP (XI 3.0) will be used.

My query is from PI, how to trigger the web service to get the exchange rate from ECB site. if its not feasible, can you please provide the feasible solution.

Many Thanks

MP

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

3 Answers

Mark Dihiansan Mar 13 at 03:53 AM
1

Hi Melchior,

The SOAP Axis adapter supports polling and you can use that as your sender adapter.

https://blogs.sap.com/2012/01/05/michals-pi-tips-exchange-rates-from-an-xml-file-on-a-web-page-rest-axis/

Regards,

Mark

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Is SOAP Axis adapter available in 7.5

0

Hi Melchior,

Yes, it should be. It has been existing way before 7.5 :)'

Regards,

Mark

0

Agree with Mark. But as far as I remember, AXIS framework should be deployed to PI sever additionally.

Regards, Evgeniy.

1
Vivek Jain Mar 12 at 10:06 AM
0

Hi MP,

For a Sender Call , you need to define a Web Servide in PI after creating all your ESR and ID Objects. Please refer below link:

http://www.saptechnical.com/Tutorials/XI/WebService2RFC/page2.htm

Also , there is an another way to achieve your requirement. You can ask ECB to place the Exchange File at their SFTP location. PI can easily pick the file from this location and place it at AL11 Location in ECC. Ofcourse , Proper Encyption/Decyption should be involved as it is very sensitive data.

Regards,

Vivek Jain

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Mar 12 at 10:28 AM
0

Melchior!

I would implement the scenario using sender file channel and SOAP lookup in message mapping. Polling interval and "Test" processing mode could be used in sender File channel to perform repeating polling with given interval and SOAP lookup could be used in message mapping to query ECB, get response, build result message for ECC and send it to receiver system using SOAP receiver channel.

Regards, Evgeniy.

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Evgeniy

What will be the input to the web service from SOAP Lookup. We need the .XML file from ECB on monthly basis usually EOM. do we get the .xml file as response for the request from SOAP Lookup or exchange rate based on the from and to currency.

0

Hi Melchior!

What way ECB's web service delivers info about exchange rates? Usually, one queries the service with some request message containing the set of filter parameters, such as currency id, date etc. and web service responses with rates info.

Regards, Evgeniy.

0
Former Member

Thanks for your reply.

I need few more clarifications.

Please find below the ECB exchange rate xml file.

https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml?c3ca1b315850147611ca8299dadf4972

Sample content taken from the xml file.
--------------------------------------
<Cube>
<Cube time="2018-03-12">
<Cube currency="USD" rate="1.2302"/>
<Cube currency="JPY" rate="131.04"/>
<Cube currency="BGN" rate="1.9558"/>
<Cube currency="CZK" rate="25.448"/>
<Cube currency="DKK" rate="7.4496"/>
</Cube>
</Cube>

Using a request from PI via SOAP Lookup. Can we get all currency rates using date as the filter parameter.

In ECC side, I need to place the file in the application server as .xml with some changes in the date and exchange rate.

Many Thanks

MP

0

In your case you should follow Mark's suggestion and use SOAP Axis for polling XML file from HTTP resource.

Regards, Evgeniy.

0
Former Member

Thanks for your help Evgeniy.

0