There are For Office 365 Excel Version 16.70 (For previous versions of Excel for Mac click here)
-Open a blank workbook
-Click Data and then Get Data (Power Query)
...
-In the popup screen, click on OData
...
-Enter the URL: https://api.buzmanager.com/reports/YOUR-ORGANISATION-CODE
-Change the Connection Credentials to Basic and enter your BUZ username and password
...
-Follow instructions from step 5 onwards on page Excel Reporting using OData to edit the query
...
| Anchor | ||||
|---|---|---|---|---|
|
Some older versions of Excel for Mac may not be supported. Please follow instructions below if you are not using Office 365 Version 16.70
There is no ability to query the data at this stage in Excel on OSX, however, Excel allows you to open and refresh spreadsheets previously created in Excel for Windows.
You however need to make sure the connection in the spreadsheet is using the correct BUZ credentials.
To do this, perform the following:
Open the Spreadsheet
Click on the Enable Content button.
...
Click on the Data tab
Click Get Data option
Choose Data Source Settings
...
Select the Api API option and click on the Clear Permissions.
...
Click Delete
...
Repeat Clear Permissions routine for each query in the spreadsheet.
Click on the Refresh option
...
Click on the Authentication kind drop-down
Choose Basic from the list
...
Enter your BUZ username and password and click Connect
...
If you are successful, you will see Running background query
...