300
Hi,
I have an entity in a CRM plugin and I need to find any field names that are lookups to a given entity. So I might want to say.. "what are the field names on this entity that are lookups to Contact?". I think this might be possible using the metadata but cannot find a way to do it.
Any pointers on how this might be done would be appreciated.
Thanks,
*This post is locked for comments
It depends on whether you want to use metadata (then what Aric wrote), or whether you want to find all value which are actually referencing Contacts.. In the latter case, you might just go over all the attributes in the post image (or, depending on what it's about, in the Target), check if any of those are entity references, and, for those which are entity references, check the logicalName property. That way you can avoid metadata calls, but it'll only work for populated fields
Not sure if you are planning to use sdk, but you can use the following function to get all attributes, and then check if the attribute type is Lookup:
RetrieveEntityRequest request = new RetrieveEntityRequest()
{
LogicalName = entityName
EntityFilters = EntityFilters.All,
RetrieveAsIfPublished = true
};
RetrieveEntityResponse response = (RetrieveEntityResponse)service.Execute(request);
foreach (AttributeMetadata attr in response.EntityMetadata.Attributes)
{
string logicalName = attr.LogicalName;
string attrType = attr.AttributeType.ToString();
string displayName = attr.DisplayName.LocalizedLabels.Count > 0 ? attr.DisplayName.LocalizedLabels[0].Label : string.Empty;
if (attrType.ToLower() == "lookup")
{
// Your logic here
}
}
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (