Skip to Content
0

EXCEL ->PI -> 3rd Party Webservice

Mar 07, 2017 at 06:40 AM

30

avatar image
Former Member

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
Former Member

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