CRM 2011 Javascript Fetch XML synchronous or asynchronous call

Using helper function to execute FetchXML request is great.

The code below is retrieved from this blog, and all I had to do is to add extra logic when parsing the XML result because I want to grab the attributes from the related entity as well.

Modified FetchUtil.js:



To use it you just need to do it like this (synchronous)


If it's asynchronous the last bit will be:


The parsed result object can be queried like this:


Hope this helps,
Andreas

Comments

  1. JavaScript Countdown TimerOctober 24, 2011 at 12:44 PM

    Hi...

    Thanks a lot for share your knowledge with us. Okay, while this method does enable you to execute a FetchXML request in JavaScript against the 2011 SOAP endpoint, it doesn't return XML in the same format as the 4.0 web service did.

    Keep sharing.

    ReplyDelete
  2. AnonymousDecember 12, 2011 at 11:59 PM

    hey it works on me but when i try to save the form it gives an error message:

    “An Error has occurred. Try this action again. If the problem continues, check the Microosft Dynamics CRM Community for solutions or contact your Microsoft Dynamics administrator. Finally, you can contact Microsoft Support.”

    can u help me?

    ReplyDelete
  3. AndreasJanuary 24, 2012 at 7:51 PM

    Hi Ahmet, what happens after you click ok to that message?
    I believe that error message is not related to this as it doesn't look like a JS error.

    ReplyDelete
  4. AnonymousJuly 10, 2012 at 7:09 PM

    I got error at request += CrmEncodeDecode.CrmXmlEncode(sFetchXml); this line

    CrmEncodeDecode is not defined

    ReplyDelete
    Replies
    1. AndreasJuly 17, 2012 at 11:20 PM

      Hi m2012,

      Are you running this outside CRM?
      You might want to check this out:
      http://mscrmkb.blogspot.com.au/2011/12/crm-2011-javascript-giving-error.html

      Delete
  5. AnonymousOctober 5, 2012 at 3:56 AM

    Andreas

    Where did you get the information for the a:AliasedValue from - the code is failing for me as all that seems to be there is the name which is in attr.childNodes[k].childNodes[1].childNodes[2].childNodes[0].text; and the other childnodes are not there (e.g. attr.childNodes[k].childNodes[1].childNodes[2].childNodes[1].text;) making the code fail?

    I am reading the parent account name from the contact

    Andrew

    ReplyDelete
    Replies
    1. AndreasOctober 23, 2012 at 9:48 PM

      Hi,

      Sorry I can't remember what I used AliasedValue for - but I needed it that's why I put it there I believe. If you don't need those attributes feel free to remove it to make it work on your end :D

      Delete
  6. SureshApril 30, 2013 at 3:41 AM

    Hi
    Thanks for sharing. I'm getting "Access is deined" error. Can some one guide me how to avoid this.

    ReplyDelete
    Replies
    1. AndreasMay 7, 2013 at 1:50 PM

      Are you a system administrator? it might be entity permission issue.

      Delete

Post a Comment

Popular posts from this blog

SharePoint 2013 anonymous access add attachments to list item

Image
Hi, Sometimes you want to enable anonymous access to be able to add a list item but at the same time attaching some documents. After good few hours playing around trying to make this work, turns out that we can achieve this functionality. The trick is to use RunWithElevatedPrivileges method for the file upload. We also want the file upload functionality to be available on the NewForm.aspx as it wouldn't make sense to put it in other forms as any user would be able to upload files to other records. The result will be something like this: When it is saved, the user is redirected to the display form: The close button then will take the user back to the homepage (or any page you desire) The steps: 1. Create an ascx control to host your file upload control in your project.  Put the below script in the ascx as well (credit to this post ): The code behind: 2. Create custom form template. You have to put the ascx in the CONTROLTEMPLATES folder of the
Read more

Sitecore custom publish agent from specific node and at a specific time

Hi all, As you all know, scheduled publishing will not run automatically unless you enable PublishAgent task in Sitecore config. By default, all items that are in publish queue will get published when this task triggers. This includes all items in the final workflow state and all items that don't have workflows. Sometimes this is not what you want. Maybe you don't enable workflow on media items and you don't want the items to go live when they are not ready. The workaround is to create your own PublishAgent task. Looking at the one provided, we can easily extend the code to insert the RootItem to the PublishOptions (this only works with Full or Smart publish mode however): You will notice that on the Run method I check whether the server time is around the time I set in the parameter (thanks to this post for the code). This will enable us to run the task near the specific time we set (e.g. midnight). In the config patch, just add this to enable the custom agent
Read more

CRM Plugin - Parent and Child Pipeline

This concept tends to confuse people often - and I was no exception. I came across this problem when trying to create custom auto-numbering for one of my projects. Creating auto-number for Opportunity is easy. This is because the user creates opportunity straight from the home screen - thus the plugin runs on parent pipeline. However, it's a different story if you are dealing with Quote entity. Quote can be created in 2 ways, through the home screen OR the opportunity screen. If you create it from the latter, it will run on the child pipeline and you will find that your plugin will not work. Registering it as a child pipeline is easy, but CRM makes it harder since you can't use ICRMService. Instead, you have to create CRMService manually by using this piece of code: Not only that, with the child plugin you can't use Query expression to fetch other entities in your code unless you register it as ASYNCHRONOUS plugin. Mark Kovalcson in his blog found out that: A C
Read more