Microsoft Dynamics 365 | Integration, Dataverse...

contacts API query is very slow

(1) Share

Report

Posted on by AR-07012221-0

Hi,

Our production app is calling the Dynamics API to query for contacts, but we are noticing it is very slow, taking around 13-15 seconds to respond. We are querying for contacts that match an email address or name.

Here is a sample query:

https://{subdomain}.crm.dynamics.com/api/data/v9.2/contacts?$top=25&$filter=(contains(fullname,'test')%20or%20contains(emailaddress1,'test'))%20and%20(Microsoft.Dynamics.CRM.NotIn(PropertyName='statecode',PropertyValues=['0','1']))&$select=fullname,firstname,lastname,emailaddress1&$expand=owninguser($select=fullname,windowsliveid)

I've tried reducing limit from 25, but that doesn't seem to make a difference. Is there anything else we can do to optimize the query? What is the expected latency of this API?

Categories:

Dynamics 365 general

I have the same question (0)

All responses (2)

Answers (0)

AR-07012221-0 7 on at

Like (0)

Report

contacts API query is very slow

Thanks for the reply. From what I've found:

- full query: 13-14 seconds

- only status code check: 2-3 seconds

- only email check: 8-9 seconds

- only full name check: 16-18 seconds

Was this reply helpful? Yes No
Suggested answer

PerezAguiar Microsoft Employee on at

Like (1)

Report

contacts API query is very slow

Hey!

I think you should reach to Microsoft Support to get some assistance on this. But before that: Typically, the "contains" operation consumes a lot of time/Resources as this must perform substring searches. I would ask you to:
- make the first search without the "Contains" string part, and only with the Statecode search.

- then, the other way around: only with ONE contains (for example, the FullName) and removing the StatusCode part

The idea is to verify which of those 3 operations (FullName, Email or StatusCode) is taking more time to complete. Once this is identified, then, probably reaching Microsoft to understand if there's any action that can be taken to improve.

Regards,

Was this reply helpful? Yes No