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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

bump

[Anonymous]

bump

[Anonymous]

bump

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous · Accepted solution]

Hi Sabrina,

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

Thanks,

[Anonymous]

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.

[MohleySingh]

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 !

[plikhi]

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