Skip to Content
avatar image
Former Member

Possible to get richer metadata from Odata service $metadata endpoint

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers