I am trying to use the web API to query a (virtual SQL) table with a grouping by a lookup column as:
$apply=groupby((_rwfw_covertype_value),aggregate(rwfw_tiv with sum as total))&
$select=_rwfw_covertype_value,rwfw_tiv&$filter=_rwfw_covertype_value eq d6df9b7f-15d8-ed11-a7c6-6045bdd1d501
However I get an error:
'rwfw_Exposures' entity doesn't contain attribute with Name = '_rwfw_covertype_value' and NameMapping = 'Platform'
It works fine if I select those columns, they just do not work in the apply clause. Is it possible?

Report
All responses (
Answers (