Customer experience | Sales, Customer Insights,...

Adding Opportunity Ids in array using C#

(0) Share

Report

Posted on by Community Member

Hi Team,

We want to fetch record id of opportunity and then store it in string array using C#. Could you help us please?

Many Thanks,

Mayur

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

meelamri 13,216 User Group Leader on at

Like (0)

Report

Hi,

I add two lines to your code. (found in your last post)

var fetchData = new

{

willis_probability = "7",

willis_inceptiondate = "01-25-2020"

};

var fetchXml = $@"

<fetch top='50'>

<entity name='opportunity'>

<attribute name='willis_opportunityid' />

<filter type='and'>

<condition attribute='willis_probability' operator='eq' value='{fetchData.willis_probability/*7*/}'/>

<condition attribute='willis_inceptiondate' operator='on-or-before' value='{fetchData.willis_inceptiondate/*01-25-2020*/}'/>

</filter>

</entity>

</fetch>";

EntityCollection result = _serviceProxy.RetrieveMultiple(new FetchExpression(fetchXml));

List<Guid> oppIds = new List <Guid>();

foreach (var c in result.Entities)

{

System.Console.WriteLine(c.Attributes["name"]);

oppIds.add(c.Id);

}

Was this reply helpful? Yes No
Suggested answer

Vijay Tailor 431 on at

Like (0)

Report

You can also use QueryExpression / Odataquery Endpoint.

QueryExpression -

// Instantiate QueryExpression QEopportunity
var QEopportunity = new QueryExpression("opportunity");
QEopportunity.TopCount = 50;

// Add columns to QEopportunity.ColumnSet
QEopportunity.ColumnSet.AddColumns("opportunityid", "name");

Odata Query endpoint - XXXX.crm8.dynamics.com/.../opportunities

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mehdi,

Actually we have to do it from web API. We have to fetch data from API and then wwe have to add in array. Can we do it from API?

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (0)

Report

Hi,

can you please give more details ?

Was this reply helpful? Yes No
Suggested answer

Johao Larios 1,795 on at

Like (0)

Report

Hello there,

Yes, you could achieve this using the webapi: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/retrieve-and-execute-predefined-queries#use-custom-fetchxml

So, you could create a view using the UI, download the fetch for that view then encode that fetch and use it with above webapi query.

Please let us know if you have any more questions or please mark this as answered if we have answered your question.

regards,

Was this reply helpful? Yes No