cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Integartion
Level: Powered On

How relationship work in CDS for custom entities using alternate keys

How relation of standard entity like product in CRM will work in CDS.

Becuase the primary key in CRM is a Guid field and we are passing ItemId from AX which is a String feild and that works perfectly..

 

But when i create same relation and passing value from AX . An Error is occured of type mismatch.

How i can assign the alternate key for that perticular relation.

 

Can you please help ? 

2 REPLIES 2
Community Support Team
Community Support Team

Re: How relationship work in CDS for custom entities using alternate keys

Hi @Integartion ,

 

I didn't see any error shown in your screenshot, can you please share more related details about the error and the configuration?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Integartion
Level: Powered On

Re: How relationship work in CDS for custom entities using alternate keys

Hi ,

 

Below are some details of the issue : 

 

1. In D365 FO we are passing ContributionId which is a string feild but in CRM it requires Guid feild for lookup. You can refer the attached error screen shot with highlighted value.

2. We need to implement this same as Product Id which we are sending as a string from FO side and they are converting it as a Guid and inserting the records in CRM.

 

Note : How we can implement the reference relationship in CDS where FO will send string and CRM will take that reference in Mastertable and pick primary key of it which is a Guid feild in CRM ?

 

Hope you understand my issue , if not then please share your email id , i can show you the issue.

 

my official id  : sksa@columbusglobal.com

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,300)