
Announcements
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?
that field is a lookup, I didn't try but maybe grouping the id attribute of the table can work, something like:
$apply=groupby((rwfw_covertype/rwfw_covertypeid)