Skip to Content
0

Possible to get richer metadata from Odata service $metadata endpoint

Mar 09, 2017 at 07:52 AM

23

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers