chackbusch we have created a flow based on CDS view I_MKT_CampaignSuccessCube and a CPI iflow
We created an external API based on this view this view is then read on CPI side every morning to check the latest hard bounces/ soft bounces in the last 24 hours
This report is then send to interested support colleagues via email
Interesting. I checked with a colleague and we see 2 ideas at the moment, which would need to be checked further:
On both options, in the open channel action, you select an export definition with the fields that you need for the contacts, including the custom field that would contain the email address of the employee responsible.
In the CPI, you can process the records and trigger to send an email to employee responsible. See option 1 or 2 of this blog https://blogs.sap.com/2018/01/17/how-to-send-a-mail-from-sap-cloud-platform-integration/.
For more information on open channel, see our online documentation Open Channel Integration - SAP Help Portal.
I hope this helps. Maybe other experts have also other ideas.