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.
Asked
Active
Viewed 54 times
1 Answers
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