SSIS Components for Klaviyo

Build 25.0.9434

Accounts

Returns account information (such as Id, name, and organization information) for the current private API key.

Select

The component uses the Klaviyo API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the component.

  • Id supports the following operator: =
For example, the following query is processed server-side:
SELECT * FROM Accounts WHERE Id = 'account-1'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the Klaviyo account. Use this value to reference or filter account-level data across other tables and views.
IsTestAccount Boolean Indicates whether the account is designated as a test account.
Industry String Specifies the type of business or products associated with the organization. This information helps tailor analytics, recommendations, and account insights.
Timezone String Specifies the Internet Assigned Numbers Authority (IANA) time zone configured for the account. This setting determines how timestamps and schedules are displayed in Klaviyo analytics and automations.
PreferredCurrency String Specifies the preferred currency for the account. This value determines the currency format displayed in reports, dashboards, templates, and coupon values.
PublicApiKey String Represents the account's public API key used for client-side API requests and integrations.
Locale String Specifies the account's locale, which determines the display language and regional formatting for account settings and communications.
DefaultSenderName String Specifies the default sender name automatically applied to new campaign and flow emails created under the account.
DefaultSenderEmail String Specifies the default sender email address automatically applied to new campaign and flow emails created under the account.
WebsiteUrl String The website URL associated with the organization or business linked to the account.
OrganizationName String The name of the organization or business registered with the Klaviyo account.
Address1 String The first line of the organization's mailing or street address.
Address2 String The second line of the organization's mailing or street address, if applicable.
City String The city where the organization's main office or business location is based.
Region String The state, province, or administrative region associated with the organization's address.
Country String The two-letter ISO country code for the organization's address, such as US, CA, or GB.
Zip String The postal or ZIP code for the organization's mailing address.

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