SSIS Components for Klaviyo

Build 25.0.9434

UniversalContent

Returns all universal content blocks stored in the account. These reusable blocks can be inserted into multiple email templates to maintain consistent branding.

Select

The component uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the component.

  • Id supports the operators: =, IN
  • Name supports the operators: =, IN
  • Created supports the operators: >=, >, <=, <
  • Updated supports the operators: >=, >, <=, <
  • DefinitionContentType supports the operator: =
  • DefinitionType supports the operator: =

For example, the following queries are processed server-side:

SELECT * FROM UniversalContent 
WHERE Id IN ('universalcontent-id-1', 'universalcontent-id-2', 'universalcontent-id-3')

SELECT * FROM UniversalContent 
WHERE Name = 'CData Software'

Columns

Name Type References Description
Id String The unique identifier for the universal content block within Klaviyo.
Name String The display name of the universal content block, used to identify it within the account.
Created Datetime The date and time when the universal content block was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).
Updated Datetime The date and time when the universal content block was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).
ScreenshotStatus String The current status of the thumbnail screenshot for the universal content block.
ScreenshotUrl String The URL of the thumbnail image or screenshot representing the universal content block.
DefinitionContentType String Specifies the general type of the universal content block, such as block.
DefinitionType String Specifies the specific content type within the block, such as text or html.
DefinitionData String Contains the complete serialized data for the universal content block definition.
DefinitionDataContent String The text or HTML content displayed within the universal content block.
DefinitionDataDisplayOptions.show_on String Specifies display conditions for when the universal content block should be shown in the template editor.
DefinitionDataDisplayOptions.visible_check String Defines visibility checks used to determine whether the content block should be rendered under specific conditions.
DefinitionDataDisplayOptions.content_repeat.repeat_for String Defines the data source or collection used when repeating content dynamically within the block.
DefinitionDataDisplayOptions.content_repeat.item_alias String Specifies the alias name used to reference repeated content items within the block.
DefinitionDataStylesBackgroundColor String Defines the background color styling applied to the universal content block.
DefinitionDataStylesBlockBackgroundColor String Specifies the background color applied to the block container.
DefinitionDataStylesBlockBorderColor String Specifies the color of the border applied to the block container.
DefinitionDataStylesBlockBorderStyle String Specifies the style of the border applied to the block container, such as solid, dashed, or dotted.
DefinitionDataStylesBlockBorderWidth Int Specifies the width of the border applied to the block container, measured in pixels.
DefinitionDataStylesBlockPaddingBottom Int Specifies the bottom padding of the block container, measured in pixels.
DefinitionDataStylesBlockPaddingLeft Int Specifies the left padding of the block container, measured in pixels.
DefinitionDataStylesBlockPaddingRight Int Specifies the right padding of the block container, measured in pixels.
DefinitionDataStylesBlockPaddingTop Int Specifies the top padding of the block container, measured in pixels.
DefinitionDataStylesColor String Specifies the text color applied to the content within the block.
DefinitionDataStylesExtraCssClass String Specifies any additional CSS classes applied to the universal content block for custom styling.
DefinitionDataStylesFontFamily String Specifies the font family used for text within the content block.
DefinitionDataStylesFontSize String Specifies the font size used for text within the content block.
DefinitionDataStylesFontStyle String Specifies the font style applied to text, such as normal or italic.
DefinitionDataStylesFontWeight String Specifies the font weight used for text, such as normal, bold, or numeric weight values.
DefinitionDataStylesInnerPaddingBottom Int Specifies the bottom inner padding of the text area, measured in pixels.
DefinitionDataStylesInnerPaddingLeft Int Specifies the left inner padding of the text area, measured in pixels.
DefinitionDataStylesInnerPaddingRight Int Specifies the right inner padding of the text area, measured in pixels.
DefinitionDataStylesInnerPaddingTop Int Specifies the top inner padding of the text area, measured in pixels.
DefinitionDataStylesLetterSpacing Int Specifies the spacing between characters in the text, measured in pixels.
DefinitionDataStylesLineHeight Double Specifies the line height for text within the block, measured as a unitless ratio or pixel value.
DefinitionDataStylesMobileStretchContent Bool Indicates whether the content should stretch to fit the full width of the screen on mobile devices.
DefinitionDataStylesTextAlign String Specifies the alignment of text within the block, such as left, center, right, or justify.
DefinitionDataStylesTextDecoration String Specifies any text decoration applied to the content, such as underline or strikethrough.
DefinitionDataStylesTextTableLayout String Specifies the layout behavior of text when rendered within a table structure in the content block.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434