Export message processing log from CPI

[VishnAndr]

Dear Community,

Is there any way to export CPI message processing log for failed messages in mass with error details? Not going one by one and check in UI.

What I tried so far is using SAP CPI odata API and I used it to export required entries to MS Excel taking the source as oData Feed. Something like .../api/v1/MessageProcessingLogs?$filter=Status eq 'FAILED' and LogStart gt datetime'2019-03-11T16:00:00'

This gives me a header information of message processing logs. But when I'm trying to expand record column ErrorInformation seems like MS Excel going crazy and reading hundreds of megabytes of data and becomes irresponsive. Actually, it won't probably help at all. Because I'm more after to get .../MessageProcessingLogs(<messageid>)/ErrorInformation/$value which is a stream and contains a real error message from the log.

Have anyone experienced the same and how did you tackle it?

[former_member205889]

Hi,

Can you please share the steps on how to fetch the logs through OData call?

Thanks,

Poorna

[nj_007]

Hi Andrie,

Could you please share the process of fetching SAP logs for a time frame.

Regards,

Nehul

[VishnAndr · Accepted solution]

Solved using proper Power Query in MS Excel. Just needed to gain more knowledge in M-language 🙂

[JaySchwendemann · Accepted solution]

Would be swell if you'd share your wisdom 😉

[former_member198979]

We should be able to build an iflow with combination to extract these messages ids in the main flow then pass: MessageGuid alone by splitting this response to a subprocess to extract error information of the same. Finally, gather the second response only the fetching error tag and create a single CSV file at the end with less fields.

[VishnAndr]

Good approach, thank you! But I would prefer something more user friendly...