Problem sending excel file using Sharepoint Online
As part of integrating Pega Application with Sharepoint Online, files of type PDF, MS Excel, MS Word, MS Powerpoint, jpg etc were to be sent to Sharepoint Online. When the files are opened from Sharepoint, they were corrupt.
Steps to Reproduce
- Create a flow
- Attach a file using Out-of-the-box attachment feature
- Get the stream by opening the attachment object and converting it into byte array
- Send the resultant byte array to Sharepoint Online using a REST connector
This issue was determined to be a product enhancement request.
A new feature was added to REST Connector to allow binary data to be sent from Pega Application unlike string / text which is being sent as of now. This feature needs to be selected to sent the data in binary format to external systems.
Above feature is added through HFix-34049, which is a backport from Pega 7.3.