While working with Dynamics CRM plugin, we encountered a scenario where we were calling a Web API, which returns data in JSON format.<\/p>\n
Normally .NET framework provides many methods to use JSON in C# code, many third party solutions such as\u00a0Newtonsoft.Json<\/a>\u00a0library are available. Mostly we use JavaScriptSerializer to read JSON data.<\/p>\n However, when we register Plugin inside Sandbox, and if we try to use javascriptSerializer method in plugin, it will throw security exception error as show below:<\/p>\n The error message we get:<\/p>\n Unhandled Exception: Microsoft.Crm.CrmException: Unexpected exception from plug-in (Execute): XXXXXXXX.CRM2015.WorkflowActivities.XXXXXXXX: System.MethodAccessException: Attempt by security transparent method ‘XXXXXXXX.CRM2015.WorkflowActivities.XXXXXXXX.SetLocationInfo(Microsoft.Xrm.Sdk.IOrganizationService, Microsoft.Xrm.Sdk.ITracingService, System.String)’ to access security critical method ‘System.Web.Script.Serialization.JavaScriptSerializer..ctor()’ failed.<\/p>\n Assembly ‘XXXXXXXX.CRM2015.WorkflowActivities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3f9fc15734725b08’ is partially trusted, which causes the CLR to make it entirely security transparent regardless of any transparency annotations in the assembly itself.\u00a0 In order to access security critical code, this assembly must be fully trusted.<\/p>\n Assembly ‘System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ is a conditionally APTCA assembly which is not enabled in the current AppDomain.\u00a0 To enable this assembly to be used by partial trust or security transparent code, please add assembly name ‘System.Web.Extensions, PublicKey=0024000004800000940000000602000000240000525341310004000001000100B5FC90E7027F67871E773A8FDE8938C81DD402BA65B9201D60593E96C492651E889CC13F1415EBB53FAC1131AE0BD333C5EE6021672D9718EA31A8AEBD0DA0072F25D87DBA6FC90FFD598ED4DA35E44C398C454307E8E33B8426143DAEC9F596836F97C8F74750E5975C64E2189F45DEF46B2A2B1247ADC3652BF5C308055DA9’ to the the PartialTrustVisibleAssemblies list when creating the AppDomain. This error occurs since we cannot access third party dll\u2019s in CRM context.<\/p>\n To resolve this, we can use either ILMerge(utility for merging multiple .NET assemblies into a single one).<\/p>\n However there is an alternate way to get it done without using third party solution, by using DataContractJsonSerializer in CRM plugin.<\/p>\n Below code will demonstrate you how to use DataContractJsonSerializer in CRM plugin.<\/p>\n To use JSON in CRM plugin<\/p>\n Hope this will help you in using JSON data in Dynamics CRM plugin!<\/p>\n Gamifics365<\/a> <\/strong>\u2013 Spin the magic of games within Microsoft Dynamics 365 CRM to improve user adoption, enhance productivity, and achieve company goals!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":" While working with Dynamics CRM plugin, we encountered a scenario where we were calling a Web API, which returns data in JSON format. Normally .NET framework provides many methods to use JSON in C# code, many third party solutions such as\u00a0Newtonsoft.Json\u00a0library are available. Mostly we use JavaScriptSerializer to read JSON data. However, when we register\u2026 Read More: Working with JSON objects in Dynamics CRM Plugins »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,24,42],"tags":[974,975,976],"class_list":["post-3703","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-dynamics-crm-2016","category-plugin","tag-json-deserialization-dynamics-crm-plugin","tag-json-dynamics-crm-plugin","tag-json-serialization-dynamics-crm-plugin"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\nat Microsoft.Crm.Sandbox.SandboxCodeUnit.Execute(IExecutionContext context)
\nat Microsoft.Crm.Workflow.Services.ProxyCustomActivity.Execute(CodeActivityContext executionContext)<\/p>\n\n
[DataContract]\r\n public class Student\r\n {\r\n [DataMember]\r\n public string FullName { get; set; }\r\n [DataMember]\r\n public string JobTitle { get; set; }\r\n [DataMember]\r\n public string Contact { get; set; }\r\n [DataMember]\r\n public string Country { get; set; }\r\n [DataMember]\r\n public string ZIPCode { get; set; }\r\n \r\n }<\/pre>\n<\/li>\n<\/ol>\n\n
using (MemoryStream DeSerializememoryStream = new MemoryStream())\r\n {\r\n \/\/Json String that we get from web api \r\n string ResponseString = \"{\\\"FullName\\\":\\\"\" + \"Sam\" + \"\\\",\\\"JobTitle\\\":\\\"\" + \"Developer\" + \"\\\",\\\"Contact\\\":\\\"\" + \"808-124567\" + \"\\\",\\\"Country\\\":\\\"\" + \"India\" + \"\\\",\\\"ZIPCode\\\":\\\"\" + \"400005\" + \"\\\"}\";\r\n\r\n \/\/initialize DataContractJsonSerializer object and pass Student class type to it\r\n DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(Student));\r\n\r\n \/\/user stream writer to write JSON string data to memory stream\r\n StreamWriter writer = new StreamWriter(DeSerializememoryStream);\r\n writer.Write(ResponseString);\r\n writer.Flush();\r\n\r\n DeSerializememoryStream.Position = 0;\r\n \/\/get the Desrialized data in object of type Student\r\n Student SerializedObject = (Student)serializer.ReadObject(DeSerializememoryStream);\r\n }<\/pre>\n\n
using (MemoryStream SerializememoryStream = new MemoryStream())\r\n {\r\n \/\/create a sample data of type Student Class add details\r\n Student NewStudent = new Student();\r\n NewStudent.FullName = \"Sam\";\r\n NewStudent.JobTitle = \"Developer\";\r\n NewStudent.Contact = \"808-2125454\";\r\n NewStudent.Country = \"India\";\r\n NewStudent.ZIPCode = \"400005\";\r\n\r\n \/\/initialize DataContractJsonSerializer object and pass Student class type to it\r\n DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(Student));\r\n \/\/write newly created object(NewStudent) into memory stream\r\n serializer.WriteObject(SerializememoryStream, NewStudent);\r\n \r\n \/\/use stream reader to read serialized data from memory stream\r\n StreamReader sr = new StreamReader(SerializememoryStream);\r\n \r\n \/\/get JSON data serialized in string format in string variable \r\n string Serializedresult = sr.ReadToEnd();\r\n }\r\n<\/pre>\n