Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Klaviyo.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Klaviyo, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Klaviyo Stored Procedures
| Name | Description |
| CloneCampaign | Clones an existing campaign and returns the new campaign record with a unique identifier and name. |
| CreateSchema | Generates a local schema file for the specified table or view, reflecting its current metadata definition. |
| GetCampaignRecipientEstimation | Returns an estimated recipient count for a specified campaign based on current targeting rules and filters. |
| GetOAuthAccessToken | Gets an authentication token from Klaviyo. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Klaviyo. |
| RequestProfileDeletion | Requests deletion of one or more profiles based on Identifiers such as email, phone number, or profile Id. |
| UploadImage | Uploads an image to the Klaviyo account and returns metadata including the file URL and Id. |