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?
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
93 | |
45 | |
19 | |
19 | |
15 |
User | Count |
---|---|
137 | |
54 | |
42 | |
42 | |
30 |