Azure Configuration Settings

If you’re still doing configuration in web.config files for your Azure services, it’s time to try something new and leverage something that has been there for quite some time – Application Settings.

In your Azure Portal, you will notice a section called Application Settings.  Within this section is everything you need to configure your application.  If you have some custom configuration data in your web.config file, a simple way to rely less on the web.config (and make your end administrator’s job a little more easier) is to expose these configuration values via Application Settings.

The process to create a new Application Setting is straight-forward, create the setting, add the value. (In this case I created a key called Tool).

Read More


Accessing MetaData with the Dynamics Web Api

In the previous Dynamics365 SDK, accessing metadata required that you go through a completely different service to get at the structure of your data.  With the WebApi, this has changed to simply be another querystring string call to get at your information.

Ignoring how to setup a connection, the query can be as simple as this;

string dataResponse = DynamicsHelper.Instance.GetFromDynamics("/api/data/v9.0/EntityDefinitions?$select=MetadataId,SchemaName");

Where my request for the name and id of all entities in the system is sent via EntityDefinitions.

At this stage in your query, you cannot filter out which entities you want to query for due to the fact that functions such as “contains” are not supported in this interface, thereby forcing you to do this client-side instead of during your trip to the server.

In my scenario I only wanted to return entity

Read More


Manually Setting up the Unified Service Desk

I had a problem a few weeks ago where I could not get the sample applications to install via the Package Deployer for the Unified Service Desk.  After way too many hours trying to get it to work, I decided to manually install the thing so I could get it up and running.

USDDeploy_KillingMe.PNG

WARNING: The following steps have been performed on v9.0 of Dynamics365 and serve to get your Unified Service Desk up and running with only the base configuration.

Installation

Download the Unified Service Desk Package Deployer, available here.

When extracted navigate tot eh solutions folder as shown below.

Read More


Understanding Form Types in Dynamics v9

In Dynamics v9, there are four custom form types that you can apply to your entities, all with a variety of features attached to them.  In previous versions there were more types but these have been rolled into these four as part of their usage in Power Apps and the User-Unified Interface.

If you’re new to Dynamics here’s the quick primer on getting started.

Main Form

The main form is strictly what it means, it’s the central form for accessing your entity in the web view across a variety of browsers.  This version of the form has been around for years.

mainform

Quick Create Form

If

Read More


Connecting to Azure Db via Code

Getting started with a new platform can be a little daunting, after all, there is so much to learn and where do you start.

From a client-side perspective, the only difference in connecting to an Azure Db over a server Db is the connection string.

string connectionstring = "Server=tcp:#SERVER#,1433;Initial Catalog=Signal;PersistSecurityInfo=False;User ID=#USERNAME#;Password=#PASSWORD#;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30";

SqlConnection cn = new SqlConnection();
cn.ConnectionString = connectionstring;

cn.Open();

From there, it’s a simple job of opening a connection, creating a command and querying your data.

The biggest problem I ran into was having to create the firewall rule to allow access (this will not be enabled by default).  Thankfully Visual Studio took care of this, giving me the prompt to do so and quickly enable.

firewall.pngRead More