How do I query the recipientIds of failed messages for a given Campaign?

[JohnnyBravo]

How do I query the recipientIds of failed messages for a given Campaign? I want to be able to query the failures in the workflow and send a separate email with the failed recipientIds in the workflow, if possible. 

thanks

[sumitp11734535 · Accepted solution]

Hi,

make a query status="as per your requirement (sent, failed, pending etc)" with your delivery label name in broadLogRcp out of box schema. 

Thanks,

Sumit

[JohnnyBravo]

Thank you sumitp11734535, this really helped!