PublicizeConnection
list all publicizeconnections that the current user has set up and update and delete specified publicize connection.
Table Specific Information
SELECT
The connector uses the WordPress API to process some of the filters.
- Name supports the '=' comparison.
The connector processes other filters client-side within the connector.
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. |