SSIS Components for Klaviyo

Build 25.0.9434

WebFeeds

Manages web feeds for product or content data synchronization.

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

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

SELECT * FROM WebFeeds 
WHERE Id = 'webfeed-id'

SELECT * FROM WebFeeds 
WHERE Name = 'CData WebFeed'

Insert

You can create new web feeds.

INSERT INTO WebFeeds (Name, RequestMethod, Url, ContentType) 
VALUES ('CData WebFeed', 'GET', 'https://cdata.com', 'json')

Update

You can update web feeds. The field that can be updated is Name.

UPDATE WebFeeds 
SET Name = 'CData Software WebFeed' 
WHERE Id = 'webfeed-id'

Delete

You can delete a web feed by specifying its Id.

DELETE FROM WebFeeds 
WHERE Id = 'webfeed-id'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier for the web feed within Klaviyo.

ContentType String False

Specifies the format of the web feed content. Supported values include json and xml.

Created Datetime True

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

Name String False

The display name of the web feed as defined in Klaviyo.

RequestMethod String False

Specifies the HTTP request method used to retrieve the web feed. Supported values include get and post.

Status String True

Indicates the cache or refresh status of the web feed. Possible values include critical_nightly_refresh_timeout, disabled, ok, warning_nightly_refresh_timeout, and warning_periodic_refresh_timeout.

Updated Datetime True

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

Url String False

The URL endpoint for accessing the web feed.

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