0
votes

I'm new at Microsoft Dynamics CRM and I'm working with CRM 2015. I'm working with CRM 2015 and I've been given to fix an error script developed for CRM 2011. It looks like an old syntax and I don't know how to adapt it to JS for CRM 2015. The script manage the user roles and roles name and I have retrieve the data through fetchXML.

function onChangeValutator()
{  
     var idUser = Xrm.Page.getAttribute("erm_valutatorid").getValue()[0].id;

     // Use the Xrm.Page.context.getAuthenticationHeader() method 
     // available from the CRM form to generate the Soap header text.
     var authenticationHeader = Xrm.Page.context.getAuthenticationHeader();

     // Define the SOAP XML to access Microsoft Dynamics CRM Web service.
     var xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" + 
     "<soap:Envelope xmlns:soap="+
     "\"http://schemas.xmlsoap.org/soap/envelope/\" "+
     "xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" "+
     "xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" + 
     authenticationHeader+
     "<soap:Body>" + 
     // Specify the RetrieveMultiple message.
     "<RetrieveMultiple xmlns="+
     "\"http://schemas.microsoft.com/crm/2007/WebServices\">" + 
     // Specify that this is a QueryByAttribute query.
     "<query xmlns:q1="+
     "\"http://schemas.microsoft.com/crm/2006/Query\" "+
     "xsi:type=\"q1:QueryByAttribute\">" + 
     // Query the customeraddress entity.
     "<q1:EntityName>erm_source</q1:EntityName>" + 
     // Set the columns you want to return.
     "<q1:ColumnSet xsi:type=\"q1:ColumnSet\">" + 
     "<q1:Attributes>" + 
     "<q1:Attribute>erm_roleid</q1:Attribute>" + 
     "</q1:Attributes>" + 
     "</q1:ColumnSet>" + 
     // Specify the attribute that you are querying on.
     "<q1:Attributes>" + 
     "<q1:Attribute>erm_sourceid</q1:Attribute>" + 
     "</q1:Attributes>" + 
     // Set the value of the attribute using the customerid 
     // value of the case record.
     "<q1:Values>" + 
     "<q1:Value xsi:type=\"xsd:string\">"+
     idUser+
     "</q1:Value>" + 
     "</q1:Values>" + 
     "</query>" + 
     "</RetrieveMultiple>" + 
     "</soap:Body>" + 
     "</soap:Envelope>";

    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 doc = xmlHttpRequest.responseXML;
    var source = doc.selectSingleNode("//BusinessEntity");

    var guidSource = source.childNodes[0];

    if (guidSource.text != null)
    {
        // Define the SOAP XML to access Microsoft Dynamics CRM Web service.
         xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" + 
         "<soap:Envelope xmlns:soap="+
         "\"http://schemas.xmlsoap.org/soap/envelope/\" "+
         "xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" "+
         "xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" + 
         authenticationHeader+
         "<soap:Body>" + 
         // Specify the RetrieveMultiple message.
         "<RetrieveMultiple xmlns="+
         "\"http://schemas.microsoft.com/crm/2007/WebServices\">" + 
         // Specify that this is a QueryByAttribute query.
         "<query xmlns:q1="+
         "\"http://schemas.microsoft.com/crm/2006/Query\" "+
         "xsi:type=\"q1:QueryByAttribute\">" + 
         // Query the customeraddress entity.
         "<q1:EntityName>erm_companyrole</q1:EntityName>" + 
         // Set the columns you want to return.
         "<q1:ColumnSet xsi:type=\"q1:ColumnSet\">" + 
         "<q1:Attributes>" + 
         "<q1:Attribute>erm_name</q1:Attribute>" + 
         "</q1:Attributes>" + 
         "</q1:ColumnSet>" + 
         // Specify the attribute that you are querying on.
         "<q1:Attributes>" + 
         "<q1:Attribute>erm_companyroleid</q1:Attribute>" + 
         "</q1:Attributes>" + 
         // Set the value of the attribute using the customerid 
         // value of the case record.
         "<q1:Values>" + 
         "<q1:Value xsi:type=\"xsd:string\">"+
         guidSource.text+
         "</q1:Value>" + 
         "</q1:Values>" + 
         "</query>" + 
         "</RetrieveMultiple>" + 
         "</soap:Body>" + 
         "</soap:Envelope>";
         
        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);
        doc = xmlHttpRequest.responseXML;
        var role = doc.selectSingleNode("//BusinessEntity");
        var roleName = role.childNodes[0];
        
        var lookupItem = new Array();
        lookupItem[0] = new Object();
        
        lookupItem[0].name = roleName.text;
        lookupItem[0].entityType = "erm_companyrole";
        lookupItem[0].id = guidRSource.text;
        
        Xrm.Page.getAttribute("erm_valutatorroleid").setValue(lookupItem);
        
    }		    
}
1
Just an opinion, but if you want to be prepared for CRM 2016 and beyond you should abandon SOAP endpoint requests and switch to the ODATA endpoint.Filburt
@Filburt I am willin to switch to ODATA but I don't haven't worked before with ODATA. I wanted a standart format to manage user roles in CRM 2016 using fetchXML. That's all I could think.zhaila

1 Answers

1
votes

Your queries are using the Dynamics CRM 4.0 web service endpoint, which is deprecated. Remove the authentication header from the SOAP message and replace the endpoint address "/mscrmservices/2007/CrmService.asmx" by "xrmservices/2011/organization.svc/web". A nice example can be found here.

With the introduction of the Web API in Dynamics CRM 2016 Microsoft dismissed the SOAP endpoint alltogether, but promised to continue supporting it for the coming years.