tMicrosoftCRMOutput update lookup field

Five Stars

tMicrosoftCRMOutput update lookup field

Hello,
I can not update a lookup custom field of contact entity.
I try to add the suffix "@odata.bind" in DBColumn as recommended, but it still does not work.
It does not give me error but does not set anything, as if the mapping is wrong.

Image1.jpg

I try to set an xml string in the field, but it still does not work:

 

Image2.jpg

 

Please help me!
Max

Four Stars

Re: tMicrosoftCRMOutput update lookup field

Hi Max,

Did you manage to find a solution for this ?

Five Stars

Re: tMicrosoftCRMOutput update lookup field

Yes, I had to download oData metadata (CRM > Setting > Customization > Developer Resource --> Download OData MetaData) and search the NavigationProperty tag.

 

The value found at ReferentialConstraint Property must be used in mapping at "DB Column" field.

 

Hope this will help.

Max

Four Stars

Re: tMicrosoftCRMOutput update lookup field

Thank you Passaia - ReferentialConstraint did not work but I was able to get it work with partner value under navigation propert "parentcustomerid_account" 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads