Microsoft Dynamics API - Getting Fields from Entity with Navigation

user_6507010 0
Viewed 545

I am trying to get the field list from an entity, in example contact, I have successfully done it doing a Request to:

EntityDefinitions(LogicalName='contact')/Attributes/Microsoft.Dynamics.CRM.AttributeMetadata

But now I need to get the Navigation Properties defined on this entity, I have found information on how to get Navigation Properties when querying a specific record by id, but in this case I need it when getting the field list.

Thanks in advance for your help

dataverse microsoft-dynamics dynamics-crm
1 Answers

Referring the docs: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-metadata-web-api

You already have the Lookup attributes, AttributeMetadata has everything. If you want to only read the metadata of lookups, change the type to LookupAttributeMetadata.

EntityDefinitions(LogicalName='contact')/Attributes/Microsoft.Dynamics.CRM.LookupAttributeMetadata

To obtain relationships info alongside the columns list then an additional query is required, RelationshipDefinitions:

/RelationshipDefinitions/Microsoft.Dynamics.CRM.OneToManyRelationshipMetadata
/RelationshipDefinitions/Microsoft.Dynamics.CRM.ManyToManyRelationshipMetadata

filter on ReferencedEntity / ReferencingEntity to limit the results
/RelationshipDefinitions/Microsoft.Dynamics.CRM.ManyToManyRelationshipMetadata 

filter on Entity1LogicalName / Entity2LogicalName / IntersectEntityName
user_9990420
Related