Before starting this procedure, open the Devo web application and go to Administration → Data Management → Api/ODataCredentials → Authentication tokens. Identify the Odata feed that you want to link to (check the Type column in the table) and select More Infoinfo from the feed's ellipsis menu.
This opens the Feed InfoToken info window where you can copy the OData URL of the feed and the necessary authentication credentials. Keep this open for easy access.
...
Learn how to set up an OData feed in Using and managing OData feeds.
| Rw ui steps macro | |||||
|---|---|---|---|---|---|
Open a new Excel worksheet and go to the Data tab, then select Get Data → From Other Sources → From OData Feed.
Copy the feed's OData URL (Feed field) from Devo and paste it in the the URL field of the the OData feed window window. Click OK.
If you selected No authentication when creating the OData feed, you can directly click Connect. If you selected Domain authentication or Standard authentication when creating the OData feed, select Basic and enter your User name and Password, then click Connect. 
A preview of the data is displayed. Select Load. 
The query data will now appear as a table in the Excel worksheet. |