Service REST - retrieve request & response stored in Pega database
I have Service REST endpoints where I want to see all the request & response received by the endpoint and search for certain attributes in the JSON while debugging the production issue.
Also where in Pega these REST request/response is stored? I read its stored in a database inside Pega, where is it located and will I be able to query the database?
I could see the request & response under the "Invocation History" in Service Package but I would like to store the request & response in some commonplace or a table within Pega or even an external database so it will be easy for me to search for certain fields from the request/response JSON, is there a way to do it?
Will I be able to query the Pega table wherever this REST request/response is stored based on certain JSON attributes in the request/response?
Will I be able to prepare a report or push/pull the request/response with some date/time range?
Updated: 27 May 2022 4:53 EDT
Deutsche Bank Operations International (DBOI)
IN
@KannanM3 - Yes, you should create a table to add the request response from REST. Below article might help you.
https://collaborate.pega.com/question/saving-incoming-request-service-rest-json-format-pega-72
Idexx Laboratories
US
Thanks, the link shows how to get the json but in my case I’m already mapping it to a json and can see the incoming/outgoing json in the invocation history for the endpoint.
I need both these information either stored in a pega table or push it to some external database or store it as a file in Amazon or google storage so I can use it for debugging when there’s a production issue.
pls let me know if this is possible to do ?
also where in pega database are these requests and response are stored that’s shown under invocation history for the service rest?
Deutsche Bank Operations International (DBOI)
IN
@KannanM3 - Please check table pegadata.pr_data_svcinvhist.
You request response should be in blob pzPvStream column. To retrieve them you can use pr_read_from_stream function.
Let us know if that helps.