Skip to Content
avatar image
Former Member

Extract XML from URL

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-page-without-own-development

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 11, 2014 at 05:57 AM

    Hi Pavi,

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


    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 11, 2014 at 12:51 PM

    Under OS Command can you try with

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

    Add comment
    10|10000 characters needed characters exceeded