SSIS Components for Klaviyo

Build 25.0.9434

Forms

Returns all sign-up and pop-up forms in the account.

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: =, IN
  • Name supports the following operators: =, IN, CONTAINS
  • CreatedAt supports the following operators: =, >=, >, <=, <

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

SELECT * FROM Forms 
WHERE Id = 'form-id'

SELECT * FROM Forms 
WHERE Name IN ('form-name1', 'form-name2', 'form-name3')

SELECT * FROM Forms 
WHERE CreatedAt <= '2025-07-08'

Delete

You can delete a form by specifying the Id of the record you want to remove.

DELETE FROM Forms 
WHERE Id = 'form-id'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the form, automatically generated by Klaviyo.

Name String False

The display name of the form as configured in Klaviyo. Use this value to identify or manage specific forms.

ABTest Bool False

Indicates whether the form has an A/B test (split test) configured, regardless of whether the test is currently active or completed.

CreatedAt Datetime False

The date and time when the form was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).

Status String False

The current status of the form. A live form with an active draft version is still considered live.

UpdatedAt Datetime False

The date and time when the form was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).

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