Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with ADP.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from ADP, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for ADP Stored Procedures
| Name | Description |
| DeleteEventMessage | The stored procedure that deletes an event notification record from ADP. This stored procedure is used to manage or clear previously processed event messages from the event queue to maintain data integrity. |
| GetEventMessage | The stored procedure that retrieves an event notification record from ADP. This stored procedure is used to access pending or historical event messages for synchronization, monitoring, or audit purposes. |
| GetOAuthAccessToken | Gets an authentication token from ADP. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with ADP. |