BitaBIZ offers 4 PowerBI routes (URLs) to retrieve your data, each route produces a CSV output that can be joined in PowerBI or open in Excel:

  • Employees
  • Employees/History
  • Employees/NationalHolidays
  • Registrations


Employees

Get employees and their BitaBIZ employee data, including name, phone number, date of employment, salary agreement, department and many other columns. See a list of all columns

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

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, other vacation and adjustments and timebank. See a list of all columns

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


Employees / NationalHolidays

Retrieve National holidays per employee and period. We also sum the national holidays up. See a list of all columns

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

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


Registrations

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

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

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

Fandt du dit svar?