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";
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.
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.
... 4 more
Solved! Go to Solution.
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 ?
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.
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?
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).
Are you using talend open studio V 6.4.1 or subscription solution?
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.
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.
So far, for tMicrosoftCRMOutput (ODATA), it is unable to update lookup field null.
Does this issue also repro on talend V 6.5?
Here exists a jira issue:https://jira.talendforge.org/browse/TDI-39571
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.