Microsoft Dynamics 365 | Integration, Dataverse...

Trying to get a email list out of CRM using the API

(0) Share

Report

Posted on by Noob_jorjasj

Hello,

I am new the hole word of CRM and am trying to pull a marketing list out of CRM using the API. I am able to pull up all the properties for the list but not data. What I am looking to do is now that I have identified the list I want to be able to pull the data. Any help or direction would be very appreciated. I am currently using postman to test the API.

"description": "Members who have participated in chapter events",

"createdon": "2019-09-25T19:12:25Z",

"statecode": 0,

"listname": "CH3304 Roster",

"listid": "56dccf67-c8df-e911-a896-000d3a30c619",

I have the same question (0)

All responses (8)

Answers (0)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Is it static or dynamic marketing list because extraction way will be different.

Was this reply helpful? Yes No
Noob_jorjasj 5 on at

Like (0)

Report

It is a static list.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Ok. In this case you can either use expand on list retrieve - docs.microsoft.com/.../retrieve-related-entities-query or build fetchXml that will give your list members - docs.microsoft.com/.../retrieve-and-execute-predefined-queries

Also you can use CrmRestBuilder or XrmToolbox plus FetchXmlBuilber to build your queries.

Was this reply helpful? Yes No
Noob_jorjasj 5 on at

Like (0)

Report

This is where I am lost and not sure what avenue to go down. I want to create a solution in c# that when a user clicks on a link lets say "3-year list" it will pull from the API that list of contacts and allow them to download it.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

What exactly confuses you?

Was this reply helpful? Yes No
Noob_jorjasj 5 on at

Like (0)

Report

Within the solution would I use one of the builders listed above to trasform my XML into the formated querie?

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

I'm not sure what you mean with formatted query. Can you please explain that?

Was this reply helpful? Yes No
Noob_jorjasj 5 on at

Like (0)

Report

I'm still lost, when a user gets on a webpage I want to have a button that when they click it they are able to retrieve a list of contacts from that static list in CRM. I am able to get the list using XRMtoolbox but I want the user to be able to download the list from a webpage.

Was this reply helpful? Yes No