Tables
The component models the data in Klaviyo as a list of tables in a relational database that can be queried using standard SQL statements.
CData SSIS Components for Klaviyo Tables
| Name | Description |
| CampaignMessages | Returns all message records associated with a campaign, including message content, type, and delivery details. |
| Campaigns | Returns all campaigns in the account. Use filters to narrow results by campaign Id, status, or type. |
| CatalogCategories | Lists all product categories configured in the account catalog, including category names, Ids, and metadata. |
| CatalogCategoryItems | Returns all catalog items that belong to a specific category, identified by category Id. |
| CatalogItems | Returns all catalog items in the account, including product details, pricing, and availability information. |
| CatalogItemVariants | Lists all item variants for a given catalog item, including variant attributes such as color or size. |
| CouponCodes | Manages coupon codes for promotions. Supports querying, creating, and updating coupon code records linked to a coupon. |
| Coupons | Returns all coupon definitions in the account. |
| CustomMetrics | Returns all custom metrics created in the account. |
| Flows | Lists all flows in the account, including automation workflows for messages and actions. Supports retrieving and deleting flow records. |
| Forms | Returns all sign-up and pop-up forms in the account. |
| Images | Returns all uploaded images in the account, including metadata such as URLs, file size, and upload timestamps. |
| Lists | Lists all subscriber lists in the account, including list names, Ids, and subscription settings. |
| Profiles | Manages all customer profiles in the account. |
| PushTokens | Returns all push notification tokens associated with the account, used to target customer devices for campaigns. |
| Segments | Manages audience segments in the account. |
| TagGroups | Lists all tag groups in the account. |
| Tags | Lists all tags in the account. |
| Templates | Returns all message templates in the account, including email and SMS templates available for reuse. |
| WebFeeds | Manages web feeds for product or content data synchronization. |
| Webhooks | Lists all webhooks configured in the account. |