Excel OData Connector
Last updated on 22-Feb-2021 by Jakob Jakobsen Boysen
Scifeon offers an OData interface for interacting with data from Scifeon in other applications, e.g. Excel. A few steps is needed in order to retrieve data from Scifeon in Excel:
Step 1
Select Data > Get Data > From Other Soruces > From OData Feed:
Step 2
Enter the Scifeon OData URL for your company, e.g. https://your-company.scifeon.cloud/odata
Step 3
In the next window, select "Basic" on the left, and enter your username and password for Scifeon and click "Connect":
Step 4
Click "Connect" and see the following Navigator pane, where all kinds of data can be found. Find the relevant data, select it, and click "Load":
Step 5
After you've clicked "Load" you will see a new sheet in the Excel workbook containing the data from Scifeon:
