Fetch xml in javascript

(0) Share

Report

Posted on by Community Member

Hi guyzz..

I am a beginner in Crm . I have two Entites player and domestic ....I just want to retrieve record from domestic to player.. I just want to do this with Fetch Xml.. or query expression.. Can any one help me out....

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Rajkumar Rajaraman on at

Like (0)

Report

Is this what you are looking for?:

lakshmanindian.wordpress.com/.../retrieve-data-using-fetchxml-with-multiple-link-entities-in-crm-2011

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Mathuraman,

Use OData query in JavaScript instead of fetch-xml query if possible. Because, fetch-xml requires parsing.

You can refer the following links -

- community.dynamics.com/.../146472

- msdn.microsoft.com/.../gg334279.aspx

- msdn.microsoft.com/.../gg334427.aspx

- missdynamicscrm.blogspot.in/.../tips-and-trick-odata-crm-2011-2013.html

Was this reply helpful? Yes No
Verified answer

Mahendar Pal 45,095 on at

Like (0)

Report

Hi,

If you are looking for the FetchXML you can try : https://fxb.codeplex.com/ it will help you to get fetchXML and then you can simply use it with SOAP request. Check below post it will help you to implement your requirement:

arunpotti.wordpress.com/.../retrieve-records-using-fetch-xml-java-script-in-crm-201113

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hii... I have tried this code.. but I am unable to get the values it is giving error as undefined.

function contactOnload()

{

debugger;

var contactFetchXML="<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>"+

" <entity name='ccs_playerinternational'>"+

" <attribute name='ccs_playerinternationalid' />"+

" <attribute name='ccs_name' />"+

" <attribute name='createdon' />"+

" <order attribute='ccs_name' descending='false' />"+

" <filter type='and'>"+

" <condition attribute='ccs_name' operator='eq' value='Dravid' />"+

" </filter>"+

" </entity>"+

"</fetch>";

var contactRecords = XrmServiceToolkit.Soap.Fetch(contactFetchXML);

alert("sfv");

if (contactRecords.length > 0) {

alert(contactRecords[0].attributes.ccs_noofmatches.value);

if(contactRecords[0].attributes.ccs_fifties.value!= undefined)

alert(contactRecords[0].attributes.ccs_name.value);

}

}

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

Muthuraman,

You can try using advanced find to generate the fetch xml for learning

Just go to adv find, query as per your want then click result, then download the fetch xml.

nycrmdev.blogspot.sg/.../using-advanced-find-fetchxml-capability.html

Thanks

Was this reply helpful? Yes No
suresh maurya 630 on at

Like (0)

Report

For testing of FetchXML, you can test here online http://msxrmtools.com

Was this reply helpful? Yes No
Irakliy 15 on at

Like (0)

Report

Hello!

There is one more way to retrive records you want by fetch.

You can use MS CRM js library:

retrieveMultiple: function (fetchXML, onSuccess) {

Xrm.Internal.messages.retrieveMultiple(fetchXML).then(function (response) {

entityCollection = response.get_entityCollection().get_entities();

onSuccess(entityCollection);

}, Mscrm.InternalUtilities.ClientApiUtility.actionFailedCallback);

}

I'm using this, because it's really easy to use, and retrived records can be easy access for values:

$(entityCollection).each(function (i, col) {

var table = $("<table>").attr("id", col.get_key());-id record

col.getValue("fieldname") - attributeValue

....

I know this unsupport, BUT i really don't like REST requests, or send fetch via GET request.

Was this reply helpful? Yes No