Remove contact from all marketing lists they are a member of

[cjanow]

I'm building on top of a workflow that runs when an email bounces within the D365 Marketing App.  After setting the do not bulk email field, I want to remove the contact from all marketing lists they are a member of.   I'm having trouble building the query to retrieve only the lists a particular contact is a member of.  I would rather not retrieve all marketing lists, go through each list to see if the contact is a member, and if they are remove them due to runtime reasons.  

Can anyone provide some insight?

[edgonzales · Accepted solution]

@cjanow 

It's been a while since I've worked in this, but I think there is an entity called "Related Records" or something close, which would have the two entity types (contact : marketing lists in your example) and then a GUID for the contact, and a corresponding GUID for the appropriate list.  

So, if your contact was on four lists, I would expect to find four rows once I narrowed the related entities to contact and lists.

If I can find an instance to log into, I can double check and get more specific, but I thought that might be enough to get you started.

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.