JDBC Driver for Klaviyo

Build 25.0.9434

PushTokens

Returns all push notification tokens associated with the account, used to target customer devices for campaigns.

Select

The 本製品 uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the 本製品.

  • Id supports the operator: =
  • Platform supports the operator: =

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

SELECT * FROM PushTokens 
WHERE Id = 'pushtoken-id'

SELECT * FROM PushTokens 
WHERE Platform = 'android'

Delete

You can delete a push token by specifying its Id.

DELETE FROM PushTokens 
WHERE Id = 'pushtoken-id'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique identifier for the push token record in Klaviyo.

Created Datetime False

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

Token String False

The push token value used to identify the device for sending push notifications.

EnablementStatus String False

Specifies the enablement status of the push token. Supported values include AUTHORIZED, DENIED, NOT_DETERMINED, PROVISIONAL, and UNAUTHORIZED.

Platform String False

Specifies the platform associated with the push token. Supported values include ios and android.

Vendor String False

Specifies the vendor that issued the push token. Supported values include Apple Push Notification service (APNs) and Firebase Cloud Messaging (FCM).

Background String False

Indicates the background state of the device when the push token was recorded.

RecordedDate String False

The date when the push token was recorded in Klaviyo.

AppBuild String False

The build number of the app that generated the push token.

AppId String False

The unique identifier of the app that created the push token.

AppName String False

The name of the app that generated the push token.

AppVersion String False

The version of the app that generated the push token.

DeviceId String False

A relatively stable identifier for the device. This value might change if the app is uninstalled and reinstalled.

DeviceModel String False

The model name or identifier of the device that generated the push token.

Environment String False

Specifies the environment in which the push token was created, such as debug or release.

KlaviyoSdk String False

Specifies the SDK used to generate the push token. Supported values include android, flutter_community, react_native, and swift.

Manufacturer String False

The manufacturer of the device associated with the push token.

OsName String False

The operating system running on the device. Supported values include android, ios, ipados, macos, and tvos.

OsVersion String False

The version of the operating system running on the device.

SdkVersion String False

The version of the Klaviyo SDK used to create the push token.

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