Informatica Cloud has recently released new connector for integration with Dynamics 365 named Dynamics 365 for Sales Connector, which uses Web API of Dynamics 365.
Below is how we specify the details of the connection –
Because of lack of documentation for the new connector, while trying to insert a record inside CRM and trying to setup a lookup field we struggled a lot.
Eventually, we realized the format that is required for setting the lookup field.
EntitySetName:(GUID)
i.e.
sab_fash_categories(72e0b837-e060-4a5c-b831-0e8266dd9a56)
Here sab_fash_categories is the EntitySetName of the custom entity sab_fash_item and it is being used as a lookup in another entity.
For the older version of the connector that used OrganizationService, the documentation is available which specifies the following format for the lookups
{SchemaName:GUID} i.e. the way we specify while setting EntityReference field
Hope it helps..
Discover more from Nishant Rana's Weblog
Subscribe to get the latest posts sent to your email.
Share It -
Nishant Rana's Weblog 
hi can you please provide sample for more details i am also facing same issue but with same syntax its not workinf for me
LikeLike
Hi
How to insert records for N:N relationship in informatica cloud bulk data load
LikeLike