Category: Micrososft

Connection from PHP to Microsoft Dynamics CRMThis time we will learn how to connect Microsoft dynamics CRM using PHP code. Microsoft dynamics CRM soap service can be a way to make calls from PHP source code. A valid soap header is required to execute soap request. Let’s see how to create a valid header using PHP code:

To get valid soap request, first need to create token1, token2, and keyIdentifer which can be created using online user name and password.

Soap enavlop for getting token1, token2, ekyidentifer:

$xml = “<s:Envelope xmlns:s=\”http://www.w3.org/2003/05/soap-envelope\” xmlns:a=\”http://www.w3.org/2005/08/addressing\” xmlns:u=\”http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\”>”;

$xml .= “<s:Header>”;

$xml .= “<a:Action s:mustUnderstand=\”1\”>http://schemas.xmlsoap.org/ws/2005/02/trust/RST/Issue</a:Action>”;

$xml .= “<a:MessageID>urn:uuid:” . $this->newGUID () . “</a:MessageID>”;

$xml .= “<a:ReplyTo>”;

$xml .= “<a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>”;

$xml .= “</a:ReplyTo>”;

$xml .= “<a:To s:mustUnderstand=\”1\”>https://login.microsoftonline.com/RST2.srf</a:To>”;

$xml .= “<o:Security s:mustUnderstand=\”1\” xmlns:o=\”http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\”>”;

$xml .= “<u:Timestamp u:Id=\”_0\”>”;

$xml .= “<u:Created>” . gmdate ( ‘Y-m-d\TH:i:s.u\Z’, $now ) . “</u:Created>”;

$xml .= “<u:Expires>” . gmdate ( ‘Y-m-d\TH:i:s.u\Z’, strtotime ( ‘+60 minute’, $now ) ) . “</u:Expires>”;

$xml .= “</u:Timestamp>”;

$xml .= “<o:UsernameToken u:Id=\”uuid-” . $this->newGUID () . “-1\”>”;

$xml .= “<o:Username>” . $username . “</o:Username>”;

$xml .= “<o:Password>” . $password . “</o:Password>”;

$xml .= “</o:UsernameToken>”;

$xml .= “</o:Security>”;

$xml .= “</s:Header>”;

$xml .= “<s:Body>”;

$xml .= “<trust:RequestSecurityToken xmlns:trust=\”http://schemas.xmlsoap.org/ws/2005/02/trust\”>”;

$xml .= “<wsp:AppliesTo xmlns:wsp=\”http://schemas.xmlsoap.org/ws/2004/09/policy\”>”;

$xml .= “<a:EndpointReference>”;

$xml .= “<a:Address>urn:” . $urnAddress . “</a:Address>”;

$xml .= “</a:EndpointReference>”;

$xml .= “</wsp:AppliesTo>”;

$xml .= “<trust:RequestType>http://schemas.xmlsoap.org/ws/2005/02/trust/Issue</trust:RequestType>”;

$xml .= “</trust:RequestSecurityToken>”;

$xml .= “</s:Body>”;

$xml .= “</s:Envelope>”;

In response, you will get element “CipherValue” which has both tokens which you can fetch from response. See sample code:

$response = curl_exec ( $ch );

curl_close ( $ch );

$responsedom = new DomDocument ();

$responsedom->loadXML ( $response );

$cipherValues = $responsedom->getElementsbyTagName ( “CipherValue” );

$token1 = $cipherValues->item ( 0 )->textContent;

$token2 = $cipherValues->item ( 1 )->textContent;

Next is to get KeyIdentifier value which you can get using “KeyIdentifier” element name from response.

$keyIdentiferValues = $responsedom->getElementsbyTagName ( “KeyIdentifier” );

Now need to get online header using token1, token2 and KeyIdentifier. Below you can see example of header xml for Soap request:

$xml = “<s:Header>”;

$xml .= “<a:Action s:mustUnderstand=\”1\”>http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/Execute</a:Action>”;

$xml .= “<Security xmlns=\”http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\”>”;

$xml .= “<EncryptedData Id=\”Assertion0\” Type=\”http://www.w3.org/2001/04/xmlenc#Element\” xmlns=\”http://www.w3.org/2001/04/xmlenc#\”>”;

$xml .= “<EncryptionMethod Algorithm=\”http://www.w3.org/2001/04/xmlenc#tripledes-cbc\”/>”;

$xml .= “<ds:KeyInfo xmlns:ds=\”http://www.w3.org/2000/09/xmldsig#\”>”;

$xml .= “<EncryptedKey>”;

$xml .= “<EncryptionMethod Algorithm=\”http://www.w3.org/2001/04/xmlenc#rsa-oaep-mgf1p\”/>”;

$xml .= “<ds:KeyInfo Id=\”keyinfo\”>”;

$xml .= “<wsse:SecurityTokenReference xmlns:wsse=\”http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\”>”;

$xml .= “<wsse:KeyIdentifier EncodingType=\”http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary\” ValueType=\”http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-x509-token-profile-1.0#X509SubjectKeyIdentifier\”>” . $keyIdentifer . “</wsse:KeyIdentifier>”;

$xml .= “</wsse:SecurityTokenReference>”;

$xml .= “</ds:KeyInfo>”;

$xml .= “<CipherData>”;

$xml .= “<CipherValue>” . $token1 . “</CipherValue>”;

$xml .= “</CipherData>”;

$xml .= “</EncryptedKey>”;

$xml .= “</ds:KeyInfo>”;

$xml .= “<CipherData>”;

$xml .= “<CipherValue>” . $token2 . “</CipherValue>”;

$xml .= “</CipherData>”;

$xml .= “</EncryptedData>”;

$xml .= “</Security>”;

$xml .= “<a:MessageID>urn:uuid:” . $this->newGUID () . “</a:MessageID>”;

$xml .= “<a:ReplyTo>”;

$xml .= “<a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>”;

$xml .= “</a:ReplyTo>”;

$xml .= “<a:To s:mustUnderstand=\”1\”>” . $url . “XRMServices/2011/Organization.svc</a:To>”;

$xml .= “</s:Header>”;

CRM URN Address based on the Online region of customer. You can use this function to get correct URN:

function GetUrnOnline($url) {

if (strpos ( strtoupper ( $url ), “CRM2.DYNAMICS.COM” )) {

return “crmsam:dynamics.com”;

}

if (strpos ( strtoupper ( $url ), “CRM4.DYNAMICS.COM” )) {

return “crmemea:dynamics.com”;

}

if (strpos ( strtoupper ( $url ), “CRM5.DYNAMICS.COM” )) {

return “crmapac:dynamics.com”;

}

if (strpos ( strtoupper ( $url ), “CRM6.DYNAMICS.COM” )) {

return “crmoce:dynamics.com”;

}

if (strpos ( strtoupper ( $url ), “CRM7.DYNAMICS.COM” )) {

return “crmjpn:dynamics.com”;

}

if (strpos ( strtoupper ( $url ), “CRM9.DYNAMICS.COM” )) {

return “crmgcc:dynamics.com”;

}

return “crmna:dynamics.com”;

}

Using header you can connect Dynamics CRM from PHP code. See example code lines to get list data from PHP code:

/ Get Dynamics CRM Online Header

$url = “https://org.crm.dynamics.com/”;

$username = “user@dynamics.net”;

$password = “password”;

$dynamicsCrmHeader = new DynamicsCrmHeader ();

$authHeader = $dynamicsCrmHeader->GetHeaderOnline ( $username, $password, $url );

// Get Dynamics CRM Online Header

Soap request for getting list:

$xml .= “<s:Envelope xmlns:s=\”http://www.w3.org/2003/05/soap-envelope\” xmlns:a=\”http://www.w3.org/2005/08/addressing\”>”;

$xml .= $authHeader->Header;

$xml =”<s:Body>”;

$xml .=”<Execute xmlns=\”http://schemas.microsoft.com/xrm/2011/Contracts/Services\” xmlns:i=\”http://www.w3.org/2001/XMLSchema-instance\”>”;

$xml .=”<request i:type=\”a:RetrieveMultipleRequest\” xmlns:a=\”http://schemas.microsoft.com/xrm/2011/Contracts\”>”;

$xml .=”<a:Parameters xmlns:b=\”http://schemas.datacontract.org/2004/07/System.Collections.Generic\”>”;

$xml .=”<a:KeyValuePairOfstringanyType>”;

$xml .=”<b:key>Query</b:key>”;

$xml .=”<b:value i:type=\”a:QueryExpression\”>”;

$xml .=”<a:ColumnSet>”;

$xml .=”<a:AllColumns>true</a:AllColumns>”;

$xml .=”<a:Columns xmlns:c=\”http://schemas.microsoft.com/2003/10/Serialization/Arrays\”>”;

$xml .=”</a:Columns>”;

$xml .=”</a:ColumnSet>”;

$xml .= “<a:Criteria>”;

$xml .= “<a:Conditions />”;

$xml .= “<a:FilterOperator>And</a:FilterOperator>”;

$xml .= “<a:Filters />”;

$xml .= “</a:Criteria>”;

$xml .=”<a:Distinct>false</a:Distinct>”;

$xml .=”<a:EntityName>list</a:EntityName>”;

$xml .=”<a:LinkEntities />”;

$xml .=”<a:Orders />”;

$xml .=”<a:PageInfo>”;

$xml .=”<a:Count>0</a:Count>”;

$xml .=”<a:PageNumber>0</a:PageNumber>”;

$xml .=”<a:PagingCookie i:nil=\”true\” />”;

$xml .=”<a:ReturnTotalRecordCount>false</a:ReturnTotalRecordCount>”;

$xml .=”</a:PageInfo>”;

$xml .=”<a:NoLock>false</a:NoLock>”;

$xml .=”</b:value>”;

$xml .=”</a:KeyValuePairOfstringanyType>”;

$xml .=”</a:Parameters>”;

$xml .=”<a:RequestId i:nil=\”true\” />”;

$xml .=”<a:RequestName>RetrieveMultiple</a:RequestName>”;

$xml .=”</request>”;

$xml .=”</Execute>”;

$xml .=”</s:Body>”;

$xml .= “</s:Envelope>”;

You need to make soap call and convert response as  DomDocument.

$client = new DynamicsCrmSoapClient ();

$response = $client->ExecuteSOAPRequest ($xml, $url );

//echo $response;

$responsedom = new DomDocument ();

$responsedom->loadXML ( $response );
Please find code sample here: https://github.com/stw-services/Dynamics-CRM/tree/master/PHP-MSCRM

Thanks for reading 

Dynamics CRM 2016 – Custom plugin development – This time we are going through a process of building a custom plug-in for Microsoft Dynamics CRM and its deployment on development server.  I assume that you already downloaded and setup Development Tool Kit. And make sure CRM templates are imported in Visual Studio.

Start with creating a solution using Dynamics CRM. Navigate to Settings >> Customization >> Solution. Create a new Solution “AccountPlugin” and choose any name based on project and company requirement. In case, you are going to develop plugin for any existing solution skip this steps.

Save CRM solution and publish.

In Visual Studio, Create new project using Dynamics CRM 2013 Package template. If templates are not available, make sure that you already imported development tool kit templates in Visual Studio.

Dynamics CRM package is selected instead of Dynamics CRM 2013 plugin because it will make our process easy for plugin registration and deployment using tool kit.

You will be asked to connect CRM live before Visual Studio setup package solution. CRM connection screen pops up. You can also open it from Tool >> CRM connection.

Fill out required details and connect development Dynamics CRM server.

URL: CRM URL.

User Name: Domain Administrator

Password:   Domain Administrator Password

Browse all organizations and select appropriate organization and solution to hook plugin.

After a successful connection with CRM server, CRM package solution will be created in Visual Studio. Next step is to add a CRM plugin library project in solution. More plug-in projects can be added in one solution.

Now Visual Studio solution is set up and ready for plugin development. Some important file and DLLs are added in projects which are required. Let me elaborate important of these files.

RegisterFile.crmregistration is xml file contains details of all added plugins and workflows and register those in Dynamics CRM when package is deployed. Its auto created file using CRM Development Tool Kit.

Microsoft.Crm.Sdk.Proxy and Microsoft.Xrm.Sdk are two very important DLLs referenced in plugin project. These DLLs contain core classes of Microsoft dynamics CRM which are used for plugin operations.

Next step is to create strong name key for plugin project. Right click on project and select properties and create new Strong Name key (SNK). SNK is system oriented and when you move this development code on another machine, SNK needs to create again.

Open CRM explorer from View>>CRM explorer and expend entities. Right click on Account entity and select create plugin. It’s popping up Create Plug-in window.

Let’s go through Create Plug-in form attributes. First one “Project” is default set to “AccountPlugin” as it’s related to a single plugin project, in case we have more than one plugin projects. It will be enabled for selection.

Next is “Primary entity” is about to entity for which plugin is being created and it “Account” entity.

Next one is “Message” is about to CRM action, it’s associated with.

Next important attribute is “Pipeline Stage” and it’s specifying execution time of plugin. In this example, we created “PostAccountcreate” plugin. So Pipeline Stage is to determine on which stage of “PostAccountCreate”, this plug-in will fire.

Next one is “Class” to specify class name for plug-in. Next important attribute is “Execution order” to specify order of plugin execution. In case of many plugins are associated with an action stage, it will be used to determine the execution order of this plug-in. Click Ok and plugin will be created.

After successful creation of “AccountPlugin”. Open “RegisterFile.crmregister” file and a new code line is added in xml for created “AccountPlugin” plugin.

“PostAccountCreate” class is added in plug-in project, where custom code will be written for operations required under this plugin. “ExecutePostAccountCreate” method is responsible for plugin operations.

Sample code lines for update Account entity Name attribute:

protected void ExecutePostAccountCreate(LocalPluginContext localContext)

{

if (localContext == null)

{

throw new ArgumentNullException(“localContext”);

}

// TODO: Implement your custom Plug-in business logic.

IPluginExecutionContext Context = localContext.PluginExecutionContext;

IOrganizationService service = localContext.OrganizationService;

ITracingService trace = localContext.TracingService;

Entity entity = null;

EntityReference parentCustomerIdAttribRef = null;

// If we have a target

if (Context.InputParameters.Contains(“Target”) && Context.InputParameters[“Target”] is Entity)

{

// Obtain the target entity

entity = (Entity)Context.InputParameters[“Target”];

// Only perform this code if this is a create

if (Context.MessageName != “Update”) { return; }

// Only perform this code for a certain entity

if (Context.PrimaryEntityName != “account”) { return; }

// Only perform this code if this column is included in the collection of attributes

else { return; }

}

else { return; }

try

{

// update entity attribute with attribute value

entity.Attributes[“name”] = “John”;

//Update account entity

service.Update(entity);

}

}

catch (FaultException<OrganizationServiceFault> e)

{ trace.Trace(string.Format(“Exception: {0}”, e.ToString())); }

catch (Exception ex)

{ trace.Trace(string.Format(“Exception: {0}”, ex.ToString())); }

}

}

Sample code lines use to update Account attribute name value as John. So after an account is created in CRM, account name attribute is updated as “john”.

At the end build project and right click on package and select deploy.