Excel API reports
Click: HR Statistics -> Reports
(This is where the report library is located)
How to get the pre-configured Excel reports in real-time data?
Copy your API key.
Download the chosen Excel report.
Please note that the Excel reports use macros. If your Excel is not set up to allow macros, then you must do the following before opening the Excel file.
Open Windows File Explorer and go to the folder where you saved the file.
Right click the file and select Proberties in the menu.
In the last section under the General tab select the Unblock check box and click OK
3. Open the downloaded Excel report.
1. Insert the API key to the API key box
2. Click the update button.
When you click "Update" Excel will post the message below.
Click "Ignore" and then "Save".
Don't have access to the API key?
You need an HR Statistics role to access the report library.
You need to activate the API key from the Setup Admin role.
It is required that the API key is activated.
Click: Setup Admin -> Company -> Subscription plan -> Statistics & Reports:
When the API key is activated the key is available from:
HR Statistics -> "Report library".