ariba integration with webservice

[Former Member]

Hello All

i have requirement for ariba integration using webservice  but the soap response is with csv zipped file

how can i handle that in sap pi ?

please confirm if my below design is ok with 2 interfaces or any other better design .

Scenario 1 : proxy to soap (aync to sync)- request response bean and capture the response and write zipped file  to a local PI folder

Scenario 2 :  (file to proxy) then pick it up  file adapter channel with payload zip module (to unzip) and FCC to convert CSV file to XML and do mapping to proxy

Thanks

Sandeep

[engswee · Accepted solution]

Hi Sandeep

Yes, your 2 step approach sounds fine. Please refer to my answer in the following thread on a similar design for a requirement similar to yours.

The OP of the thread also wrote a blog after that on handling the zipped base64 CSV data. You can refer to it to see if you can reuse the solution for your case.

Rgds

Eng Swee

[Former Member · Accepted solution]

Thanks eng swee i developed java mapping for both unzipping and xml conversion

regards

sandeep

[former_member186851]

Hello Sandeep,

Try using Keep attachement option in Soap channel.Below discussion contains all the useful links.

[Former Member]

hello raghuram

i am getting file in the soap body as in Base64  data format

[former_member186851]

Sandeep refer the last comment ,I guess its for Base64 data format.