Category: Dynamics 365

above and under were the 2 new operators introduced with Dynamic CRM 2015.

Let us see some of the examples.

Suppose I have the following hierarchy defined, wherein User 2 is manager of user Nishant Rana who in turn is manager of User 1.

And following are the contacts record owned by them.

In context of user Nishant Rana, if I apply Under operator, we’d get the following result

Only the records owned by child

And for Not Under

All the records owned by the user and its manager(s) or parent.

Now we do not have the Above operator in Advanced Find

So, using our favorite tool Fetch XML Builder, the above operator shows only the records owned by the parent(s) of current user.

We also have Above or equal, Under or equal operator which aren’t there in Advanced Find.

Hope it helps..

Today afternoon we started getting the below error in the lookup dialog box for customer and contact.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: A quick find filter cannot have any child filtersDetail:

<OrganizationServiceFault xmlns:i=”http://www.w3.org/2001/XMLSchema-instance&#8221; xmlns=”http://schemas.microsoft.com/xrm/2011/Contracts”&gt;

<ActivityId>a5d85309-b57b-4265-b54e-afd09bfeeddc</ActivityId>

<ErrorCode>-2147217118</ErrorCode>

<ErrorDetails xmlns:d2p1=”http://schemas.datacontract.org/2004/07/System.Collections.Generic”&gt;

<KeyValuePairOfstringanyType>

<d2p1:key>ApiExceptionSourceKey</d2p1:key>

<d2p1:value xmlns:d4p1=”http://www.w3.org/2001/XMLSchema&#8221; i:type=”d4p1:string”>Plugin/Microsoft.Crm.Common.ObjectModel.AccountService</d2p1:value>

</KeyValuePairOfstringanyType>

<KeyValuePairOfstringanyType>

Searching for this in the internet we found that mostly the users that are in Microsoft Dynamics 365Version 1710 (9.1.0.643) online are getting this error.

We as suggested raised the support ticket for this in the evening. However strangely enough after 2-3 hours when we are checking this error it is not coming anymore.

We had created one trial instance which was also having the same issue and it has been fixed there. It looks like product team have deployed some kind of fix for it in the background.

Hope it helps..

Sharing a sample code that can be used to delete the instance in Dynamics 365 CE using Online Admin API.

Read the previous post for more details

We basically need to get the instace id and use the HTTP Delete to achieve this

https://docs.microsoft.com/en-in/rest/api/admin.services.crm.dynamics.com/Instances/DeleteInstance

Production instance needs to be converted to Sandbox before it can be deleted else we’d get the operation not supported error.

The sample code :-

private static void Main(string[] args)
{
var authContext = new AuthenticationContext(Authority, false);
var credentials = new UserCredential(UserName, Password);

// Get the token
_authResult = authContext.AcquireToken(Resource, ClientId, credentials);

Task.WaitAll(Task.Run(async () => await DeleteInstance()));
}
private static async Task DeleteInstance()
{
var httpClient = new HttpClient
{
BaseAddress = new Uri(Resource),
Timeout = new TimeSpan(0, 2, 0)
};

httpClient.DefaultRequestHeaders.Add("OData-MaxVersion", "4.0");
httpClient.DefaultRequestHeaders.Add("OData-Version", "4.0");
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer",
_authResult.AccessToken);

var retrieveResponse =
await httpClient.DeleteAsync("/api/v1.1/Instances/{instanceGuid}/Delete");

if (retrieveResponse.IsSuccessStatusCode)
{
var jRetrieveResponse =
retrieveResponse.Content.ReadAsStringAsync().Result;

}
}

Hope it helps..

Suppose, we have just registered an application in Azure Active Directory and trying to acquire the token and get the below error

Microsoft.IdentityModel.Clients.ActiveDirectory.AdalServiceException: ‘AADSTS65001: The user or administrator has not consented to use the application with ID ‘b2c5028d-57e6-4df7-9940-828e6914948b’ named ‘MyApp’. Send an interactive authorization request for this user and resource.

This is because admin consent is required before the application can be used. This could be granted by global administrator.

One of the ways to do so is through the URL with the specific format as shown below

https://login.microsoftonline.com/[tenantid]/oauth2/authorize?client_id=[appId]&response_type=code&redirect_uri=[redirctURL]&resource=[resourceURL]&prompt=admin_consent

Pasting this URL in the browser will prompt for the credential, login will global administrator and we will be presented with the following consent box

Clicking on Accept will grant the required permission to the application registered.

Hope it helps..

We can use RetrievePrincipalAccess function in Web API to get the access rights of either a user or team on a specific record.

The sample code:

var req = new XMLHttpRequest();

req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v9.1/systemusers(D38F5B76-C22E-4256-AF90-CFD14B6589BF)"+
"/Microsoft.Dynamics.CRM.RetrievePrincipalAccess(Target =@Target)?"+ 
"@Target={ 'accountid': '8CB09F67-EB90-E811-A963-000D3AD1CBD6', '@odata.type': 'Microsoft.Dynamics.CRM.account' } ", 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");
req.onreadystatechange = function () {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) { 
var results = JSON.parse(this.response);
} else { 
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();

Result:

Hope it helps..