Skip to main content

Call MS CRM Service through Javascript to retrieve records

debugger;var gidLocationID = event.srcElement.DataValue[0].id;
var xml = "" + "" + "http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" + " " + " http://schemas.microsoft.com/crm/2007/WebServices\">" + " 00000000-0000-0000-0000-000000000000http://schemas.microsoft.com/crm/2007/CoreTypes\">00000000-0000-0000-0000-000000000000>" + " " + " " + " " + " http://schemas.microsoft.com/crm/2007/WebServices\">" + " http://schemas.microsoft.com/crm/2006/Query\" xsi:type=\"q1:QueryExpression\">" + " **EntitySchemaname** " + " " + " " + " ** Attrbute Name 1**" + " >** Attrbute Name 2**" + " " + " " + " " + " " + " " + " new_locationid" + " Equal" + " " + " http://microsoft.com/wsdl/types/\" xsi:type=\"q2:guid\">" + requiredGUID + " " + " " + " " + " " + " " + " " + " " +
" " +
"" +
"";


var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");

xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false); xmlHttpRequest.setRequestHeader("SOAPAction","http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");



xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);
var resultXml = xmlHttpRequest.responseXML;


var entityNodes = resultXml.selectNodes("//RetrieveMultipleResult/BusinessEntities/BusinessEntity");

if(entityNodes.length>0)
{

var entityNode = entityNodes[0];
var att1Value = entityNode.selectSingleNode('q1:attribute1schemaname').text;
...
}

Comments

Post a Comment

Popular posts from this blog

Using MS CRM Calendar in your custom ASP .NET pages *** Not fully Supported Customisations ***

Hi, Have you been creating custom pages in line with MS CRM for creating , viewing and updating entity records ? Have you placed controls such as Date picker Lookup on your custom page and have tried in vein to make those look like MS CRM ? I found a way to use the same MS CRM calendar control as it appears in the application... For getting this calendar on your asp .net page, follow the steps below: 1) Create a copy of the date.js javascript file located in your-server/crmsite-folder/_static/_controls/datetime folder, give the copy some name like date_myapp.js. 2) Open the following .js files from different sub folders in side the  your-server/crmsite-folder/_static      folder :       Global.js       encodedecode.js       xmlutil.js       util.js       remotecommand.js              Copy and whole content of each file one by one and keep pasting the same to the end of your date_myapp.js file. 3) Now open any CRM entity record page, for example a new Account crea
24 comments
Read more

Capture and Handle event when one entity record is attached through a Many to Many relationship - MS CRM 4

If you have already dug up too much about trying to capture the event when an entity record in MS CRM is attached ~ linked to a record in many to many relationship. For example, if you have two entities : Supplier and Company in MS CRM where a supplier can do business with many companies and at the same time a Company can order stuff from many suppliers. What if you want to send some notification whenever a new supplier or an existing supplier is linked to a company; similarly you may want to send a notification when a Supplier signs a deal with 2-3 companies and gets linked to those. Some experts from MS CRM fraternity have suggested some ways to over ride this limitation of MS CRM that it does not expose any event for the above mentioned scenario, below is one of the examples:   http://ayazahmad.wordpress.com/2009/07/23/event-on-many-to-many-relationship-nn-in-crm-4/ But making changes to the default plugin model of MS CRM to add Associate or Disassociate event is not so eas
14 comments
Read more

Creating Email through Plugin / SDK in CRM 4 - line breaks don't work

You may have noticed when you create email using a sample code like below in a plugin or for that matter any other SDK based assembley for MS CRM. Your line breaks : \n or \r or System.Environment.NewLine will not work.           email Email = new email();                          Email.to = new activityparty[] { toParty };                      Email.from = new activityparty[] { fromParty };                      Email.regardingobjectid = regardingObject;                      Email.subject = "Hello!!";                      Email.description = "Dear, line 1" +                                System.Environment.NewLine+                          "my message for your - line 2";                      Email.directioncode = new CrmBoolean();                      Email.directioncode.Value = true;                                            Guid _emailId = _service.Create(Email);                                            SendEmailRequest sendEmailReq
5 comments
Read more