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.
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:
- OData Link: copy the OData URL link for the item.
- OData Link without Filters: copy the OData URL link for the item, excluding filters.
The link is then copied to the clipboard, and can be opened in other applications.
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.