Fetch XML to C# Array

(0) Share

Report

Posted on by Community Member

Hi All,

I have following fetch XML and I want to convert it to C# array or list. Can you help me please?

var fetchXml = $@"
<fetch top='2000'>
<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>";

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

meelamri 13,216 User Group Leader on at

Like (1)

Report
Hi,

please refer to this code snnipet from the doc:

// Retrieve all accounts owned by the user with read access rights to the accounts and // where the last name of the user is not Cannon. string fetch2 = @" "; EntityCollection result = _serviceProxy.RetrieveMultiple(new FetchExpression(fetch2)); foreach (var c in result.Entities) { System.Console.WriteLine(c.Attributes["name"]); }

source: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-fetchxml-construct-query

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mehdi,

I am getting error on _serviceProxy. That _serviceProxy does not found in current context. Could you help me ?

Thanks,

Mayur

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

Like (0)

Report

Hi,

Can you please share your code ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mehdi,

Following is my code:

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));

foreach (var c in result.Entities)

{

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

}

Do we need to define service proxy or any library we have to add?

Was this reply helpful? Yes No
Verified answer

meelamri 13,216 User Group Leader on at

Like (0)

Report

Ok, I understand now. Please refer to this blog: carldesouza.com/.../

You will find all the steps, you need to add SDK assemblies, connect to your CRM to get your serviceProxy and so on.

Good luck !

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Mehdi,

It worked for me.

Many Thanks,

Mayur

Was this reply helpful? Yes No