WebFeeds
Manages web feeds for product or content data synchronization.
Select
The add-in uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the add-in.
- 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. |