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]

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

[Anonymous]

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!

[Anonymous]

bump

[Anonymous]

Did you succeed to make it works ?

[Anonymous]

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

[Anonymous]

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!

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

Hey Sabrina,

I am testing using Open Studio v6.4.1.

Thanks,

[Anonymous]

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