topic Re: How to extract Lookup,User,Customer,Owner and Virtual columns from Dynamics 365 CRM? in Talend Studio

How to extract Lookup,User,Customer,Owner and Virtual columns from Dynamics 365 CRM?

rp2018 — Wed, 16 Oct 2019 15:01:00 GMT

We are using tMicrosoftcrmInput component to extract data from Dynamics 365 CRM and encountering property not found. Columns do exist but the types are Lookup, User, Customer, Owner and Virtual which are causing this issue. Entities we are trying to pull from are Account and Opportunity which are not custom entities. Using Authentication Type (Online) and API Version (v2016(odata)).

Re: How to extract Lookup,User,Customer,Owner and Virtual columns from Dynamics 365 CRM?

rp2018 — Wed, 30 Oct 2019 14:39:20 GMT

To extract Lookup,User,Customer,Owner and Virtual columns:

Use component tMicrosoftCrmInput, select Authentication Type: Online,

Api Version: V2011 and provide all of the connection information to connect to your CRM environment.

NOTE: Set datatype to string for these fields when extracting.

Re: How to extract Lookup,User,Customer,Owner and Virtual columns from Dynamics 365 CRM?

Anonymous — Thu, 31 Oct 2019 09:04:39 GMT

Hello,

Thanks for sharing your solution with us and set this thread as solved.

Best regards

Sabrina

Re: How to extract Lookup,User,Customer,Owner and Virtual columns from Dynamics 365 CRM?

vishalg19 — Tue, 11 Aug 2020 04:32:05 GMT

Hello

I am using Online v2018 Web App with delegated permission.

I am not able to pull lookup column its showing all as Null

msdn_accountmnager

while _mysdn_accountmanager_value gives me Guid. I have to use other entity to get Name of account manager

Is there any way we can pull Lookup column name directly without using other entity.