Connecting with Excel
Before starting this procedure, open the Devo web application and go to Administration → Data Management → Api/OData. Identify the Odata feed that you want to link to and select More Info from the feed's ellipsis menu. This opens the Feed 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.
- 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 from Devo and paste it in the URL field of the OData feed 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.