Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT/INSERT/UPDATE/DELETE 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 Python Connector for Paylocity Stored Procedures
| Name | Description |
| CreatePayEntryImportBatch | Create or merge Pay Entry Time Tracking Batch. The CreatePayEntryImportBatch stored procedure requires the Pay Entry API. To query this stored procedure, the UsePayEntryAPI connection property must be set to true. |
| CreateSchema | Creates a schema definition of a table in Paylocity. |
| GetEmployeePunchDetails | Get employee punch details. The GetEmployeePunchDetails stored procedure requires the Pay Entry API. To use this stored procedure, the UsePayEntryAPI connection property must be set to true. |
| 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. The MergePayEntryImportBatch stored procedure requires the Pay Entry API. To query this stored procedure, the UsePayEntryAPI connection property must be set to true. |
| 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. |