3

How can I retrieve the salary per individual component and employee using the ado.net provider of Invantive SQL for use within Microsoft Power BI?

I seem unable to find a XML or REST-based table that contains the amounts.

KPI Solutions
  • 33
  • 3
  • What field(s) are these values stored in? – music2myear Feb 08 '17 at 00:21
  • @music2myear We can't know that since we don't have access to the internal database servers behind the Exact Online app. Salary components is a part of the Exact Online user interface though (under Employees > Components). – Patrick Hofman Feb 08 '17 at 08:41
  • Then I would recommend contacting the Exact Online folks. They will know if that information is extractable and how to do it. – music2myear Feb 08 '17 at 17:43

1 Answers1

0

It doesn't seem possible to extract salary information on that level. The REST API has no support at all for salary components, and all Payroll endpoints are GET only, so you can't insert or update that data.

The XML Export functionality and the XML API have some support for salary components, but only on the general level above employees. There is no endpoint to get the data from salary components by employee.

That said, there seems to be no way to get the information you want at this time: not via de user interface (XML export) nor using the APIs.

Patrick Hofman
  • 594
  • 4
  • 17