Microsoft Dynamics CRM 365
Recently we had an issue while trying to Query Retrieve Multiple for (Audit Entity) ,
Error Message: ” Expected value between 1 and 1 inclusive”.
Root Cause: Microsoft has moved Audit table to Cosmo DB, due to which Distinct & Aggregate, Group by function are no more supported from retrieve multiple query.
Fix: Remove distinct , aggregate , group by in your retrieve multiple query will resolve your issue.
Microsoft has released Public Preview of Maintenance Window Management in Power Platform Admin Center. So during our production downtime period now we can able to alert users.
Refer Microsoft link : https://docs.microsoft.com/en-us/power-platform/admin/manage-maintenance-window
Hello Experts ,
To retrieve Look up ( Id ) from Web api , usually we will be declaring Schema Name ,
But in Web api , there is an minor change in syntax.
Instead of Schema Name we need to declare like below forma.
_prefix_attributename_value.
Eg: _new_accountid_value
To retrieve Look up (Name , Logical Name ) We need to add below syntax in our Web api Request.
req.setRequestHeader(“Prefer”, “odata.include-annotations=\”*\””);
Sample Code For Reference.
Comments : Below example , will retrieve value from lead entity
var req = new XMLHttpRequest();
req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.1/leads()?$select=_accountid_value,budgetamount,_contactid_value,_customerid_value,emailaddress1,modifiedon,salesstage", false);
req.setRequestHeader("OData-MaxVersion", "4.0");
req.setRequestHeader("OData-Version", "4.0");
req.setRequestHeader("Accept", "application/json");
req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
<strong>req.setRequestHeader("Prefer", "odata.include-annotations=\"*\"");</strong>
req.onreadystatechange = function() {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) {
var result = JSON.parse(this.response);
var _accountid_value = result["_accountid_value"];
var _accountid_value_formatted = result["_accountid_value@OData.Community.Display.V1.FormattedValue"];
var _accountid_value_lookuplogicalname = result["_accountid_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
var budgetamount = result["budgetamount"];
var budgetamount_formatted = result["budgetamount@OData.Community.Display.V1.FormattedValue"];
var _contactid_value = result["_contactid_value"];
var _contactid_value_formatted = result["_contactid_value@OData.Community.Display.V1.FormattedValue"];
var _contactid_value_lookuplogicalname = result["_contactid_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
var _customerid_value = result["_customerid_value"];
var _customerid_value_formatted = result["_customerid_value@OData.Community.Display.V1.FormattedValue"];
var _customerid_value_lookuplogicalname = result["_customerid_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
var emailaddress1 = result["emailaddress1"];
var modifiedon = result["modifiedon"];
var salesstage = result["salesstage"];
var salesstage_formatted = result["salesstage@OData.Community.Display.V1.FormattedValue"];
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
To make it simple , use
CRM REST Builder which will generate the complete code, and you can save your time 😉 😉 😉
will this work for 2016 ?
is above mentioned reference are default available in crm 2015 and above ??
Some case you want to set read only for all field in the forms. It will take time to set field by field. This is small tip for marking all field as read only in MS CRM form.
| /// <reference path=”rbei_PACrm.Sdk.js” />
/// <reference path=”../PACRM2011/XrmPageTemplate.js” /> function MarkAllFieldReadOnly() { Xrm.Page.ui.controls.forEach(function (control, index) { try{ control.setDisabled(true); } catch (e) { } }); } |
Hope it will be useful for someone.
Recently we took and Online Dynamics CRM 2016 Update (8.1.0.369) . And we could able to find 2 New Modules have been Added.
Have a look into bellow video to get more information on both Module
Project Service Module
Field Service …
Thanks..
We may face an Issue ” Webresource content size is too big.” while importing a solution from one environment to another environment. Microsoft Dynamics CRM ERROR CODE 0x8004F114
To fix it ,
Goto –> Settings –> Administrator –> System Settings –>Email (Tab)
Set file size limit for attachments
Provide Maximum file size (in kilobytes) = 5,120
Note: If you reduce Maximum file size, CRM will not allow to upload / Import Notes attachement & Webresource (html, javascript , image , xml) where file greater than mentioned file kilobytes.
Hope this helps you..
Hi ,
If we need to retrieve CRM Records based on Entity Views in Plugin (c#).
In Saved Query
In User Query
Similarly
Retrieve User Query Records
Thanks 🙂
Hi ,
If we need to retrieve CRM Records based on Entity Views in Plugin (c#).
In Saved Query
In User Query
Retrieve saved Query Records
Guid ViewId = new Guid("GUID OF VIEW");
var savedQueryFetchXml = (from q in orgContext.CreateQuery("savedquery")
where (Guid)q["savedqueryid"] == ViewId // We can pass Name of the view [Eg:(string)q["name"] = "VIEW NAME"
&& (string)q["fetchxml"] != null
select q["fetchxml"]).FirstOrDefault();
Similarly
Retrieve User Query Records
var UserQueryFetchXml = (from q in orgContext.CreateQuery("userquery")
where (Guid)q["userqueryid"] == ViewId
&& (string)q["fetchxml"] != null
select q["fetchxml"]).FirstOrDefault();
Thanks 🙂
Hi ,
in my previous post I have explained how to interact WCF Services with Microsoft Dynamics CRM.
In this post I would like to explain how to invoke the Wcf services with CRM service using plugin c#.
• For calling external wcf services within our crm service, we can generate WCF Client Class similar to our early bound class generation.
Goto Visual Studio Tools –> Developer Command
• Use Svcutil.exe and map to the desired location where your client code has to get generated.
Type the following command : svcutil.exe followed by language type , Early Bound class Name.cs , Hosted Url of your WCF Application
svcutil.exe /language:cs /out:CreateLead.cs http://****:8081/Service1.svc
Add the generated CreateLead.cs class in your application and the namespace reference in your plugin class file
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;
using System.Net;
using System.ServiceModel;
using CreateLead; // Generated WCF Class
namespace Crm_Plugin
{
public class WCF_Integration : IPlugin
{
public void Execute(IServiceProvider serviceProvider)
{
//Extract the tracing service for use in debugging sandboxed plug-ins.
ITracingService tracingService =
(ITracingService)serviceProvider.GetService(typeof(ITracingService));
//<snippetFollowupPlugin1>
// Obtain the execution context from the service provider.
IPluginExecutionContext context = (IPluginExecutionContext)
serviceProvider.GetService(typeof(IPluginExecutionContext));
//</snippetFollowupPlugin1>
//<snippetFollowupPlugin2>
// The InputParameters collection contains all the data passed in the message request.
if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity)
{
// Obtain the target entity from the input parameters.
Entity entity = (Entity)context.InputParameters["Target"];
// Invoke WCF SERVICE
BasicHttpBinding myBinding = new BasicHttpBinding();
myBinding.Name = "BasicHttpBinding_IService1";
myBinding.Security.Mode = BasicHttpSecurityMode.None;
myBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.None;
myBinding.Security.Transport.ProxyCredentialType = HttpProxyCredentialType.None;
myBinding.Security.Message.ClientCredentialType = BasicHttpMessageCredentialType.UserName;
EndpointAddress endPointAddress = new EndpointAddress("http://******:8080/Service1.svc");
ChannelFactory<IService1> SerFactor = new ChannelFactory<IService1>(myBinding, endPointAddress);
IService1 chanl = SerFactor.CreateChannel();
// Passing Parameter to the Wcf Class CreateLead
string Result =chanl.CreateLead(entity.GetAttributeValue<string>("firstname").ToString(), entity.GetAttributeValue<string>("lastname").ToString(), entity.GetAttributeValue<string>("emailaddress1").ToString());
SerFactor.Close();
}
}
}
}
* Note ,
i have registered my plugin in pre create Contact Entity .
Passing [ First Name , Last Name , Email Address ] 3 parameters to out CreateLead WCF Method .
Dynamics CRM 365 