Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sabrina,
Appreciate you following up, I was able to update a lookup value in 6.5.1.
Thanks,
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
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!
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
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!
Hello,
Are you using talend open studio V 6.4.1 or subscription solution?
Best regards
Sabrina
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