News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... RETRIEVING LOOKUP FIEL...

Customer experience | Sales, Customer Insights,...

Suggested answer

RETRIEVING LOOKUP FIELD FROM DYNAMICS 365 TO WEB API

(0) Share

Report

Report

Posted on by Vamsi@Popcornapps

In dynamics, both Actor(Practitioner) and currency are lookup fields in Appointment (EMR) entity... So I am retrieving currency field in Postman API but I am not able to retrieve Actor(Practitioner data) .. but why some lookup fields are not retrieving to WEB API.

Thanks in Advance.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

SamiraM 571 on at

Like (0)

Report

RE: RETRIEVING LOOKUP FIELD FROM DYNAMICS 365 TO WEB API

Hi,

try like below

$select=_msemr_actorpractitioner_value

Regards

Samira
Suggested answer

Emily Zhang on at

Like (0)

Report

RE: RETRIEVING LOOKUP FIELD FROM DYNAMICS 365 TO WEB API

Same issue as https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/382917/expanding-odata-using-expand-query-on-a-lookup-field-custom-is-not-working-for-the-custom-entity

Can you please try suggestion in this blog? Also, based on document, lookup field cannot be retrieved using $select. Please try build query ref this document:

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/query-data-web-api#bkmk_lookupProperty

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans