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?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

chris xu on at

Like (0)

Report

Hi User -

Using the schemename works in your scenario.

what does "navigation property" mean here?

Was this reply helpful? Yes No
User KS 45 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

chris xu on at

Like (0)

Report

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?

Was this reply helpful? Yes No
User KS 45 on at

Like (0)

Report

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>

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates