How to I get the real value from Dynamics 365 instead of GUID?

Question

I am using Azure Data Factory (ADF) to load data from Dynamics 365 to an Azure Database. However, for some columns I get a GUID value like 8234CCBA-7B01-E211-B551-D48564518CCA instead of the actual value.

Is there a way to retrieve the real data either by using SQL or changing something in Dynamics?

You want to get field value, but got the record guid instead? — Arsen
@adnane you have to load other Foreign Key (GUID) housing tables as well.. then you can INNER JOIN to get the fields like Name and other related fields — Arun Vinoth - MVP
@adnane lets say, you are pulling Contact into Azure DB using ADF. Contact has ParentCustomer as Account GUID. In that case, you have to pull Account table also into Azure DB using ADF.. so the relationships are intact.. make sense? — Arun Vinoth - MVP
@adnane that can be checked in your Dynamics Org schema (Data model) entity relationships.. — Arun Vinoth - MVP

Arun Vinoth - MVP Arun Vinoth - MVP · Accepted Answer · 2021-04-14T17:18:53

Normally we will use web api formatted values or CRM SDK methods to get the display name field of related table (Foreign key) in C# or javascript. In ADF, I don't think you can fetch the formatted values for picklist (Integer key values) or lookup (GUID) attributes.

Instead you can use ADF data flow to fetch the different datasets and join them for these kind of data transformations. Read more

Otherwise, dump all the datasets you need into Azure DB - for transformations later in DB views.

How to I get the real value from Dynamics 365 instead of GUID?

1 Answers