topic Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata)) in Talend Studio

tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 26 Jul 2017 19:09:20 GMT

Hey all,

Using Talend 6.4 - having an issue with the tMicrosoftCRMOutput component to update a lookup. Currently using ONLINE the v2016(odata) API version.

The job is simple: tMicrosoftCRMInput to get the record, tJavaRow to update the field, tMicrosoftCRMOutput to update.

tJavaRow: output_row._tcg_lookup_value = "C48DDB1B-C531-E711-80FB-E0071B66CFA1";

tMicrosoftCRMOutput:

Error:

Exception in component tMicrosoftCrmOutput_1 (TCG_Dynamics365_Testing)

org.apache.olingo.client.api.http.HttpClientException: org.apache.olingo.client.api.http.HttpClientException: A property '_tcg_lookup_value' which only has property annotations in the payload but no property value is declared to be of type 'Edm.Guid'. In OData, only navigation properties and named streams can be represented as properties without values.

at org.talend.ms.crm.odata.DynamicsCRMClient.createAndExecuteRequest(DynamicsCRMClient.java:408)

at org.talend.ms.crm.odata.DynamicsCRMClient.updateEntity(DynamicsCRMClient.java:248)

at local_project.tcg_dynamics365_testing_0_1.TCG_Dynamics365_Testing.tMicrosoftCrmInput_1Process(TCG_Dynamics365_Testing.java:1554)

at local_project.tcg_dynamics365_testing_0_1.TCG_Dynamics365_Testing.runJobInTOS(TCG_Dynamics365_Testing.java:1921)

at local_project.tcg_dynamics365_testing_0_1.TCG_Dynamics365_Testing.main(TCG_Dynamics365_Testing.java:1770)

Caused by: org.apache.olingo.client.api.http.HttpClientException: A property '_tcg_lookup_value' which only has property annotations in the payload but no property value is declared to be of type 'Edm.Guid'. In OData, only navigation properties and named streams can be represented as properties without values.

at org.talend.ms.crm.odata.DynamicsCRMClient.createAndExecuteRequest(DynamicsCRMClient.java:405)

... 4 more

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Thu, 03 Aug 2017 08:44:02 GMT

Hello,

Are you using V 2016(odata) with "ONLINE" authentication type in basic settings of tMicrosoftCRMOutPut component?

Have you already checked online component reference about:TalendHelpCenter:tMicrosoftCrmOutput ?

Best regards

Sabrina

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Fri, 04 Aug 2017 16:30:23 GMT

Hi xdsi,

Yes it is - I've updated my post to reflect this.

I have looked at the documentation but wasn't able to get it to work.

Thanks!

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Mon, 14 Aug 2017 16:48:23 GMT

bump

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 23 Aug 2017 09:01:21 GMT

Did you succeed to make it works ?

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 13 Sep 2017 05:00:49 GMT

Hello,

Sorry for delay!

Here is a jira issue:https://jira.talendforge.org/browse/TDI-38648

Could you please take a look at it to see if it is what you are looking for?

Best regards

Sabrina

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 13 Sep 2017 13:32:32 GMT

Hey @xdshi,

I don't think it is, the error log doesn't say anything about a guid. And that error you provided seems to have been resolved in 6.4.1 (which is the version I am using).

Thanks!

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Thu, 14 Sep 2017 03:42:44 GMT

Hello,

Are you using talend open studio V 6.4.1 or subscription solution?

Best regards

Sabrina

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Mon, 18 Sep 2017 13:41:39 GMT

Hey Sabrina,

I am testing using Open Studio v6.4.1.

Thanks,

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Tue, 19 Sep 2017 08:56:38 GMT

Hello,

Could you please read this thread:https://community.dynamics.com/crm/f/117/t/203648 to see if the solution works for you?

Don't hesitate to post your issue here.

Best regards

Sabrina

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Fri, 29 Sep 2017 21:11:47 GMT

Hi Sabrina,

Appreciate the help, I don't think this is the correct item. I believe this requires me to be able to update the actual code-behind, when it should be taken care of in the component provided from talend.

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 29 Nov 2017 16:03:47 GMT

bump

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Mon, 18 Dec 2017 21:20:23 GMT

bump

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Tue, 06 Mar 2018 14:22:35 GMT

bump

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 14 Mar 2018 02:15:06 GMT

Hello,

So far, for tMicrosoftCRMOutput (ODATA), it is unable to update lookup field null.

Does this issue also repro on talend V 6.5?

Best regards

Sabrina

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 14 Mar 2018 02:16:42 GMT

Hello,

Here exists a jira issue:https://jira.talendforge.org/browse/TDI-39571

Best regards

Sabrina

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Wed, 14 Mar 2018 14:36:17 GMT

Hi Sabrina,

Appreciate you following up, I was able to update a lookup value in 6.5.1.

Thanks,

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

Anonymous — Thu, 15 Mar 2018 12:15:24 GMT

Just as an FYI this wasn't the issue (https://jira.talendforge.org/browse/TDI-39571) because we weren't updating a lookup to null. There was a value - it just didn't update.

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

MohleySingh — Wed, 27 Mar 2019 08:34:46 GMT

Hi,

Could you please elaborate what you did to fix this issue.

I am using TIC and my studio is version: 7.1.1 but still getting this error.

As per my requirement I am inserting new contacts in contacts entity and trying to assign value to _parentcustomerid_value

and getting the below error:

Exception in component tMicrosoftCrmOutput_1 (TestOAuth2)
org.apache.olingo.client.api.http.HttpClientException: org.apache.olingo.client.api.http.HttpClientException: An error occurred while validating input parameters: Microsoft.OData.ODataException: An undeclared property 'parentcustomerid' which only has property annotations in the payload but no property value was found in the payload. In OData, only declared navigation properties and declared named streams can be represented as properties without values.

Thank you in advance !

Re: tMicrosoftCRMOutput - Updating a lookup (using v2016(odata))

plikhi — Sat, 16 May 2020 13:06:45 GMT

Can someone help to provide solution for the same as I am also getting this error and we are stuck in our Talend migration.