Unzip Base64 field from SOAP attachment with multiple files
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
Mark Dihiansan replied
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