Column alias in Xrm.WebApi.retrieveRecord

(0) Share

Report

Posted on by Rutu01

305

Is it possible to have an alias for the columns retrieved in Xrm.WebApi.retrieveRecord ?

This syntax isn't working

Xrm.WebApi.retrieveRecord("jg_tdssection", tdsSectionId, "?$select=jg_rateforindividuals as jg_tdsrate");

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Shashank Bhide 942 Moderator on at

Like (1)

Report

that's more an OData query than a Dataverse query and OData committee doesn't support column aliasing yet AFAIK.

https://stackoverflow.com/questions/20666056/alias-in-odata-select-statement

Was this reply helpful? Yes No
Rutu01 305 on at

Like (0)

Report
According to the docs here https://devblogs.microsoft.com/odata/compute-and-search-in-asp-net-core-odata-8/
this should work :
GET http://localhost:5102/odata/products?$compute=Price mul Qty as TotalPrice&$select=TotalPrice
but it didn't for me
?$compute=jg_ratefornonindividuals mul 1 as tdsrate & $select=tdsrate
I'm getting this error : The query parameter [REDACTED] is not supported

Was this reply helpful? Yes No
Verified answer

Shashank Bhide 942 Moderator on at

Like (1)

Report
that link is from ASP.NET core's OData implementation, different implementers may choose to implement different features, but for Dataverse I didn't see any online documentation which suggests it's available.

using fetchXML though aliasing is supported.
string fetchXml = @"<fetch top='3'> <entity name='account'> <attribute name='accountclassificationcode' alias='code' /> <attribute name='createdby' alias='whocreated' /> <attribute name='createdon' alias='whencreated' /> <attribute name='name' alias='companyname' /> </entity> </fetch>";

Was this reply helpful? Yes No
Rutu01 305 on at

Like (0)

Report

I couldn't find any information about alias being supported here https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api so perhaps it's not

Was this reply helpful? Yes No