Read Configuration file (Web resource - Data (Xml)) in CRM-Plugin

Sometimes, we would like to read data of configuration file which has been added as web resource of type Data (Xml) in Dynamic CRM.

In this example I’ve used a web resource named as “TestData.xml” which contains Data in xml format as shown below (Organization name and Entity name). I would like to explain how to read Organization name from this web resource, a Data (Xml) file.



Add the following class files in your class library project from this location “..\sdk\samplecode\cs\helpercode” once you have successfully downloaded Dynamics CRM SDK 5.0.9 (http://www.microsoft.com/download/en/details.aspx?id=24004).

· crmservicehelpers.cs
· myorganizationcrmsdktypes.cs
· optionsets.cs

Below is the code to retrieve a web resource record.

using System.Xml.Linq;

using Microsoft.Xrm.Sdk.Query;

//create request to retrieve Webresource 

QueryByAttribute requestWebResource = new QueryByAttribute

{

EntityName = WebResource.EntityLogicalName,

ColumnSet = new ColumnSet(true),

};

requestWebResource.Attributes.AddRange(“name”);

requestWebResource.Values.AddRange(“acm_/XML/TestData.xml”); 

WebResource webResource = null;

EntityCollection webResourceCollection = organizationService.RetrieveMultiple(requestWebResource);

if (webResourceCollection.Entities.Count == 0)

throw new InvalidPluginExecutionException("Specified Webresource does not exist");

webResource = (WebResource)webResourceCollection.Entities[0];

byte[] binary = Convert.FromBase64String(webResource.Attributes[“content”].ToString());

string resourceContent = UnicodeEncoding.UTF8.GetString(binary);

Once you retrieve a data xml record in above “webResource” variable then convert the content attribute in byte array. By using “UnicodeEncoding” class we will get an encoded string which can be further used with XDocument class.

//Load xml document

XDocument xDoc = XDocument.Parse(resourceContent);

string orgName= string.Empty;

XElement orgNameElement = xDoc.XPathSelectElement("//OrgName");

if (orgNameElement != null)

orgName = orgNameElement.Value;

I hope this will be helpful.