ProfilePushTokens
Returns all mobile push tokens registered for a given profile, enabling notification targeting by user device.
Select
The connector uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the connector.
- ProfileId supports the operator: =
For example, the following query is processed server-side:
SELECT * FROM ProfilePushTokens
WHERE ProfileId = 'profile-id-1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the push token record in Klaviyo. | |
| ProfileId | String | The unique identifier of the profile associated with this push token. Use this value to retrieve all push tokens linked to a specific profile. | |
| Created | Datetime | The date and time when the push token was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| Token | String | The push token value used to identify the device for push notifications. | |
| EnablementStatus | String | Specifies the enablement status of the push token. Supported values include AUTHORIZED, DENIED, NOT_DETERMINED, PROVISIONAL, and UNAUTHORIZED. | |
| Platform | String | Specifies the platform associated with the push token. Supported values include ios and android. | |
| Vendor | String | Specifies the vendor that issued the push token. Supported values include Apple Push Notification service (APNs) and Firebase Cloud Messaging (FCM). | |
| Background | String | Indicates the background state of the device when the push token was recorded. | |
| RecordedDate | String | The date when the push token was recorded in Klaviyo. | |
| AppBuild | String | The build number of the app that generated the push token. | |
| AppId | String | The unique identifier of the app that created the push token. | |
| AppName | String | The name of the app that generated the push token. | |
| AppVersion | String | The version of the app that generated the push token. | |
| DeviceId | String | A relatively stable identifier for the device. This value might change if the app is uninstalled and reinstalled. | |
| DeviceModel | String | The model name or identifier of the device that generated the push token. | |
| Environment | String | Specifies the environment in which the push token was created, such as debug or release. | |
| KlaviyoSdk | String | Specifies the SDK used to generate the push token. Supported values include android, flutter_community, react_native, and swift. | |
| Manufacturer | String | The manufacturer of the device associated with the push token. | |
| OsName | String | The operating system running on the device. Supported values include android, ios, ipados, macos, and tvos. | |
| OsVersion | String | The version of the operating system running on the device. | |
| SdkVersion | String | The version of the SDK used to create the push token. |