ProfilePushTokens
Returns all mobile push tokens registered for a given profile, enabling notification targeting by user device.
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.
- 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. |