BitaBIZ have 4 PowerBI routes (URLs), each route produces a CSV output that can be joined in PowerBI or open separately in Excel:

  • Employees
  • EmployeeHistory
  • Registrations/ALL EMPLOYEES
  • Registrations/SINGLE EMPLOYEE

Employees

Get employees and their BitaBIZ employee data, including name, phone number, date of employment, salary agreement, department and many other fields.

https://registrations.api.bitabiz.com/pbi/{APIKEY}/employees

Gets employees and their data + salary agreement data. 

PARAMETERS
Inactive (default false)
if inactive=TRUE inactive employees are also shown


Employees / History

Gets the last two vacation years for each employee in your company. Returns fields for Vacation, manual vacation adjutment plus other vacation and adjustments.

https://registrations.api.bitabiz.com/pbi/{APIKEY}/employees/history

Registrations

https://registrations.api.bitabiz.com/pbi/{APIKEY}/registrations

Gets all registrations in a period and splits them into a single day events.

PARAMETERS
from=YYYY-mm-DD  or  literal from=lastXXmonths (last12months)
to=YYYY-mm-DD 


Registrations for a single employee

https://registrations.api.bitabiz.com/pbi/{APIKEY}/registrations/{EMPLOYEEGUID}

Same parameters and output as /Registrations

Did this answer your question?