Skip to Content
0
Jun 18 at 03:13 AM

How can I fetch metadata from odata API using request reply in cpi

159 Views

Hello Experts,

Good day,

I am fetching the data from odata API using request reply in XML format.

Is that possible to fetch the metada from odata API using request reply in edmx format that includes property and datatype with fields and values shown below.

If yes please suggest how.

Is there any other way in cpi to take metadata that includes property and datatype with fields and values.

Thanks.

<EntityType Name="Connection_Statistics">

<Key>

<PropertyRef Name="Id" />

</Key>

<Property Name="SocketReadTime" Type="double" Nullable="false" />

<Property Name="MaxSocketReadTime" Type="double" Nullable="false" />

<Property Name="SocketReads" Type="bigint" Nullable="false" />

<Property Name="BytesReceived" Type="bigint" Nullable="false" />

<Property Name="MaxBytesPerSocketRead" Type="bigint" Nullable="false" />

<Property Name="SocketWriteTime" Type="double" Nullable="false" />

<Property Name="MaxSocketWriteTime" Type="double" Nullable="false" />

<Property Name="SocketWrites" Type="bigint" Nullable="false" />

<Property Name="BytesSent" Type="bigint" Nullable="false" />

<Property Name="MaxBytesPerSocketWrite" Type="bigint" Nullable="false" />

<Property Name="TimeToDisposeOfUnreadRows" Type="double" Nullable="false" />

<Property Name="SocketReadsToDisposeUnreadRows" Type="bigint" Nullable="false" />

<Property Name="BytesRecvToDisposeUnreadRows" Type="bigint" Nullable="false" />

<Property Name="IDUCount" Type="bigint" Nullable="false" />

<Property Name="SelectCount" Type="bigint" Nullable="false" />

<Property Name="StoredProcedureCount" Type="bigint" Nullable="false" />

<Property Name="DDLCount" Type="bigint" Nullable="false" />

<Property Name="PacketsReceived" Type="bigint" Nullable="false" />

<Property Name="PacketsSent" Type="bigint" Nullable="false" />

<Property Name="ServerRoundTrips" Type="bigint" Nullable="false" />

<Property Name="SelectRowsRead" Type="bigint" Nullable="false" />

<Property Name="StatementCacheHits" Type="bigint" Nullable="false" />

<Property Name="StatementCacheMisses" Type="bigint" Nullable="false" />

<Property Name="StatementCacheReplaces" Type="bigint" Nullable="false" />

<Property Name="StatementCacheTopHit1" Type="bigint" Nullable="false" />

<Property Name="StatementCacheTopHit2" Type="bigint" Nullable="false" />

<Property Name="StatementCacheTopHit3" Type="bigint" Nullable="false" />

<Property Name="PacketsReceivedPerSocketRead" Type="double" Nullable="false" />

<Property Name="BytesReceivedPerSocketRead" Type="double" Nullable="false" />

<Property Name="PacketsSentPerSocketWrite" Type="double" Nullable="false" />

<Property Name="BytesSentPerSocketWrite" Type="double" Nullable="false" />

<Property Name="PacketsSentPerRoundTrip" Type="double" Nullable="false" />

<Property Name="PacketsReceivedPerRoundTrip" Type="double" Nullable="false" />

<Property Name="BytesSentPerRoundTrip" Type="double" Nullable="false" />

<Property Name="BytesReceivedPerRoundTrip" Type="double" Nullable="false" />

<Property Name="Id" Type="integer" Nullable="false" />

</EntityType>

<EntityType Name="Status">

<Key>

<PropertyRef Name="Id" />

</Key>

<Property Name="ServerVersion" Type="varchar" MaxLength="127" Nullable="false" />

<Property Name="Host" Type="varchar" MaxLength="127" Nullable="false" />

<Property Name="Port" Type="integer" Nullable="false" />

<Property Name="DatabaseName" Type="varchar" MaxLength="127" Nullable="false" />

<Property Name="SessionId" Type="integer" Nullable="false" />

<Property Name="StatisticsEnabled" Type="smallint_as_boolean" Nullable="false" />

<Property Name="Id" Type="integer" Nullable="false" />

</EntityType>

</Schema>