Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / lookup field how to li...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by Leonardo Rocha 5

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. 

  • Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    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 Profile Picture
    Wahaj Rashid 11,319 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans