OData Feed

The OData feed function allows users to capture a special URL that allows them to read in the result set of the item's query into another client technology that consumes data. This, in effect, turns Pyramid into a data source - and should not be confused with the OData source option in Model, where Pyramid can consume other OData feeds.

Note: The OData Feed capability requires separate licensing.

Accessing the OData Feed URL

The OData function can be triggered from using the quick action buttons on the Action Panel for relevant items (green circle below).

Alternatively it can also be accessed from an item's tab menu in the App Tab Interface (purple highlight below). There are 2 options for copying the OData link from Discover:

In addition, you can copy the OData URL link for any content in a live presentation, to use in any other OData compliant tools. Simply right-click on the content and select OData Link. Depending on whether you are displaying the new Context Menu, this link might be under Content Details:

The link is then copied to the clipboard, and can be opened in other applications.

ClosedExample: Using The OData Feed in Excel

To use Pyramid data inside another tool, like Excel, click the OData button. This will put the special URL into your clipboard's copy/paste memory.

Next, switch to Excel, and open a new worksheet. Go to the Data Tab, choose "Get Data" and then choose "From OData Feed" (orange arrow below).

In the pop-up dialog, paste the URL into the box (CTRL+V). Then Click OK.

You will likely be prompted to supply your user credentials to login to Pyramid to access the data source. Enter those as well.

You will then be prompted with a preview of the result set. Click Load to import the data.

Once imported, use the data as needed. At any time, right click on the table to refresh the data and re-pull updated results from Pyramid.