PublicizeConnection
list all publicizeconnections that the current user has set up and update and delete specified publicize connection.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters.
- Name supports the '=' comparison.
The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side.
SELECT * FROM PublicizeConnection
Update
To update a publicized connection you must specify the following column: ID.
UPDATE PublicizeConnection SET ExternalName= 'New external name', Status='Active' WHERE ID = 21
Delete
To delete a publicized connection you must specify the following column: ID.
DELETE FROM PublicizeConnection WHERE ID = 21
Columns
| Name | Type | ReadOnly | References | Description |
| ID [KEY] | Int | False |
The unique identifier of the Publicize connection record. | |
| SiteID | Int | False |
The unique identifier of the WordPress site associated with this Publicize connection. | |
| UserID | Int | False |
The unique identifier of the WordPress.com user who owns or manages this connection. | |
| IsExpires | Bool | False |
Indicates whether the Publicize connection is temporary and automatically expires after a set period. | |
| ExternalDisplay | String | False |
The display name shown for the connected external account, as retrieved from the linked service. | |
| ExternalFollowerCount | Int | False |
The number of followers or subscribers retrieved from the connected external service. | |
| ExternalID | String | False |
The unique identifier assigned to the connected account on the external platform. | |
| ExternalName | String | False |
The account name or handle used on the connected external service. | |
| ExternalProfilePicture | String | False |
The URL of the profile image associated with the connected external account. | |
| ExternalProfileURL | String | False |
The URL of the profile page for the connected external account. | |
| Issued | Datetime | False |
The date and time when the Publicize connection was created or authorized. | |
| KeyringConnectionID | Int | False |
The unique identifier of the related Keyring connection record used for authentication. | |
| KeyringConnectionUserID | Int | False |
The unique identifier of the user associated with the linked Keyring connection. | |
| Label | String | False |
A custom label assigned by the user to help identify this Publicize connection. | |
| RefreshURL | String | False |
The URL endpoint used to refresh or renew the connection if it becomes invalid or expires. | |
| Service | String | False |
The name of the external service connected through Publicize, such as Twitter or Facebook. | |
| HasSharedAccess | Bool | False |
Indicates whether the connection can be shared across multiple users or is restricted to a single user. | |
| Status | String | False |
The current operational status of the connection, such as active or inactive. |