Category: Other

Using CRM from an external website – part 4: Demo “Web API”

Originally posted on 25 August 2015 by Bas van de Sande on JourneyIntoCRM.com

Welcome to the next episode in the “Using CRM from an external website” series. In my last article, I described the Web API scenario. The Web API scenario is the first step in the journey and depends on Microsoft Infrasctrucure ( I need a .Net/Mono framework and an Internet Information like server).

In this scenario I hook up a web page to a Web API controller. The model behind the controller is responsible for getting the data from the back end CRM. As the Web API controller and the model are running in a .NET context, we simply can use the Dynamics CRM object model to get and set the data from CRM.

I Use javascript on the web page to make the REST calls. For data retrieval (Select and SelectList) I use a GET method. For Data manipulation (Insert, Update, Delete) I use a POST method. The javascript conducting the calls to the Web API controller are the bridge between the client side context and the server side context.

Webapi

In this article I’ll show you the main concepts on passing data from the client side context to the server side context and vice versa. For the sake of simplicity the model class is not conducting any operation towards CRM.

MVC

The Web API scenario is based on the MVC principles. We work with a single controller or multiple controllers (to define the actions) and with a model or multiple models (containing the data).
Using MVC we need to specify where our controllers can be found. This has to be done in a RouteTable.  In the RouteTable you can specify how your URL’s should look like.

The RouteTable is specified in the global.asax file in the web project.

Webapiglobalasax

Model

The basis of the Web API scenario is the model. In the model we define how the data should look like. In my implementation I use the model in a fashion that I can pass the model outside the boundaries of the assembly and still keeping full control over the behaviour of the class. I specified public properties and internal methods.

The public properties can be get and set by anyone. The internal methods can only be called within the context of the assembly (read: controller).

The idea of using a model is to simplify the transport of data over the server side and client side context.

Webapimodel

Controller

The controller acts like a façade (gateway) between the client side and server side context. As you can see all functions are decorated with two attributes.

  • HttpPost / HttpGet
    This attribute defines in what context the function is called. By either a HttpGet or a HttpPost method.
  • ActionName
    This attribute defines the name of the function to the outside world. This way we can give meaningfull names to our get and post methods and we can have multiple get and post methods within the controller.

To simplify communication between the server side and client side context, we try to work as much as possible with simple data types (like string etc), instead of using complex objects. However, when you look at e.g. the Insert() function, you see that we pass in a string representing a model.
The model is deserialized and instantiated into our strong typed model class.

Once instantiated we can call the appropriate method on the model to conduct the action we desire. On the other hand we can return complex objects back to the client side context by simply using the object.  The javascript JSON call handles all serialization and deserialization for us. *nifty*

Webapicontroller

Javascript methods

On the web page we have basically two kinds of methods. Either a GET or a POST method.

Looking at the GET method, we simply specify the URL in the format defined in the RouteTable. We have to omit the word “Controller”, that is handled by MVC.

Our url looks like:

“api / [name of the model] / [method on the controller] / ?[parameter]”.

Please note that method names and parameters are case sensitive. Once the data is retrieved, we simply can use the properties defined in the model (case sensitive)

Webapi-get

Looking at the POST method, we have to a a bit more work.
First of all we have to fill a JSON object and stringify it (encode it for transport).
Then we pass it to our url in a parameter. Our url is enriched with a string representing our model. In the controller we deserialize the string and turn it into a .NET object.

Webapi-post

This is in a nutshell all technology you need to integrate your CRM environment in your website. As I mentioned before, this is only the first step. In this example I trust on the security mechanisms offered by the .NET framework and the Microsoft infrastructure. My ultimate goal is to be able to integrate my CRM environment with a non Microsoft environment.

Filed under: Other

How to automatically refresh your Dynamics 365 Dashboard in UCI

Procedure:

1. Create an html web resource and add the following script in it:

<html><head>
     <title></title>
     <script type="text/javascript">

         // add visual timer just because we can
         var d = new Date();
         document.write(d.toLocaleTimeString());

         // refresh parent (dashboard) every 30 seconds
         // (timeout is in milliseconds)
         setTimeout("window.parent.document.getElementById('RefreshDashboard').click();", 30 * 1000);
     </script>
   <meta><meta><meta><meta><meta></head>
   <body>
</body></html>

2. Add the html web resource to a dashboard.

3. Click on “Edit Component” and make sure the web resource’s “Visible By Default” property is unchecked.

Explanation:

On the dashboard, there is a button called “Refresh Dashboard”. The ID of this button is RefreshDashboard. The script above clicks this button every 30 seconds. You can change the button to put in another value for seconds.

Filed under: Other

Mimic DNN theme to embed pages into Dynamics CRM

This is a theme you can install on DotNetNuke Community Edition to create pages which are embeddable in Dynamics CRM as web resources. There are a lot of open source tools available for DNN which can allow you to do quick web app building. Some of my favorite tools include the SqlViewPro and InjectAnything from RedTempo. Mix them all together and you got a great presentation tool you can use in Dynamics CRM Dashboards. Especially since CRM has Xrm.Page.context.getUserId() and DNN has the [User:Username] token.

It’s not a replacement for sophisticated BI tools but gets me to do some interesting stuff. So here it is.

Mimic – (Zip File)

Filed under: CSS, JS, Other, SharePoint

How to link directly to a Dynamics CRM 2016 view or record.

You can link directly to a Dynamics CRM view or record by formatting your URL like this:

https://<domain>/<org>/main.aspx?etn=account&pagetype=entitylist&viewid=%7bb210XXX63-BXCA-X731-81F5-93XXXXXX8301%7d&cmdbar=true&web=true&navbar=on

These are the parameters at play here:

  1. https://<domain>/<org>/main.aspx
  2. ?etn=account (entity)
  3. &pagetype=entitylist (or entityrecord)
  4. &viewid=%7b210XXX63-BXCA-X731-81F5-93XXXXXX8301%7d (%7b is escaped “{” and %7d is escaped “}”)
  5. &cmdbar=true (this is the bar that starts with “+ New”)
  6. &web=true (this makes sure the navigation bar will show)
  7. &navbar=on (the navigation bar)

Note: If you want to find the viewid, go to your CRM record or view, click “Email a link” and then “of Current View”, then find the viewid in the link.

For more information, see MSDN article Open forms, views, dialogs, and reports with a URL

 

 

Filed under: Other

Pareshan Hoon (Bal-e-Jibreel)

پریشان ھوں کے میری خاک آخر دل نا بن جاے
جو مشکل اب ہے یا رب پھر وھی مشکل نا بن جاے

Worry I, that my scattered ashes become a beating heart again.
Those woes that haunted it since, make it fall apart again.

نا کر دیں مجھ کو مجبور نو فردوس میں حوریں
میرا سوز دوران پھر گرمی محفل نا بن جاے

Worry I, the sirens of heaven may tempt me into a song,
The love that burnt timid since, may burst into a blaze.

کبھی چھوڑی ہی منزل بھی یاد آتی ہے راھی کو
کھٹک سی ہے جو سینے میں غم منزل نا بن جاے

Does the wise seafarer ever dwell within his forgone paths? Nay,
But this infliction to you, may become my sorrow fare’s end.

بنایا عشق نے دریا نا پیدا کرنا مجھ کو
یه میری خد نگھداری میرا ساحل نا بن جاے

My love can make my ship run through seas of boundless depths,
But worry I, fear will keep me treading the shallow shores again.

کھین اس علم با رنگ بو میں بھی طلب میری
وھی افسانه دنبالہ محمل نا بن جاے

Does a world full of color and spice, even have a need for me?
Will the passions of this heart of mine echo a forgotten tale.

عروج آدم خاکی سے انجم سہمے جاتے ھیں
کے یه ٹوٹا ھوا مہ کامل نا بن جائے

Panic strikes the stars above, as the feeble Adam rises.
Worry they, this broken star, doesn’t burn a brilliant flame.

Filed under: Other