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 😉