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

[plikhi]

Can you please help to understand what changes you did. I am facing similar issue.