XMLu00B4s http page on the Internet

[Former Member]

HI all

I have to build an scenario quite challenging for me. Look at this link: http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml. This XML is a http page on the Internet, and I´m supposed to get the data from it in order to map it to an idoc.

The problem is I don´t know how to recover the data from the http page on internet.

ANy idea?

Regards

Noelia

[MichalKrawczyk · Accepted solution]

Hi Noelia,

no need for any web service

you can get the data from java (via java proxy)

and you will have it inside your XI

URL url = null;

URLConnection conn = null;

BufferedReader innn = null;

//url = new URL("http://address.com/file.xml");

url = new URL(inin);

conn = url.openConnection();

innn = new BufferedReader(new InputStreamReader(conn.getInputStream()));

this is all you need to get that data from a WWW page:)

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

HI michal

Many thanks for your help.

Can you give me more info, i never work with java proxys.

Many thanks

Regards

Noelia

[MichalKrawczyk · Accepted solution]

Hi,

you jut create a message interface and you will get a java code from it

inside you can put the code which will get the xml

(sync scenario) and return to XI

then you deploy the java code on java WAS

there are many java proxies tutorials just check them out it's quite easy

Regards,

michal

[Former Member]

Hi Noelia

Did you manage to get the data from the internet site?

Thanks

Clinton

[Former Member]

Hi Noelia,

you cant directly get the data from internet.......you will need a web-service which will send you the data over internet........then when you will invoke the webservice you will get the data from internet......then you need a SOAP adapter to communicate with that webservice in XI........

Thanks,

Rajeev Gupta

[Former Member]

thanks for your help!

I can´t ask for a web service because it is a public web site.

any other work around.

Many thanks

Noelia

[MichalKrawczyk]

<b>no need for any WS</b> just check out my response:)

Regards,

michal

[Former Member]

Hi Neolia,

along with michal's reply, another workaround can be creation of a J2EE adpter module.....deploying it in file adapter........using a dummy file as source file to trigger file adapter.....then via your module getting source data from internet....

Michal, how will that java proxy get triggered to execute the scenario.....please tell this thing......

Thanks,

Rajeev Gupta

[Former Member]

hello

i forgot to say that i´m working with PI 7.0

Thanks for your help.

Regards

Noelia

[MichalKrawczyk]

Hi,

you can schedule it - did you check the xml ?

it contains Reference rates so can be check once a day probably

so you can schedule it with anything (abap report etc)

Regards,

michal