Fetching irregular data from CRM Dynamics

Foefgoora

New Member
I've created a fetch XML that gives me all the contacts in a marketing list. I also would like to get the name of the list baked into the output. I've found two ways to achieve that, none of which is satisfactory to the pedantic me.[*]Go to the DB and fetch the name as a separate request.[*]Have an extra column containing the name of the marketing list for each contact.I'll be getting multiple (maybe even all) marketing lists from CRM so the second version seems most suitable as I'll make one call and get it all into a data structure that I'll play with (DataSet and such are fun). The problem is there that we're getting a lot of redundancy. How can I resolve that?
 
Back
Top