This is an automated archive.

The original was posted on /r/opensource by /u/buddhabanter on 2023-08-12 15:26:23+00:00.

I use an online payroll software that is an API first product, but it has limited reports in comparison to my needs. It also doesn’t have an inbuilt report writer. I’m looking for something that I can connect to build my own reports for extracting data, but most report writers I have seen are more for analytics and dashboards, rather than data extraction to excel (for example).

As an example, I’d like to be able to extract a list of absences for employees that have a count of absences over 3 in the last 12 months. I don’t have access to the backend database for the software (if I did, I could just write a sql query) so instead I have to interact with the API to extract all information and then do the filtering myself to put into the report.

Are there any tools that anyone would recommend?