tMicrosoftCrmOutput - Assign values to EntityName, Object, Owner DB type object in TMap

Anonymous — Sat, 16 Nov 2024 09:38:07 GMT

I'm doing a PoC for loading data from csv file to Ms Dynamics CRM -

Microsoft uses GUID as identity key - I have run into issues in inserting the records into CRM when I assigning looked up value to columns such as ( ownerid , transactioncurrencyid, createdby)

When I assign the GUIID and process the record the adaptor fails with an unkown error - I tried formatting the cols in Jason format with ID attribute but did not work - tried formatting the string value in jason format with ID, logicalName, and name - this also did not work -

I'm able to read data from CRM tables and able to insert simple data types and picklist type cols ...but not for db types of object, entityname or cols that has uniqueidentifier

Tried searching on the net but no docs -

Any guidance will be greatly appreciated

Using - Talend 6.3 & 6.4 - CRM ver.2014

Re: tMicrosoftCrmOutput - Assign values to EntityName, Object, Owner DB type object in TMap

Anonymous — Mon, 24 Jul 2017 07:19:00 GMT

Hello,

Screenshots of your job setting will be preferred.

Best regards

Sabrina

topic tMicrosoftCrmOutput - Assign values to EntityName, Object, Owner DB type object in TMap in Talend Studio

tMicrosoftCrmOutput - Assign values to EntityName, Object, Owner DB type object in TMap

Re: tMicrosoftCrmOutput - Assign values to EntityName, Object, Owner DB type object in TMap