Customer experience | Sales, Customer Insights,...

invalid fetch xml error

(0) Share

Report

Posted on by Mona Chavan

255

fetchxmlAccholding = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false' {0}>
<entity name='new_productholding'>
<attribute name='new_productholdingid' />
<attribute name='new_name' />
<attribute name='createdon' />
<order attribute='new_name' descending='false' />
<filter type='and'>
<condition attribute='new_clientid' operator='eq' value=""" + ClientId + @""" />
<condition attribute='new_clientcaseid' operator='eq' value=""" + ClientCaseId + @""" />
</filter>
<link-entity name='new_casestage' from='new_casestageid' to='new_remediationstatusid' alias='ad'/>
<attribute name='new_casestagename' />
</link-entity>

</entity>
</fetch>";

can any body tell me why this gfetch is invalid i am getting error in plugin

All responses (3)

Answers (0)

Suggested answer

ajyendra 1,738 on at

Like (0)

Report

RE: invalid fetch xml error

Hi,

Try this,

string fetchxmlAccholding = string.Format(@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='new_productholding'>
<attribute name='new_productholdingid' />
<attribute name='new_name' />
<attribute name='createdon' />
<order attribute='new_name' descending='false' />
<filter type='and'>
<condition attribute='new_clientid' operator='eq' value='{0}' />
<condition attribute='new_clientcaseid' operator='eq' value='{1}' />
</filter>
<link-entity name='new_casestage' from='new_casestageid' to='new_remediationstatusid' alias='ad'/>
<attribute name='new_casestagename' />
</link-entity>

</entity>
</fetch>",ClientId ,ClientCaseId );

{0} in the First Line of your Fetch xml is you use it or put that mistaken if you have some value on that so please use below code

string fetchxmlAccholding = string.Format(@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false' {0}>
<entity name='new_productholding'>
<attribute name='new_productholdingid' />
<attribute name='new_name' />
<attribute name='createdon' />
<order attribute='new_name' descending='false' />
<filter type='and'>
<condition attribute='new_clientid' operator='eq' value='{1}' />
<condition attribute='new_clientcaseid' operator='eq' value='{2}' />
</filter>
<link-entity name='new_casestage' from='new_casestageid' to='new_remediationstatusid' alias='ad'/>
<attribute name='new_casestagename' />
</link-entity>

</entity>
</fetch>",HERE PUT THAT VARIABLE,ClientId ,ClientCaseId );
erhan.keskin 2,253 on at

Like (0)

Report

RE: invalid fetch xml error

Hi,

You have a parameter in the fetch tag as "{0}", and you don't populate anything into that parameter. It may cause the issue here.

Regards,
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

RE: invalid fetch xml error

Please have a look below thread I have mentioned sample fetchXMLwith parameter-

community.dynamics.com/.../882775

Community site session details

invalid fetch xml error

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Kudos to the April Top 10 Community Stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

invalid fetch xml error

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Kudos to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates