Skip to Content
0

EXCEL ->PI -> 3rd Party Webservice

Mar 07, 2017 at 06:40 AM

28

avatar image

Hello,

We have a scenario in which a macro will run in Excel , and it needs to get data from a 3rd party application (webservice for which is available). This has to be done through PI.

This is probably a file to SOAP scenario, but do I need to create a webservice in PI so Excel can call it?

Any guidance would be useful

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

1 Answer

Iñaki Vila Mar 07, 2017 at 07:37 AM
0

Hi Alther,

No Sender SOAP is necessary, you can create a CSV or plan text file in a folder shared with PI (via NFS or FTP or SFTP). Later in PI you take the file as attachment (

https://help.sap.com/saphelp_nw73ehp1/helpdata/en/44/692ab8a4b633eae10000000a1553f6/content.htm

Regards.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for the response.

This can be done, but this is not what we are trying. Excel file will reside at a location, and will request for data (based on the 3rd party webservice we have ). This has to go through PI.

0