Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unzip Base64 field from SOAP attachment with multiple files

Dear experts,

Scenario: RFC <----> SOAP

In SOAP response I am getting one of the fields as base64 encoded attached zip file which internally will have 4 .CSV files (always naming standard is same).

Now my requirement is how I should deal it with in PI mapping so that I can map relevant fields from CSV to my RFC.

Checked SCN for solution but not find solution for multiple files in zip …

Thanks in advance

Regards

Siri

Former Member
replied

Hi Siri,

1) I am getting SOAP response, in this Base64 field with a Zip file as attchment(Excel with multiple sheets to be read by PI)

2) I need to decode this field and Unzip

Ask them to just return the attachment.

3) Read Excel files fields across multiple sheets and map it back to RFC receiver structure

There are lots of blogs in SDN PI space about reading an Excel file. Here's a very good blog

Excel Files - How to handle them in SAP XI/PI (The Alternatives)

Regards,

Mark

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question