Can Dynamics Web Api be used to retrieve accounts by field instead of GUID?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Is it possible to use the Dynamics Web Api to retrieve accounts/contacts using field values instead of GUID?

This throws a bad request error: https://mydomain.crm9.dynamics.com/api/data/v8.0/accounts(name='My Account Name')

 "code":"","message":"Bad Request - Error in query syntax.","innererror":{
      "message":"Bad Request - Error in query syntax.","type":"Microsoft.OData.Core.ODataException","stacktrace":"   at

Thanks in advance,

Categories:

Customization / Solutions / SDK and API

All responses (2)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Can Dynamics Web Api be used to retrieve accounts by field instead of GUID?

Thank you so much. This worked perfectly.
Verified answer

Krystian Witoszkin on at

Like (0)

Report

RE: Can Dynamics Web Api be used to retrieve accounts by field instead of GUID?

You can use request like below, for example for searching account with 'New Client' name:

https://<domain>.crm.dynamics.com/api/data/v9.0/accounts?$select=name&$filter=name eq 'New Client'

If the name field is unique, you will get one record, if not - in response you will get more than one record.

Look here for more details: docs.microsoft.com/.../query-data-web-api