Read xml web page

[Former Member]

I am trying to read the Bank of Canada exchange rate from a web site andneed to know what type of adapter to use.

File adapter seems to need to be on the same server or FTP and this is a HTTP.

HTTP adapter seems to need a put and not a get.

http://www.bankofcanada.ca/rss/fx/noon/iexe0101.xml

Any ideas would be appreciated.

[Former Member · Accepted solution]

Reference:

[Former Member]

Hi All,

I did the same requirement using by refering this blog of Michal.

/people/michal.krawczyk2/blog/2010/01/22/pixi-how-to-get-an-xml-file-from-a-web-page-without-own-development

Regards,

Gautam Purohit

[Former Member]

Hi Ron,

I am also working on the similar project , infact the same address (xml) from BOC.

let's share our ideas, check my business card.

[former_member181962]

Hi Ron,

Some websites host webservices.

SOAP receiver adapter is the one to go for , if you are sure that it is indeed a webservice hosted on that site.

Regards,

Ravi

[Former Member]

should this not be a sender adapter since i wan to read the file?

[Former Member]

Ron,

It will not be a sender. It would be a receiver because you are the one who is going to initiate the call. So you need to inititate the call and get the response from the webservice and then proceed further with our flow.

Regards,

---Satish

[Former Member]

this web site does not use HTTP POST, it is only set up for HTTP GETcalls.

To use the reciever adapter I need to use the post method and not the get.

Any other ideas?

[stefan_grube]

Write a Java Proxy or a web service. Inside the Java proxy, you call the URL and read the content.

A simple task for a Java developer.

Regards

Stefan

[Former Member]

thanks , this makes sense.

unfortunatly thhis project go put on the back burner so it will be a while before I can work on this again.

[stefan_grube]

> unfortunatly thhis project go put on the back burner so it will be a while before I can work on this again.

Then wait for PI 7.2. I think the HTTP adapter will be able to use GET. But I have not tested this yet.

[Former Member]

Stefan

>>Then wait for PI 7.2

Is this a typo or SAP is planning to release a newer version of PI 7.1?

Thanks

Aamir

[stefan_grube]

> >>Then wait for PI 7.2

> Is this a typo or SAP is planning to release a newer version of PI 7.1?

Of course SAP plans to release a never version of PI. Do you think, SAP stops development?

[Former Member]

Hi Ron,

Can you please elaborate how did you achieve this requirement? I have the same requirement where I need to read data of RSS xml file of Bank Of Canada and send the exchange rate to SAP system.

Regards,

Gautam Purohit

[Former Member]

this interface got put on the back burner and I have not gotten back to it. I will be going to PI 7.1 before doing this so I don't expect any further issues