Customer experience | Sales, Customer Insights,...

Which name to be used to update a custom entity with lookup field

(0) Share

Report

Posted on by User KS

Hi,

I would like to know what to send in request for lookup field for inserting an entity to Microsoft CRM.

If I post a request to http://<server url>/api/data/v9.1/new_my_activities

with body

{"new_id":"abc-def","new_my_opportunityID@odata.bind":"/opportunities(2b685c81-4f1c-e511-80d3-3863bb347ba8)"}

Here new_my_opportunityID is my schema name for lookup entity, what I would like to confirm is do we use schema name, logical name or Navigation property name here?

SchemaName worked for me but some where it was suggested to use navigation property?

Could someone please confirm which name is used in rest request for lookup field?

All responses (4)

Answers (0)

User KS 45 on at

Like (0)

Report

RE: Which name to be used to update a custom entity with lookup field

When you go to customization->developer resources->download ODataV4Metadata you will get an xml with something like below for the attribute:

<NavigationProperty Name="new_my_opportunityID" Type="mscrm.opportunity" Nullable="false" Partner="new_opportunity_new_my_activity_my_opportunityID"><ReferentialConstraint Property="_new_my_opportunityid_value" ReferencedProperty="opportunityid" /></NavigationProperty>
Suggested answer

chris xu on at

Like (0)

Report

RE: Which name to be used to update a custom entity with lookup field

Below is a sample screenshot of one lookup type field, I did not find the mentioned navigation property name - could you please share your screenshot if required and applicable?
User KS 45 on at

Like (0)

Report

RE: Which name to be used to update a custom entity with lookup field

When we check the metadata for our account we can go to the attribute which is lookup field. There we have a navigation property name.
Suggested answer

chris xu on at

Like (0)

Report

RE: Which name to be used to update a custom entity with lookup field

Hi User -

Using the schemename works in your scenario.

what does "navigation property" mean here?

Community site session details

Which name to be used to update a custom entity with lookup field

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Which name to be used to update a custom entity with lookup field

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates