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

 

10 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
Four Stars

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

Did you succeed to make it works ?
Moderator

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

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

--
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 (using v2016(odata))

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!

Moderator

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

Hello,

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

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 (using v2016(odata))

Hey Sabrina,

I am testing using Open Studio v6.4.1.

Thanks,
Moderator

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

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

--
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 (using v2016(odata))

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.