How to get actual values in tmicrosoftcrminput using expand feature?

[rp2018]

How to get the actual value of this field called _ownerid_value?

This is the api output of this field.

{
"MetadataId": "testing",
"ReferencedEntity": "owner",
"ReferencingAttribute": "ownerid",
"ReferencingEntityNavigationPropertyName": "ownerid"
},

Owner entity has a field called name which has the actual name for it.
How do you implement this in tMicrosoftCRMInput.

This I've tried but not working.

[gouravdubey5]

Hello,

1.Use the component’s Expand entity feature:

In Basic settings of tMicrosoftCrmInput, enable Expand entity.

Add the expandable lookup column (the one ending with _value) in the Expandable column list.

2.Specify the fields you want from the related entity

In the OData query option for that expandable column, set the fields you need (e.g., $select=name) so CRM returns actual related values.

You can use $select=* to get all fields from the expanded entity.

3.Map those expanded fields to output schema columns:

Add destination columns in the component schema for the fields you want to see (e.g. “Account Name”, “Owner Name”, etc.).

Expandable columns in CRM usually start and end with underscores, like _ownerid_value. Only these can be expanded.

Without using Expand and specifying related attributes (via $select), you’ll only see the GUID of the lookup, not the actual descriptive value.

Links:https://help.qlik.com/talend/en-US/components/8.0/microsoft-crm/tmicrosoftcrminput

Thanks,

Gourav