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