topic Re: tMicrosoftCRMOutput update lookup field in Talend Studio

tMicrosoftCRMOutput update lookup field

Passaia — Wed, 30 May 2018 07:09:54 GMT

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.

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

Please help me!
Max

Re: tMicrosoftCRMOutput update lookup field

MohleySingh — Wed, 27 Mar 2019 11:19:17 GMT

Hi Max,

Did you manage to find a solution for this ?

Re: tMicrosoftCRMOutput update lookup field

Passaia — Wed, 27 Mar 2019 16:26:41 GMT

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

Re: tMicrosoftCRMOutput update lookup field

MohleySingh — Sun, 31 Mar 2019 23:43:50 GMT

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