Extract XML from URL

[Former Member]

Hi Experts,

We are using PI7.0.

We got a requirement to extract XML from a exchange rate URL on daily basis and send it to ECC from PI.

I followed the below link for the same.

http://scn.sap.com/people/michal.krawczyk2/blog/2010/01/22/pixi-how-to-get-an-xml-file-from-a-web-pa...

Our PI system is Linux system.

The Shell script is as follows

wget -O <filename> <URL>

The script is placed in the al11 directories in PI. We are doing a trigger from SAP and then placing the dummy file in a path and have configured the file adapter to execute the OS command after message processing.

Below is the path given in Run OS command after message processing.

/usr/sap/cxfer/script/URLExtract.sh

When we are trying to execute the Script from linux physical system, the XML is getting generated. But while running, the PI interface, the XML is not generated. Please help on the same.

Thanks,

Pavithra

[former_member184720]

Under OS Command can you try with

sh /usr/sap/cxfer/script/URLExtract.sh

[Former Member]

Thanks for the reply Hareesh. But this is still not working.

[iaki_vila]

Hi Pavi,

Check the shell script rights, you need to notice that the user "<sid>adm" can executed that file.

Regards.

[Former Member]

Thanks for the reply Inaki. The user has the necessary rights