For richer and more flexible reporting of Storage Platform data, the OData protocol can be used with Excel or Power BI.
To run OData queries, you will need to have admin credentials for a classic user on the Storage Platform Console.
Writing queries
The primary endpoint to use is:
https://api.pro.redstor.com/api/odata
When writing queries, include your group path. For example:
https://api.pro.redstor.com/api/odata/groups?$filter=contains(grouppath,%27Redstor%20MEA/
YourCompanyName%27)
Note: For information about standard OData query options, such as $select
, $filter
, and $expand
, see Microsoft's knowledge article 301461.
Using OData with Excel
You can run OData queries using Excel 2013 or newer.
1. To run a query, start a new query from an OData feed. How you do this will depend on your version of Excel.
- For Excel 2013, you will need the Power Query add-in when using Excel 2013. Download and install it (either 32-bit or 64-bit) from the Microsoft site here. While in Excel, from the main menu, on the Power Query tab, click on From Other Sources > From OData Feed.
- For Excel 2016, go to the Data tab, then to New Query > From Other Sources > From OData Feed.
- For Microsoft 365 E5, go to Data > Get Data > From Other Sources > From OData Feed.
2. Keep the Basic type selected. Enter your OData query, then click OK.
3. Enter your Storage Platform login credentials as you would in the Console.
4. Click Connect.
Note: You will only be able to connect if you have a classic Console user with the correct permissions. If you are unable to connect, ensure that the root certificate and Storage Platform certificate have been added to your list of Trusted Authorities (see Article 720).
5. You will now see a preview of the data. Click Load to proceed, or Transform Data to customise the query, e.g. by removing columns.
If you click Transform Data, a query will open, which you can then customise.
Once you have made the changes you need, click Close & Load. A spreadsheet containing your data will open.
If you need to check or change the permissions for this data at any time, go to Get Data > Data Source Settings > Permissions.
Using OData with Power BI
If you have Power BI, you can leverage its reporting capabilities as you would with Excel. Do the following:
- From the menu in the Home tab, select Get Data and then select OData Feed.
- Enter the URL for the OData endpoint on the Storage Platform: https://api.pro.redstor.com/api/odata
- Enter your Storage Platform administrative credentials (as you normally would when logging into the Console).
- Select the entities to import. Note that some entities will not be available to Group Administrators and may require top-level access.
- Wait for the import process to complete. The data can now be used by Power BI.
Unit notation
We present data in bytes, not bits.
1024 bytes = 1 kilobyte
1024 kilobytes = 1 megabyte
1024 megabytes = 1 gigabyte
1024 gigabytes = 1 terabyte
As an example:
Protected size: 296487775563 bytes.
2.96488E+11 | bytes |
289538843.3 | kilobytes |
282752.7767 | megabytes |
276.1257585 | gigabytes |
0.269654061 | terabytes |
Comments
0 comments
Please sign in to leave a comment.