on 03-09-2017 7:52 AM - last edited on 02-03-2024 10:25 PM by postmig_api_4
I have a calculated view that I've made available as an odata service using the following:
service {
"dev.views::CV_ORDERS" as "Orders"
key ("ORDER_ID")
create forbidden
update forbidden
delete forbidden;
}
The referenced view contains both attributes and measures along with user friendly labels for each of the columns. I'm able to pull up the metadata of the view via the $metadata endpoint in the odata service but it only returns basic properties like the column names and datatypes:
...
...
<EntityType Name="OrdersType">
<Key>
<PropertyRef Name="ORDER_ID"/>
</Key>
<Property Name="ORDER_ID" Type="Edm.String" Nullable="false">
<Property Name="SOME_ATTR1" Type="Edm.String" MaxLength="100"/>
<Property Name="SOME_ATTR2" Type="Edm.String" MaxLength="12"/>
<Property Name="SOME_ATTR3" Type="Edm.Int16"/>
<Property Name="SOME_MEASURE" Type="Edm.Int32"/>
</EntityType>
...
...
Is there a way to get at the additional properties of the view such as if a column is marked as an attribute or measure and also the user friendly labels I have defined on the view?
I found a way to get that data by querying directly against the sys_bi tables but am hoping I can get at them directly via odata.
Any suggestions or help would be greatly appreciated.
Thanks!
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.