Five Stars

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

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:

Schema_of_tMicrosoftCrmOutput_1_2017-07-26_14-03-37.pngTalend_Open_Studio_for_Data_Integration_(6.4.1.201_2017-07-26_14-02-42.png

 

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

 

  • Data Integration
3 REPLIES
Moderator

Re: tMicrosoftCRMOutput - Updating a lookup

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: tMicrosoftCRMOutput - Updating a lookup

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!

Five Stars

Re: tMicrosoftCRMOutput - Updating a lookup

bump