Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Paylocity.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Paylocity, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Paylocity Stored Procedures
| Name | Description |
| CreatePayEntryImportBatch | Create or merge Pay Entry Time Tracking Batch. |
| CreateSchema | Creates a schema definition of a table in Paylocity. |
| GetOAuthAccessToken | Gets an authentication token from Paylocity. |
| MergePayEntryImportBatch | This is used to create or merge a batch when the Pay Entry Import Status is halted at TimeClockValidationPendingAcknowledgement. |
| OnBoardingEmployee | Onboarding API sends employee data into Paylocity Onboarding to help ensure an easy and accurate hiring process for subsequent completion into Web Pay. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Paylocity. |