Power BI Connector for Klaviyo

Build 25.0.9454

FlowActions

Returns all flow actions associated with a given flow, including trigger details and action types.

Select

The connector 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 connector.

  • Id supports the following operator: =
  • ActionType supports the following operators: =, IN
  • Status supports the following operator: =
  • Created supports the following operators: =, >=, >, <=, <
  • Updated supports the following operators: =, >=, >, <=, <
  • FlowId supports the following operator: =

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

SELECT * FROM FlowActions 
WHERE Id = 'flowaction-id-1'

SELECT * FROM FlowActions 
WHERE Created >= '2025-04-06' AND Status = 'draft'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the flow action within Klaviyo.
FlowId [KEY] String

Flows.Id

The unique identifier of the flow associated with this action. Use this value to retrieve all actions that belong to a specific flow.
ActionType String Specifies the type of flow action being executed, such as SEND_EMAIL, SEND_SMS, or other automated triggers.
Status String Indicates the current status of the flow action. Possible values include draft, manual, and live.
Created Datetime The date and time when the flow action was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).
Updated Datetime The date and time when the flow action was last modified, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).
BadgeOptions String Specifies the configuration options for badge notifications associated with the flow action, if applicable.
RenderOptionsShortenLinks String Indicates whether links included in the message should be automatically shortened when the flow action is rendered.
RenderOptionsAddOrgPrefix String Indicates whether an organizational prefix should be added to the beginning of the message, identifying the sender's company or brand.
RenderOptionsAddInfoLink String Indicates whether a link to the company's information or support page should be appended to the message content.
RenderOptionsAddOptOutLanguage String Indicates whether an opt-out phrase should be automatically added to the end of the message, typically for SMS compliance.
SendOptionsIsTransactional Bool Specifies whether the flow action is transactional. Transactional messages are not subject to subscription or consent settings.
SendOptionsUse_smart_sending Bool Indicates whether Smart Sending is enabled for this message (default is true). Smart Sending prevents recipients from receiving too many messages in a short time period.
TrackingOptionsAddUtm Bool Indicates whether Urchin Tracking Module (UTM) tracking parameters are appended to message links for campaign attribution and analytics.
TrackingOptionsUtmParams String Lists the UTM parameters applied to tracked links. If the TrackingOptionsAddUtm field is true and no parameters are defined, company default UTM settings are used.
TrackingOptionsIsTrackingClicks Bool Indicates whether click tracking is enabled for this flow action (default is true). This applies to email campaigns only.
TrackingOptionsIsTrackingOpens Bool Indicates whether open tracking is enabled for this flow action (default is true). This applies to email campaigns only.

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