SitePublicizeConnection
Query a list of publicize connections that are associated with the specified site.
Table Specific Information
SELECT
The driver uses the WordPress API to process some of the filters.
- Id supports the '=' comparison.
- Service supports the '=' comparison.
- KeyringConnectionID supports the '=' comparison.
The driver processes other filters client-side within the driver.
For example, the following queries are processed server side.
SELECT * FROM SitePublicizeConnection where ID=21
SELECT * FROM SitePublicizeConnection where Service='Facebook'
Columns
| Name | Type | References | Description |
| ID [KEY] | Int | The unique identifier of the Publicize connection record. | |
| SiteID | Int | The unique identifier of the WordPress site associated with the Publicize connection. | |
| UserID | Int | The WordPress.com user ID of the person who authorized the Publicize connection. | |
| Service | String | The name of the connected external service, such as Facebook, Twitter, or LinkedIn. | |
| Label | String | A user-defined label or nickname assigned to the connection. | |
| ExternalID | String | The unique identifier of the connected account on the external service. | |
| HasShared | Bool | Indicates whether the Publicize connection is shared across multiple users on the site. | |
| Status | String | The current connection status, such as active, broken, or expired. | |
| KeyringConnectionID | Int | The internal WordPress.com keyring record ID that manages the OAuth credentials for this connection. | |
| KeyringConnectionUserID | Int | The WordPress.com user ID associated with the keyring connection. | |
| ExternalDisplay | String | The display name shown for the connected account on the external service. | |
| IsExpires | Bool | Indicates whether the access token used for this connection has an expiration time. | |
| ExternalFollowerCount | String | The number of followers or connections on the linked social media account, if provided by the external service. | |
| ExternalName | String | The full display name or username of the connected account owner on the external platform. | |
| ExternalProfilePicture | String | The URL to the profile image of the connected account on the external service. | |
| ExternalprofileURL | String | The URL to the external profile page for the connected account. | |
| Issued | Datetime | The date and time when the connection was first created or authorized. | |
| RefreshURL | String | The endpoint URL used to manually refresh or reauthorize the Publicize connection when needed. |