Microsoft Dynamics 365 | Integration, Dataverse...

lookup field how to list key and value from Dynamics web API

(0) Share

Report

Posted on by Leonardo Rocha

Hi.

I am working on a new integration with CRM and I need to get lookup fields (key and value) from CRM using Dynamic 365 API: dynamics.com/api/data/v9.0/[resource] I need to know the description of a specific lookup.

All responses (2)

Answers (0)

Wahaj Rashid 11,321 on at

Like (0)

Report

RE: lookup field how to list key and value from Dynamics web API

Is this issue resolved?

If yes, please mark the appropriate answer as verified (Click 'Yes' under 'Did this answer your question?').
Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report
RE: lookup field how to list key and value from Dynamics web API

Hi,

Thank you for your query.

Lookups are references to an entity (N:1 relationship).

There is no specific end-point that provides a list of lookup as key-value pairs. You need to point to entity dataset name to get the list.

For example, we have 3 lookups on an entity:

Account

Primary Contact

Category (custom entity)

To get these you have the following approaches:

Get the list of Accounts/Contacts with only the ID/Name attribute and convert this to a list of a key-value pair in your code. To get this data, just use endpoint with lookup dataset name, for example:

dynamics.com/api/data/v9.0/accounts$select=name

dynamics.com/api/data/v9.0/contacts$select=name

dynamics.com/api/data/v9.0/new_categories$select=name

You can also use expand to get the data from the lookup entity (along with the current record):

Getting Lookup Fields from Dynamics 365 Web API URL - Carl de Souza