To illustrate what I am looking forward is lets consider one sample request / response from the log :
REQUEST:
05 Jan 2018 16:45:19,951 - INFO http-bio-8080-exec-409 - Inbound Message
ID: 1682148
Address: http://internalservices.abc.com/ERPPeoplesoftService/service/PsciServiceImplPort/erpService?bridgeEndpoint=true&throwExceptionOnFailure=false
Encoding: ISO-8859-1
Http-Method: POST
Content-Type: text/xml
Headers: {Accept=[/], breadcrumbid=[ID-XYZ-INT-ESB01-407etr-com-19853-1510587197074-50-2354125], cache-control=[no-cache], connection=[keep-alive], Content-Length=[503], content-type=[text/xml], host=[internalservices.407etr.com], pragma=[no-cache], user-agent=[Apache CXF 2.5.0]}
Payload:
<psci:getPSAccountInfoDefault xmlns:ns2="http://erp.ABC.com" xmlns:psci="http://psci.etr407.com">
<defaultAcctNo>123456789</defaultAcctNo>
<doLinking>true</doLinking>
<isUdlAccount>false</isUdlAccount>
<source>WEB</source>
<dateFrom>12/17/2017</dateFrom>
<dateTo>01/05/2018</dateTo>
</psci:getPSAccountInfoDefault>
RESPONSE:
Jan 5 16:48:25 MyAccount ERROR: com.ebpsource.ABCConsumer.Customer0: - E0 00300 Customer0 - ERROR: ETRGetPSAccountInfoDefault returned 0 records for account=123456789 loginId=JOHN@ROGERS.COM
Based on the common key word in the response and request that is getPSAccountInfoDefault I would like to fetch the result in the output format as below:
Name of WS call, Acct Number, Email ID, REQUEST DATE-TIME, RESPONSE DATE-TIME
getPSAccountInfoDefault,123456789 , JOHN@ROGERS.COM, 05 Jan 2018 16:45:19,Jan 5 16:48:25
... View more