Service-REST with excel attachments
Hi,
I am trying to implement a solution where we create Service-REST rule, and in the request, we get Excel file. This excel file should then be read and converted into the work object.
How to read the response of REST service which has excel attachments?
I understand that once I have excel, I can use MSOParseExcel. But how will getting it from service request happen?
Cisco
IN
Hi,
If my understanding is correct, Connect-REST is used when Pega needs to access an external service. Pega sends a request to the service, and service sends a response to Pega.
The problem statement in my case that Pega should host the service. Some other application should call the service hosted by Pega and in that request, they should send an excel file as attachment. Now the problem is where and how do I map the incoming attachment?
Cognizant
US
I would be curious to know how the clients will POST the excel file through a REST API.
If you want to build a REST-Service then as a service owner you can decide what type of Request (usually Query string ) and Response (JSON, XML, EXCEL, CSV) best suits for you.
I have not heard of a RESTful API accepting EXCEL as input/Request (I have heard the other way as Response ). There is no OOTB way in Pega REST-service as far as I know.
One of the standard ways would be to go with a REST-Service which accepts an query string (xml could be a large string as request, pega REST service parses it and creates the work object and responds with work object ID and or Status and any other details.
Other options to consider are.
SOAP-Service. It supports soap with attachment.
Check Pega API in Pega 7.1x
https://pdn.pega.com/integration/pega-api-for-the-pega-7-platform
UnitedHealth Group
IN
Any further updates on this post? We have a similar requirement.
Updated: 11 Dec 2015 8:00 EST
Aaseya IT Services Pvt Ltd
SA
Can we receive the attachments through Service Rest. if yes please let me know.
Pega
IN
Did you get any solution for sending attachments in Rest
From your question looks like you need a Connect-REST at Pega end. Through Integration wizard when we run it for REST integration, I get follwoing error when I test the response. This means only XML or JSON response is supported currently.
"The response was not recognized as JSON or XML and cannot be saved."
Another way would be to use Java Script (ajax) to download the excel in server and then use MSOParseExcel to parse the excel file and create work object.