Extract data from the message payload

[adityavempati]

Hi there,

Could you please guide me on how to achieve the below requirement.

Existing Interface (Sync-Sync (using ICo)): System A <--> SAP PI <--> System B

Customer wants to know the end time stamp of all the messages in SAP PI i.e he wants to know at what time the message is out of SAP PI along with few values in the corresponding payload.

Interface Name, Notification Number (from the payload), End Time Stamp

I am able to fetch the end time stamp but not the data in the payload.

Please suggest.

Regards,

Aditya

[vadimklimov · Accepted solution]

Hello Aditya,

Assuming you know message ID, you can retrieve its payload using the web service AdapterMessageMonitoringVi exposed by Adapter Engine. More information on this web service and its usage can be found in and . Following this approach, you shall:

1. call operation getMessagesByIDs to retrieve message key using the known message ID;
2. call operation getMessageBytesJavaLangStringBoolean / getMessageBytesJavaLangStringIntBoolean to retrieve message details (including payload) using the determined message key.

After message is retrieved, you will need to parse its content in order to extract payload from it. Following forum thread discusses this:  .

Regards,

Vadim

[adityavempati · Accepted solution]

Thanks a ton Vadim. We know the message ID. We will try the steps you mentioned and revert.

Thanks again.

Regards,

Aditya