cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamics 365 - Header - Include OData Annotations

The Dynamics 365 Get Record operation doesn't seem to have the capability to specify "odata.include-annotations" in the header. This is normally set to odata.include-annotations="*". For datatypes like EntityReference and OptionSet, not including this header means that the underlying text behind the Guid or Integer cannot be seen, as there is no formatted value on the response.

 

With odata.include-annotations header

{
	@odata.context: "https://crmonline.crm6.dynamics.com/api/data/v8.2/$metadata#accounts(_modifiedby_value)",
	@Microsoft.Dynamics.CRM.totalrecordcount: -1,
	@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded: false,
	value: [0: {
		@odata.etag: "W/"4106932"",
		_modifiedby_value@OData.Community.Display.V1.FormattedValue: "Max Power",
		_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname: "systemuser",
		_modifiedby_value: "edf0b0bf-8949-4f09-9d5e-a41b8c31de00",
		accountid: "55ee1933-35ad-e711-a842-000d3ad0ed15"
	}]
}

Without odata.include-annotations header

{
	"@odata.context": "https://crmonline.crm6.dynamics.com/api/data/v8.2/$metadata#accounts(_modifiedby_value)",
	"value": [{
		"@odata.etag": "W/\"4106932\"",
		"_modifiedby_value": "edf0b0bf-8949-4f09-9d5e-a41b8c31de00",
		"accountid": "55ee1933-35ad-e711-a842-000d3ad0ed15"
	}],
}
Status: New
Comments
Level: Powered On

@rajyraman  -  Don't we have solution for this yet ?

Level: Power Up

@Praveenpk365 you can use the HTTP with Azure AD connector's Invoke an HTTP request action to retrieve formatted values as a work around for now.

 

https://ryanjames.dev/blog/2019/09/12/retrieving-formatted-values-from-d365-cds-with-microsoft-flow