This page provides a guide to Establishing a Connection to WordPress in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to WordPress

Establishing a Connection shows how to authenticate to WordPress and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from WordPress through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to WordPress by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to WordPress

CData Cloud supports connecting to self-hosted WordPress instances and WordPress Online instances.

• If you are connecting to self-hosted WordPress, you must provide the URL of your WordPress site and then authenticate.
• If you are connecting to WordPress Online, you can choose between OAuth 2.0 and OAuth Password authentication.

Connecting to Self-Hosted WordPress

For self-hosted WordPress instances, to connect to data, provide the full URL for your WordPress site, and then authenticate as described below. For example, if your site is hosted at http://localhost/wp/wordpress, you should enter it as http://localhost/wp/wordpress, not just http://localhost. Failing to provide the complete URL will lead to a 'site not found' error.

Self-hosted WordPress instances support two types of authentication:

• Basic authentication: This method is recommended for use in testing environments. It provides a way to access your WordPress instance.
• OAuth 2.0 authentication: This method supports secure, browser-based access from various platforms, including desktop applications, web applications, and headless machines.

Note: Choose the method that fits your needs based on the environment and level of security required.

Basic Authentication

Before you configure WordPress to use Basic Authentication, follow these guidelines:

• Ensure that your WordPress login has administrative privileges.
• Be aware of the version of WordPress running on the local host. Note: Versions 4.7 and later support the WordPress REST API natively, while earlier versions require a Basic Authentication plug-in to secure REST API access.

To configure Basic Authentication:

1. Log into your WordPress host.
2. If you are running an earlier WordPress version than 4.7, install the REST API plugin.
3. Install the Basic Authentication plugin.
4. To create custom taxonomies, install the Simple Taxonomy Refreshed plugin.
   If you prefer installing the plugins manually, extract the compressed folders to the wp-content\plugins folder and then enable the plugins via the WordPress admin interface.
5. Next, set the following connection properties:
   • AuthScheme: Set this to Basic.
   • URL: Your WordPress URL.
   • User: Your username.
   • Password: Your password.

You are now ready to connect.

OAuth 2.0 Authentication

For all non-testing environments, WordPress supports OAuth authentication only. To enable this authentication from all OAuth flows, you must set AuthScheme to OAuth, and you must create a custom OAuth application.

The following subsections describe how to authenticate to WordPress from three common authentication flows. For information about how to create a custom OAuth application, see Creating a Custom OAuth Application. For a complete list of connection string properties available in WordPress, see Connection.

Automatic refresh of the OAuth access token:

To have the Cloud automatically refresh the OAuth access token, do the following:

1. Before connecting to data for the first time, set the following connection parameters:
   • InitiateOAuth: Set this to REFRESH.
   • OAuthClientId: The client Id in your application settings.
   • OAuthClientSecret: The client secret in your application settings.
   • OAuthAccessToken: The access token returned by GetOAuthAccessToken.
   • OAuthSettingsLocation: The path where you want the Cloud to save the OAuth values, which persist across connections.
2. On subsequent data connections, set the following:
   • InitiateOAuth
   • OAuthSettingsLocation

OAuthClient Authentication

The client credentials grant type allows authentication from desktop applications or the web. To enable this authscheme, set AuthScheme to OAuthClient. This method requires a custom OAuth application, as described in Creating a Custom OAuth Application.

To connect, set these properties:

• InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the access token in the connection string.
• AuthScheme: Set the AuthScheme to OAuthClient to perform authentication with the client credentials grant type.
• OAuthClientId: The client Id specified in your custom OAuth application.
• OAuthClientSecret: The client secret specified in your custom OAuth application.

Okta

To connect to Okta, set these properties:

• AuthScheme: Okta.
• User: The authentiating Okta user.
• Password: The password of the authenticating Okta user.
• SSOLoginURL: The SSO provider's login URL.
• SSOExchangeURL: The url used for the exchange of the SAML token for WordPress credentials. This is optional and if it is NULL WordPress will construct it.

If you are either using a trusted application or proxy that overrides the Okta client request OR configuring MFA, you must use combinations of SSOProperties to authenticate using Okta. Set any of the following, as applicable:

• APIToken: When authenticating a user via a trusted application or proxy that overrides the Okta client request context, set this to the API Token the customer created from the Okta organization.
• MFAType: If you have configured the MFA flow, set this to one of the following supported types: OktaVerify, Email, or SMS.
• MFAPassCode: If you have configured the MFA flow, set this to a valid passcode.
  If you set this to empty or an invalid value, the Cloud issues a one-time password challenge to your device or email. After the passcode is received, reopen the connection where the retrieved one-time password value is set to the MFAPassCode connection property.
• MFARememberDevice: True by default. Okta supports remembering devices when MFA is required. If remembering devices is allowed according to the configured authentication policies, the Cloud sends a device token to extend MFA authentication lifetime. If you do not want MFA to be remembered, set this variable to False.

Example connection string:

AuthScheme=Okta;SSOLoginURL='https://example.okta.com/home/appType/0bg4ivz6cJRZgCz5d6/46';User=oktaUserName;Password=oktaPassword;URL=YourWordpressSiteURL;

Azure AD

This configuration requires two separate Azure AD applications:

• The "WordPress" application used for single sign-on, and
• A custom OAuth application with user_impersonation permission on the Azure Active Directory.

To connect to Azure AD, set the AuthScheme to AzureAD, and set these properties:

• SSOExchangeURL: The url used for the exchange of the SAML token for WordPress credentials. This is optional and if it is NULL WordPress will construct it.

• OAuthClientId: The application Id of the connector application, listed in the Overview section of the app registration.
• OAuthClientSecret: The client secret value of the connector application. Azure AD displays this when you create a new client secret.
• CallbackURL: The redirect URI of the connector application. For example: https://localhost:33333.

To authenticate to Azure AD, set these required properties in SSOProperties:

• Resource: The application Id URI of the WordPress application, listed in the app registration's Overview section. In most cases this is the URL of your custom WordPress domain.
• AzureTenant: The Id of the Azure AD tenant where the applications are registered.

Example connection string:

AuthScheme=AzureAD;URL=YourWordpressSiteURL;OAuthClientId=3ea1c786-d527-4399-8c3b-2e3696ae4b48;OauthClientSecret=xxx;CallbackUrl=https://localhost:33333;SSOProperties='Resource=https://YourWordpressSite/wp-content/plugins/miniorange-saml-20-single-sign-on;AzureTenant=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx';

You are now ready to connect.

PingFederate

To connect to PingFederate, set the AuthScheme to PingFederate.

Before connecting, ensure that your WordPress site is configured with a PingFederate SSO plugin and that the authenticating user is provisioned in the PingFederate Data Store.

Set the following connection properties:

• User: The PingFederate user. You must also add this user to PingFederate Data Stores. When connecting with a browser, you are redirected to the PingFederate login page to complete authentication.
• Password: The PingFederate user's password.
• SSOLoginURL: The PingFederate SSO login URL.
• SSOExchangeURL (optional): The URL used for exchanging the SAML token for WordPress credentials. If not provided, the Cloud attempts to construct it automatically.

Example connection string:

AuthScheme=PingFederate;URL=https://yourwordpresssite.com;User=myuser@mydomain;Password=mypassword;SSOLoginURL=https://idp.example.com/idp/startSSO.ping;

Connecting to WordPress Online

WordPress Online supports two types of authentication methods:

1. OAuth 2.0 authentication
2. OAuth Password authentication

OAuth 2.0 Authentication

OAuth 2.0 is a protocol that allows applications to interact with blogs on WordPress, Your Way, and self-hosted WordPress sites running Jetpack.

The two authentication endpoints are the authorization endpoint and the token request endpoint.

• https://public-api.wordpress.com/oauth2/authorize
• https://public-api.wordpress.com/oauth2/token

Before you begin, you must create and register a custom OAuth application with WordPress.com, as described in Creating a Custom OAuth Application. This application provides the client Id, client secret, and redirect URI required to authenticate your application and verify API calls. You can create or manage your applications in the WordPress Applications Manager.

Use these values with the authorization endpoints, which require the following parameters:

When you are ready to connect, set the following connection properties:

• Schema: WordPressOnline.
• AuthScheme: OAuth.
• URL: Your WordPress.com site URL.
• InitiateOAuth: Set this to GETANDREFRESH.
• OAuthClientId: The client Id from your WordPress.com application.
• OAuthClientSecret: The client secret from your WordPress.com application.

There is an optional parameter available that can be used:

• Scope: Defines the level of access that the authentication token grants to your application. Depending on the value set (or omitted), different access is allowed. Supported values include:
  • Auth: Grants access to /me endpoints for WordPress.com Connect.
  • Global: Grants full access to all the blogs associated with the user's account, including any Jetpack-connected sites. If omitted, access is limited to a single blog.

OAuth Password Authentication

Set the following connection properties:

• Schema: WordPressOnline.
• AuthScheme: OAuthPassword.
• URL: Your WordPress Online URL.
• OAuthClientId: The client Id assigned when you registered your custom OAuth application.
• OAuthClientSecret: The client secret assigned when you registered your custom OAuth application.
• User: Your username.
• Password: Your password.

Example connection strings:

AuthScheme=OAuthPassword;Schema=WordPressOnline;URL=https://example.wordpress.com;OAuthClientId=yourClientId;OAuthClientSecret=yourClientSecret;User=yourUser;Password=yourPassword;

AuthScheme=OAuth;Schema=WordPressOnline;URL=https://example.wordpress.com;InitiateOAuth=GETANDREFRESH;OAuthClientId=yourClientId;OAuthClientSecret=yourClientSecret;

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store. To specify another certificate, see the SSLServerCert property for the available formats to do so.

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

Customizing the SSL Configuration

To enable TLS, set the following:

• URL: Prefix the connection string with https://

With this configuration, the Cloud attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Cloud uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Cloud models WordPress data as an easy-to-use SQL database with tables, views, and stored procedures.

The Cloud exposes two schemas:

• See WordPress Data Model for the available entities in the WordPress API.
• See WordPressOnline Data Model for the available entities in the WordPress Online API.

Stored Procedures

These are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating and uploading media and managing OAuth tokens.

Using Query Processing

The Cloud offloads as much of the SELECT statement processing as possible to the WordPress APIs and then processes the rest of the query within the Cloud. For details about specific API limitations and requirements, see the WordPress Data Model and WordPressOnline Data Model sections.

The CData Cloud models WordPress data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables are available through the self-hosted WordPress API. Data availability depends on the authenticated user's role and site configuration.

Commonly used tables include:

Table	Description
Categories	Create, update, delete, and query Categories to use for categorizing your posts.
Comments	Create, update, delete, and query Comments associated with a post.
Media	Create, update, delete, and query Media to attach in your posts.
Members	Create, update, delete, and list the Members of the website.
Pages	Create, update, delete, and query Wordpress Pages.
Plugins	Create, update, delete, and query Plugins.
Posts	Create, update, delete, and query Wordpress Posts.
Tags	Create, update, delete, and query Tags to associate with your posts.
Users	Create, update, delete, and list the Users of the website.
Taxonomies	List all the taxonomies.
TaxonomyTerms	List all terms of the taxonomies.
Types	List Types associated with the Posts.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating and uploading media and managing OAuth tokens.

The Cloud models the data in WordPress as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - WordPress Tables

Name	Description
Categories	Returns information about WordPress categories, including their names, descriptions, and post counts.
Comments	Returns comments from WordPress posts, including author details, content, and status information.
Media	Create, update, delete, and query Media to attach in your posts.
Members	Create, update, delete, and list the Members of the website.
Pages	Create, update, delete, and query Wordpress Pages.
Plugins	Create, update, delete, and query Plugins.
Posts	Create, update, delete, and query Wordpress Posts.
Tags	Create, update, delete, and query Tags to associate with your posts.
Users	Create, update, delete, and list the Users of the website.

Returns information about WordPress categories, including their names, descriptions, and post counts.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Categories WHERE Parent = 0
SELECT * FROM Categories ORDER BY Id
SELECT * FROM Categories WHERE Id IN ('130', '129')

Also, ordering by Count, Description and Name, is handled by the WordPress API.

Insert

To insert a category the following column is required: Name.

INSERT INTO Categories (Description, Name, Parent) VALUES ('This is an example Category', 'myCategory', '138')

Update

To update a category you must specify the following column: Id.

UPDATE Categories SET Name = 'updatedName', Description = 'Updated description.', Parent = 137 WHERE Id = '139'

Delete

To delete a category you must specify the following column: Id.

DELETE FROM Categories WHERE Id = '139'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		A unique integer that identifies the category in WordPress and links posts, tags, and other taxonomy data associated with that category.
Count	Integer	True		The total number of posts currently assigned to the category, as returned by the WordPress API.
Description	String	False		The descriptive text defined in WordPress for the category, typically used to explain its purpose or the type of posts it contains.
Link	String	True		The full URL returned by WordPress that links to the public category page associated with this record.
Name	String	False		The category name defined in WordPress, representing the label shown on the site and used to organize related posts.
Taxonomy	String	True		The taxonomy type that classifies the category in WordPress.
Parent	Integer	False		The identifier of the parent category that this category belongs to. A value of 0 indicates that the category has no parent.

Returns comments from WordPress posts, including author details, content, and status information.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud. To retrieve and filter the values for the AuthorEmail column, use Context='edit' in the WHERE clause.

For example, the following queries are processed server side.

SELECT * FROM Comments WHERE Id = 61
SELECT * FROM Comments WHERE Id IN (61, 45)
SELECT * FROM Comments WHERE AuthorEmail = '[email protected]' AND Status = 'approve' AND Type = 'comment' AND PostId = '1' AND Context='edit'
SELECT * FROM Comments WHERE Author IN ('1', '2')
SELECT * FROM Comments WHERE Date > '2018-02-02T02:02:23'
SELECT * FROM Comments WHERE Date < '2018-02-02T02:02:23'
SELECT * FROM Comments ORDER BY Date DESC

Also, ordering by Id, DateGMT, Type, Parent, is handled by the WordPress API.

Insert

To insert comments you must specify the following columns: PostId, Content.

INSERT INTO Comments (PostId, Content) VALUES ('1', 'This is a comment in the post with id 1.')

Update

To update a comment you must specify the following column: Id

UPDATE Comments SET Content = 'Updated content' WHERE Id = '1234'

Other fields that you can use on INSERT / UPDATE queries are: Author, AuthorEmail, AuthorIp, AuthorName, AuthorUrl, Content, Date, DateGMT, Parent, PostId, Status.

Delete

To delete a Comment you must specify the following column: Id.

DELETE FROM Comments WHERE Id = '1234'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier for the comment object in WordPress.
Author	Integer	False		Specifies the name of the author who submitted the comment on the WordPress post.
AuthorEmail	String	False		The author's email address for the object. To filter values for this column.
AuthorIp	String	False		The IP address associated with the comment's author, identifying the source location from which the comment was submitted to WordPress.
AuthorName	String	False		The display name of the user who authored the comment in WordPress.
AuthorUrl	String	False		Specifies the website URL submitted by the author when posting the comment.
Date	Datetime	False		The date and time when the comment was posted in WordPress.
DateGMT	Datetime	False		The date the object was published as Greenwich Mean Time (GMT).
Status	String	False		The approval status of the comment, such as approved, pending, or spam. The allowed values are hold, approved, spam, trash.
Type	String	True		Specifies the type of comment, such as a standard comment, trackback, or pingback.
Parent	Integer	False		Specifies the identifier of the parent comment when this comment is a reply. A value of 0 indicates no parent.
Content	String	False		The text content of the comment submitted by the author.
PostId	Integer	False		The unique identifier of the post or page associated with the comment.
Link	String	True		The URL linking directly to the comment on the associated WordPress post.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
Context	String	The context or area of WordPress where the comment was posted. The allowed values are view, edit, embed.

Create, update, delete, and query Media to attach in your posts.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud. Note: The Status column only accepts the following values for select operation: inherit and private. For example, the following queries are processed server side.

SELECT * FROM Media WHERE Id IN ('1176', '1175')
SELECT * FROM Media WHERE Id = '1176'
SELECT * FROM Media WHERE AuthorId IN (1, 2)
SELECT * FROM Media WHERE MimeType = 'image/jpeg'
SELECT * FROM Media WHERE Status = 'Inherit'
SELECT * FROM Media WHERE Date < '2018-02-02T02:02:23'
SELECT * FROM Media WHERE Date > '2018-02-02T02:02:23'
SELECT * FROM Media ORDER BY Id

Also, ordering by Date, Modified, and AuthorId is handled by the WordPress API.

Update

To update a media you must specify the following column: Id.

UPDATE Media SET Title = 'Updated Title' WHERE Id = '4'

Other fields that you can use on INSERT and UPDATE queries are: Date, DateGMT, Status, Title, AuthorId, CommentStatus, PingStatus, Caption, Description, PostId.

Delete

To delete a media you must specify the following column: Id.

DELETE FROM Media WHERE Id = '1234'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the media item in WordPress.
Title	String	False		The title assigned to the media item, such as the file name or a descriptive label.
Date	Datetime	False		The date and time when the media item was uploaded, recorded in the site's local timezone.
DateGMT	Datetime	False		The upload date and time of the media item recorded in Greenwich Mean Time (GMT).
Modified	Datetime	True		The date and time when the media item was last modified in the site's local timezone.
ModifiedGMT	Datetime	True		The date and time when the media item was last modified in Greenwich Mean Time (GMT).
Status	String	False		The publication status of the media item, such as inherit or private.
Type	String	True		Specifies the type of WordPress post associated with the media item, typically 'attachment'.
AuthorId	Integer	False		The unique identifier of the user who uploaded or owns the media item.
CommentStatus	String	False		Indicates whether comments are allowed on the media item.
PingStatus	String	False		Indicates whether the media item can receive pingbacks or trackbacks.
Caption	String	False		A short explanatory caption or description displayed with the media item.
Description	String	False		The full description or additional details provided for the media item.
MediaType	String	True		Specifies the general type of the media item, such as image, video, or audio.
MimeType	String	True		The Multipurpose Internet Mail Extensions (MIME) type of the media file, such as image/jpeg or video/mp4.
PostId	Integer	False		The ID of the post or page the media item is attached to, if applicable.
SourceUrl	String	True		The direct URL to the original media file stored in WordPress.
Link	String	True		The permalink URL for viewing the media item in WordPress.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
FileLocation	String	Specifies the local file path or source location of the media file to upload.

Create, update, delete, and list the Members of the website.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Members WHERE Id = 10

Update

To update a member you must specify the following column: Id.

UPDATE Members SET Title = 'updatedName' WHERE Id = '139'

Delete

To delete a member you must specify the following column: Id.

DELETE FROM Members WHERE Id = '139'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the member record in WordPress.
Date	Datetime	False		The date and time when the member record was created, recorded in the site's local timezone.
DateGMT	Datetime	False		The date and time when the member record was created, recorded in Greenwich Mean Time (GMT).
Slug	String	False		The URL-friendly version of the member name, used to create clean and readable links.
Status	String	False		Indicates the current status of the member record, such as active or inactive.
Title	Object	False		The display name or title assigned to the member.
Link	String	False		The direct URL linking to the member's public profile or related content.

Create, update, delete, and query Wordpress Pages.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Pages WHERE Id IN (1, 2)
SELECT * FROM Pages WHERE Author IN ('1', '23')
SELECT * FROM Pages WHERE Parent IN (0, 2)
SELECT * FROM Pages WHERE Status = 'Publish'
SELECT * FROM Pages WHERE MenuOrder = 1
SELECT * FROM Pages WHERE Date > '2018-02-02T02:02:23'
SELECT * FROM Pages WHERE Date < '2018-02-02T02:02:23'
SELECT * FROM Pages ORDER BY Id

Also, ordering by Author, Title, Date, Modified, Parent, MenuOrder, is handled by the WordPress API.

Insert and Update

To insert a page, it's enough to specify one of the fields below:

INSERT INTO Pages (Title, Content, Status) VALUES ('A title', 'Some content here', 'publish')

To update a page you must specify the following column: Id.

UPDATE Pages SET Status = 'draft', Content = 'Updated content', Title = 'Updated title' WHERE Id = '12345'

Other fields that you can use on INSERT and UPDATE queries are: Date, DateGMT, Status, Parent, Title, Content, Author, MediaId, CommentStatus, PingStatus, and MenuOrder.

Delete

To delete a page you must specify the following column: Id.

DELETE FROM Pages WHERE Id = '12345'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the page in WordPress.
Author	Integer	False		The unique identifier of the user who created or owns the page.
Title	String	False		The title of the WordPress page, as displayed in listings or navigation menus.
Date	Datetime	False		The date and time when the page was published, recorded in the site's local timezone.
DateGMT	Datetime	False		The date and time when the page was published, recorded in Greenwich Mean Time (GMT).
Link	String	True		The permalink URL for viewing the published page on the WordPress site.
Modified	Datetime	True		The date and time when the page was last updated, recorded in the site's local timezone.
ModifiedGMT	Datetime	True		The date and time when the page was last updated, recorded in GMT.
Status	String	False		Indicates the current publication status of the page, such as publish, future, draft, pending, or private. The allowed values are publish, future, draft, pending, private.
Type	String	True		Specifies the content type of the object, which for pages is typically 'page'.
Parent	Integer	False		The unique identifier of the parent page, if this page is part of a hierarchy.
Content	String	False		The main body content of the WordPress page.
FeaturedMediaId	Integer	False		The unique identifier of the media item, such as an image, is set as the featured image for the page.
CommentStatus	String	False		Indicates whether visitors can post comments on the page.
PingStatus	String	False		Specifies whether the page can receive pingbacks or trackbacks from other sites.
MenuOrder	Integer	False		Defines the display order of the page relative to other pages with the same parent.

Create, update, delete, and query Plugins.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud.

• Plugin supports the '=' operator.
• Status supports the '=' operator.
• Context supports the '=' operator.

The following queries are processed server side.

SELECT * FROM Plugins WHERE Plugin = 'hello-dolly/hello'
SELECT * FROM Plugins WHERE Status = 'inactive'
SELECT * FROM Plugins WHERE Context = 'edit'

Insert

To insert into Plugins, you must specify the Slug column.

INSERT INTO Plugins (Slug, Status) VALUES ('hello-dolly', 'active')

Update

To update the Plugin, you must specify the Plugin column.

UPDATE Plugins SET Status = 'inactive' WHERE Plugin = 'hello-dolly/hello'

Delete

To delete a Plugin, you must specify the Plugin column.

DELETE FROM Plugins WHERE Plugin = 'hello-dolly/hello'

Columns

Name	Type	ReadOnly	References	Description
Plugin [KEY]	String	True		The main plugin file name, including its relative path within the WordPress plugins directory.
Name	String	True		The display name of the plugin as shown in the WordPress admin interface.
Author	String	True		The name of the developer or organization that created the plugin.
DescriptionRaw	String	True		The unformatted text version of the plugin description as stored in its metadata.
DescriptionRendered	String	True		The formatted version of the plugin description, as rendered for display in the WordPress admin interface.
NetworkOnly	Boolean	True		Indicates whether the plugin can only be activated for the entire WordPress network in multisite installations.
RequiresPhp	String	True		Specifies the minimum required version of PHP (Hypertext Preprocessor) for the plugin to run correctly.
RequiresWp	String	True		Specifies the minimum WordPress version required for the plugin to be compatible.
Status	String	False		The current activation state of the plugin, such as active, inactive, or must-use. The allowed values are inactive, active.
TextDomain	String	True		The text domain used for internationalization and localization of the plugin's strings.
Version	String	True		The version number of the plugin as defined in its header information.
AuthorUri	String	True		The website URL of the plugin's author or development organization.
PluginUri	String	True		The website URL providing more information or documentation about the plugin.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
Slug	String	The unique plugin directory slug from WordPress.org is required for insert operations, but it is not included in select responses.
Context	String	Specifies the request context, which determines the fields and level of detail returned in the response. The allowed values are view, edit, embed.

Create, update, delete, and query Wordpress Posts.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Posts WHERE Id = 1
SELECT * FROM Posts WHERE Status = 'publish' AND Sticky = 'true'
SELECT * FROM Posts WHERE Id IN (1, 21)
SELECT * FROM Posts WHERE Author IN (1, 2)
SELECT * FROM Posts WHERE Date < '2018-02-02T02:02:23'
SELECT * FROM Posts WHERE Date > '2018-02-02T02:02:23'
SELECT * FROM Posts ORDER BY Title

Also, ordering by Id, Author, Date, Modified, is handled by the WordPress API.

Insert and Update

To insert a post you must specify one of the following columns: Title, Content, and Excerpt.

INSERT INTO Posts (Title, status) VALUES ('New post', 'publish')

To create a post with custom taxonomy, you must specify the TaxonomyTerms(name:terms) in the below format.

INSERT INTO Posts (Title, Content, Status, TaxonomyTerms) VALUES ('The story of Dr Strange', 'This is the content', 'publish', 'books:2,5')"

To update a post you must specify the following column: Id.

UPDATE Posts SET Content = 'Updated content' WHERE Id = '12345'

To update the post with custom taxonomy, you must specify the TaxonomyTerms(name:terms) in the below format.

UPDATE Posts SET taxonomyterms = 'books:2,5' WHERE Id = '10'"

Other fields that you can use on INSERT and UPDATE queries are the following: Date, DateGMT, Status, Excerpt, Title, Content, Author, MediaId, CommentStatus, PingStatus, Sticky, Categories, Tags and TaxonomyTerms.

Delete

To delete a post you must specify the following column: Id.

DELETE FROM Posts WHERE Id = '12345'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the post in WordPress.
Title	String	False		The title of the WordPress post, displayed in listings, navigation, and page headers.
CommentStatus	String	False		Indicates whether comments are enabled for the post, allowing visitors to leave feedback.
Categories	String	False		The list of categories assigned to the post, provided as a comma-separated string.
Tags	String	False		The list of tags assigned to the post, provided as a comma-separated string for organizing content.
Author	Integer	False		The unique identifier of the user who authored or published the post.
Date	Datetime	False		The date and time when the post was published, recorded in the site's local timezone.
DateGMT	Datetime	False		The date and time when the post was published, recorded in Greenwich Mean Time (GMT).
Modified	Datetime	True		The date and time when the post was last updated, recorded in the site's local timezone.
ModifiedGMT	Datetime	True		The date and time when the post was last updated, recorded in GMT.
Status	String	False		Indicates the current publication state of the post, such as publish, future, draft, pending, or private. The allowed values are publish, future, draft, pending, private.
Type	String	True		Specifies the type of post, such as post, page, or a registered custom post type.
Content	String	False		The main body content of the WordPress post, including formatted text, media, or HTML.
Excerpt	String	False		A short summary or preview of the post content, often displayed in feeds or post listings.
PingStatus	String	False		Specifies whether pingbacks and trackbacks are enabled for the post.
Format	String	False		Defines the visual format of the post, such as standard, aside, gallery, or link.
Sticky	Boolean	False		Indicates whether the post is marked as sticky, keeping it pinned to the top of the site's front page.
Link	String	True		The permalink URL for viewing the post on the WordPress site.
FeaturedMediaId	Integer	False		The unique identifier of the media item, such as an image, set as the featured image for the post.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
TaxonomyTerms	String	Specifies the taxonomy terms, such as categories or tags, to be assigned to the post.
Context	String	Defines the request scope, which determines which fields are included in the response, such as view or edit. The allowed values are view, edit, embed.

Create, update, delete, and query Tags to associate with your posts.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Tags WHERE Id NOT IN ('8', '9')
SELECT * FROM Tags WHERE Id = 5
SELECT * FROM Tags ORDER BY Id

Also, ordering by Count, Description, and Name is handled by the WordPress API.

Insert

To insert a tag you must specify the following column: Name.

INSERT INTO Tags (Name, Description) VALUES ('MyTag', 'A tag')

Update

To update a tag you must specify the following column: Id.

UPDATE Tags SET Name = 'Updated name', Description = 'Updated description' WHERE Id = '12345'

Delete

To delete a tag you must specify the following column: Id.

DELETE FROM Tags WHERE Id = '12345'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the tag in WordPress.
Count	Integer	True		The total number of published posts associated with this tag.
Description	String	False		The descriptive text or explanation for the tag, often displayed on tag archive pages.
Link	String	True		The permalink URL for viewing all posts associated with this tag on the WordPress site.
Name	String	False		The display name of the tag as shown in the WordPress admin area or on the site.
Taxonomy	String	True		Specifies the taxonomy type for the term, which for tags is typically 'post_tag'.

Create, update, delete, and list the Users of the website.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud. To retrieve and filter the values for the Roles column, use Context='edit' in the WHERE clause. For example, the following queries are processed server side. Only users that have published posts will be returned.

SELECT * FROM Users WHERE Id IN ('1', '23')
SELECT * FROM Users WHERE Roles IN ('editor, administrator') AND Context='edit'
SELECT * FROM Users ORDER BY Email

Also, ordering by Id, Name, RegisteredDate, and Url is handled by the WordPress API.

Insert and Update

To insert a user you must specify the following columns: Username, Email, and Password.

INSERT INTO Users (Username, Email, Password) VALUES ('DemoUser', '[email protected]', 'aPassword')

Update

To update a user you must specify the following column: Id.

UPDATE Users SET Name = 'First Last' WHERE Id = '12345'

Other fields that you can use on INSERT and UPDATE queries are the following: Username, Name, FirstName, LastName, Email, Url, Description, Locale, Nickname, Roles.

Delete

To delete a user you must specify the following column: Id.

DELETE FROM Users WHERE Id = '12345'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the user account in WordPress.
Username	String	False		The username used by the user to log in to WordPress.
Name	String	False		The display name of the user, shown publicly on posts and comments.
FirstName	String	False		The first name of the user as stored in their WordPress profile.
LastName	String	False		The last name of the user as stored in their WordPress profile.
Email	String	False		The email address associated with the user's account, used for notifications and password resets.
Roles	String	False		The roles assigned to the user, defining their permissions and capabilities. Use with the IN operator and context=edit to filter by role.
Description	String	False		A short biography or description provided in the user's profile.
Locale	String	False		Specifies the user's language and regional setting, based on WordPress locale codes.
Nickname	String	False		An alternate name the user chooses to display instead of their username.
RegisteredDate	Datetime	True		The date and time when the user registered on the WordPress site.
Link	String	True		The author archive URL associated with the user, listing their published posts.
Url	String	False		The website URL provided in the user's profile.
Administrator	Boolean	True		Indicates whether the user has the Administrator role with full site access.
EditPosts	Boolean	True		Indicates whether the user has permission to edit their own posts.
PublishPosts	Boolean	True		Indicates whether the user can publish new posts.
DeletePosts	Boolean	True		Indicates whether the user can delete their own posts.
EditPages	Boolean	True		Indicates whether the user can edit pages on the WordPress site.
PublishPages	Boolean	True		Indicates whether the user can publish new pages.
DeletePages	Boolean	True		Indicates whether the user can delete pages from the site.
EditUsers	Boolean	True		Indicates whether the user can edit other user accounts.
CreateUsers	Boolean	True		Indicates whether the user can create new user accounts.
PromoteUsers	Boolean	True		Indicates whether the user can promote users to higher roles.
DeleteUsers	Boolean	True		Indicates whether the user can delete other user accounts.
EditThemes	Boolean	True		Indicates whether the user can modify theme files or settings.
UpdateThemes	Boolean	True		Indicates whether the user can update installed themes.
InstallThemes	Boolean	True		Indicates whether the user can install new themes.
DeleteThemes	Boolean	True		Indicates whether the user can delete installed themes.
SwitchThemes	Boolean	True		Indicates whether the user can switch the active theme for the site.
ActivatePlugins	Boolean	True		Indicates whether the user can activate installed plugins.
UpdatePlugins	Boolean	True		Indicates whether the user can update existing plugins.
EditPlugins	Boolean	True		Indicates whether the user can edit plugin code or settings.
DeletePlugins	Boolean	True		Indicates whether the user can delete installed plugins.
EditFiles	Boolean	True		Indicates whether the user can edit files directly through the WordPress interface.
UploadFiles	Boolean	True		Indicates whether the user can upload media or other files to the site.
ManageOptions	Boolean	True		Indicates whether the user can manage general site options and settings.
ManageCategories	Boolean	True		Indicates whether the user can manage and organize post categories.
EditDashboard	Boolean	True		Indicates whether the user can customize or edit the WordPress dashboard.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
Password	String	The user's password value, used only during account creation; not returned in responses.
Context	String	Defines the request scope, which determines which fields are included in the response, such as view or edit. The allowed values are view, edit, embed.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - WordPress Views

Name	Description
Taxonomies	List all the taxonomies.
TaxonomyTerms	List all terms of the taxonomies.
Types	List Types associated with the Posts.

List all the taxonomies.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Taxonomies WHERE Slug = 'books'

Columns

Name	Type	References	Description
Hierarchical	Boolean		Indicates whether the taxonomy supports hierarchical relationships, allowing parent and child terms, such as categories.
Name	String		The display name of the taxonomy as registered in WordPress.
Slug [KEY]	String		A URL-friendly identifier for the taxonomy, typically used in permalinks and API requests.
RestBase	String		The base route used in the WordPress REST API for accessing terms within this taxonomy.
Description	String		A text description that explains the purpose or usage of the taxonomy.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
Context	String		Defines the request scope, which determines which fields are included in the response, such as view or edit. The allowed values are view, edit, embed.

List all terms of the taxonomies.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. The Cloud processes other filters client-side within the Cloud. Note: Taxonomy is required to fetch TaxonomyTerms. Use the slug values from the taxonomies view to retrieve the taxonomy column value.

For example, the following queries are processed server side.

SELECT * FROM TaxonomyTerms WHERE Taxonomy = 'books';
SELECT * FROM WordPress.TaxonomyTerms WHERE taxonomy IN ('post_tag','Category');

Columns

Name	Type	References	Description
id	Integer		The unique identifier of the taxonomy term within the specified taxonomy.
Count	Integer		The number of posts or items associated with this taxonomy term.
Link	String		The URL link associated with the taxonomy term, used for navigating to the term's archive or details page.
Name	String		The display name of the taxonomy term, shown in the WordPress admin and on the front-end site.
Slug	String		The URL-friendly identifier for the taxonomy term, used in permalinks and in API requests.
Taxonomy	String		The taxonomy to which this term belongs, such as category, post_tag, or a custom taxonomy.
Parent	Integer		The unique identifier of a parent term in a hierarchy is given, where a value of 0 indicates that there is no parent.
Description	String		A textual description of the taxonomy term, explaining its purpose or providing additional context.

List Types associated with the Posts.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters. The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side.

SELECT * FROM Types WHERE Slug = 'product'

Columns

Name	Type	References	Description
Slug [KEY]	String		The unique slug that identifies the post type in WordPress, used in permalinks and API routes.
Name	String		The display name of the post type, shown in the WordPress admin interface.
Description	String		A short explanation describing the purpose or usage of the post type.
HasArchive	String		Indicates whether the post type supports an archive page that lists all its posts.
IsHierarchical	Boolean		Specifies whether the post type supports parent and child relationships, similar to pages.
IsTemplateLock	Boolean		Indicates whether the post type restricts or locks the editing template in the WordPress block editor.
Icon	String		The icon representing the post type in the WordPress admin menu.
RestBase	String		The base route used for the post type in the WordPress REST API.
RestNamespace	String		The namespace used for the post type within the WordPress REST API.
Taxonomies	String		A list of taxonomies associated with the post type, such as category or post_tag.

Stored procedures are function-like interfaces that extend the functionality of the Cloud beyond simple SELECT/INSERT/UPDATE/DELETE operations with WordPress.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from WordPress, along with an indication of whether the procedure succeeded or failed.

CData Cloud - WordPress Stored Procedures

Name	Description
CreateMedia	Uploads a new media file, such as an image or video, to the WordPress site's media library and attaches it to a specified post or page.
UpdateSettings	Updates the settings of the website.

Uploads a new media file, such as an image or video, to the WordPress site's media library and attaches it to a specified post or page.

Stored Procedure Specific Information

Call this procedure to create media. Note: The Status column only accepts the following values: publish, future, draft, pending, and private. To create a media you must specify the following column: FileLocation. For example:

EXEC CreateMedia Title='MediaTitle', FileLocation='C:/myImages/image.png', Caption='This is an uploaded media.';

Input

Name	Type	Description
Title	String	The title assigned to the media item in WordPress.
Date	Datetime	The date and time to assign to the uploaded media item, based on the site's configured timezone.
DateGMT	Datetime	The date and time to assign to the uploaded media item, expressed in Greenwich Mean Time (GMT).
Status	String	Specifies the publication status of the uploaded media item, such as inherit, publish, or private.
AuthorId	Integer	Specifies the ID of the WordPress user who created or uploaded the media item.
CommentStatus	String	Specifies whether the uploaded media item can receive comments. Supported values include open and closed.
PingStatus	String	Specifies whether the media item accepts pings or trackbacks from external sites.
Caption	String	The caption text to display with the media item in WordPress.
Description	String	The description text for the media item in WordPress.
PostId	Integer	The unique identifier of the post or page that the uploaded media item is associated with or attached to in WordPress.
FileLocation	String	The file path or publicly accessible URL of the media file that uploaded to WordPress.

Result Set Columns

Name	Type	Description
Success	String	Indicates whether the media upload completed successfully.
Id	String	The unique identifier assigned to the media item after it is successfully uploaded to WordPress.

Updates the settings of the website.

Stored Procedure Specific Information

EXECUTE

Call this procedure to update settings. For example:

EXECUTE UpdateSettings Title = 'New Title!'

Input

Name	Type	Description
Title	String	Specifies the title of the WordPress site, displayed in browser titles and across site pages.
Description	String	Defines the site's tagline or short description, often displayed below the title.
Url	String	Specifies the main URL of the WordPress site, used as the base address for all links.
Email	String	The email address of the administrator for notifications and confirmations. Changes must be verified via email before they take effect.
Timezone	String	Specifies the timezone setting for the site by selecting a city in the same region.
DateFormat	String	Defines the default format used for displaying dates across the site.
TimeFormat	String	Defines the default format used for displaying time values across the site.
Language	String	Specifies the site's language using a WordPress locale code, such as en_US.
UseSmilies	Boolean	Determines whether text-based emoticons, such as :-) or :-P, are automatically converted into graphic emojis.
DefaultCategory	Integer	Sets the default category assigned to posts when no category is selected.
DefaultPostFormat	String	Specifies the default post format for new posts, such as standard, aside, or gallery.
PostsPerPage	Integer	Defines the maximum number of posts displayed per blog page or archive page.
DefaultPingStatus	String	Specifies whether pingbacks and trackbacks are allowed for new posts.
DefaultCommentStatus	String	Specifies whether comments are enabled by default for new posts.

The CData Cloud models WordPress data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, describe the schema exposed through the WordPress.com API. The available data depends on your account credentials and access level.

Commonly used tables include:

Table	Description
Categories	Create, update, list, and delete the Categories for the WordPressOnline website.
Comments	Query the comments data.
Media	Get a list of items in the media library.
NavigationMenus	List, update, create, and delete NavigationMenus of the WordPressOnline website.
Posts	Create, update, list, and delete the Posts for the WordPressOnline website.
PublicizeConnection	List all publicizeconnections that the current user has set up and update and delete specified publicize connection.
Tags	Create, update, list, and delete the Tags for the WordPressOnline website.
TaxonomyTerms	Create, update, list, and delete the Taxonomy Terms for the WordPressOnline website.
Users	List the Users of the WordPressOnline website.
CommentLikes	Get the likes information for a comment.
CommentLikeStatus	Get the like status for a comment of the WordPressOnline website.
Follows	List a site's followers in reverse chronological order.
Insights	Query the list of stats/metrics/insights that the current user has access to.
PostTypes	List the PostTypes for the WordPressOnline website.
RecentComments	Get a list of recent comments on a post.
SharingButtons	List and update all the sharing buttons for a site.
SitePostViews	Query the SitePostViews in Wordpress.
SitePublicizeConnection	Query a list of publicize connections that are associated with the specified site.
SiteStats	Query the SiteStats in Wordpress.
SiteStatsSummary	Query the SiteStatsSummary in Wordpress.

Stored Procedures

Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating and uploading media and managing OAuth tokens.

The Cloud models the data in WordPress as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - WordPress Tables

Name	Description
Categories	Returns information about WordPress categories, including their names, descriptions, and post counts.
Comments	Returns comments from WordPress posts, including author details, content, and status information.
KeyRingConnection	Returns information about external service connections and authentication tokens managed through the WordPress Keyring framework.
Media	Get a list of items in the media library.
NavigationMenus	List, Update, Create and Delete NavigationMenus of the WordPressOnline website.
Posts	Create,Update,List and Delete the Posts for the WordPressOnline website.
PublicizeConnection	list all publicizeconnections that the current user has set up and update and delete specified publicize connection.
SiteWidgets	Query and update the active and inactive widgets for a site.
SiteWordAdsSettings	Query and Update detailed WordAds settings information about a site.
SiteWordAdsTos	Get and Update WordAds TOS information about a site.
Tags	Create,Update,List and Delete the Tags for the WordPressOnline website.
TaxonomyTerms	Create,Update,List and Delete the Taxonomy Terms for the WordPressOnline website.
Users	List the Users of the WordPressOnline website.

Returns information about WordPress categories, including their names, descriptions, and post counts.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Slug supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Categories WHERE Slug = 'test'

Insert

To insert a category the following column is required: Name.

INSERT INTO Categories (Description, Name, Parent) VALUES ('This is an example Category', 'myCategory', '138')

Update

To update a category you must specify the following column: Id.

UPDATE Categories SET Name = 'updatedName', Description = 'Updated description.', Parent = 137 WHERE Id = '139'

Delete

To delete a category you must specify the following column: Id.

DELETE FROM Categories WHERE Id = '139'

Columns

Name	Type	ReadOnly	References	Description
Slug	String	True		The slug assigned to the category in WordPress. This is a URL-friendly string derived from the category name and used in site URLs and API endpoints.
ID [KEY]	String	True		A unique integer that identifies the category in WordPress and links posts, tags, and other taxonomy data associated with that category.
Name	String	False		The category name defined in WordPress, representing the label shown on the site and used to organize related posts.
Description	String	False		The descriptive text defined in WordPress for the category, typically used to explain its purpose or the type of posts it contains.
FeedURL	String	True		The URL of the RSS feed for posts in this category.
MetaAggregate	String	False		Contains aggregated metadata for the category, combining key details returned by WordPress.
Parent	Integer	True		The identifier of the parent category that this category belongs to. A value of 0 indicates that the category has no parent.
PostCount	Integer	True		Indicates how many posts are associated with this category in WordPress.

Returns comments from WordPress posts, including author details, content, and status information.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. Note: Status with unapproved or trash as value will not populate using simple SELECT, respective CommentId will be required to populate the values for those Status.

• Id supports the '=' comparison.
• Status supports the '=' comparison.
• Type supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Comments
SELECT * FROM Comments WHERE ID=21
SELECT * FROM Comments WHERE status='approved'

Insert

To insert a comment the following column is required: PostID.

INSERT INTO Comments (Content, Status, PostID) VALUES ('This is an example', 'approved', 21)

Update

To update a comment you must specify the following column: Id.

UPDATE Comments SET  Content= 'Test Comment', Status = 'approved', AuthorEmail = '[email protected]' WHERE ID = 21

Delete

To delete a comment you must specify the following column: ID.

DELETE FROM Comments WHERE ID = 21

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	Int	True		The unique identifier for the comment object in WordPress
Content	String	False		The text content of the comment submitted by the author.
Status	String	False		The approval status of the comment, such as approved, pending, or spam. The allowed values are approved, spam, unapproved, trash.
Type	String	True		Specifies the type of comment, such as a standard comment, trackback, or pingback.
URL	String	True		The website URL associated with the comment or its author.
Date	Datetime	False		The date and time when the comment was posted in WordPress.
ParentID	Int	True		The unique identifier of the parent comment, set to 0 for top-level comments.
ParentLink	String	True		The URL linking directly to the parent comment in WordPress.
ParentType	String	True		he type of object that the parent comment is associated with, such as another comment or a post.
PostID	Int	False		The list of post identifiers associated with the comment in WordPress.
PostLink	String	True		The URL linking to the post or page where the comment was made in WordPress.
PostTitle	String	True		The title of the post or page associated with the comment.
PostType	String	True		The type of post associated with the comment, such as a post, page, or custom post type.
ShortURL	String	True		The shortened URL that links directly to the comment in WordPress.
AuthorAvatarURL	String	True		Specifies the URL of the avatar image representing the comment's author in WordPress.
AuthorEmail	String	False		The email address of the user who authored the comment.
AuthorFirstName	String	True		Specifies the first name of the WordPress user who submitted the comment.
AuthorID	Int	True		Specifies the unique identifier assigned to the WordPress user who created the comment.
AuthorIpAddress	String	True		Records the IP address used by the author when posting the comment to WordPress.
AuthorLastName	String	True		Specifies the last name of the WordPress user who submitted the commen.
AuthorLogin	String	True		Specifies the WordPress username used by the author who submitted the comment.
AuthorName	String	False		The display name of the user who authored the comment in WordPress.
AuthorNiceName	String	True		The URL-friendly version of the author's display name, used in WordPress links or slugs.
AuthorProfileURL	String	True		Provides the link to the comment author's public WordPress profile or user page.
AuthorSiteVisible	Bool	True		Indicates whether the author's site or profile is publicly visible in WordPress.
AuthorURL	String	False		Specifies the website URL submitted by the author when posting the comment.
RawContent	String	True		Contains the raw text of the comment before any HTML rendering, formatting, or sanitization is applied.
CanModerate	Bool	True		Specifies whether the logged-in user can perform moderation actions on the comment, such as approve, edit, or delete.
ILike	Bool	True		Indicates whether the current user has liked the comment.
IReplied	Bool	True		Indicates whether the current user has replied to the comment.
LikeCount	Int	True		Displays the total count of likes or positive reactions associated with the comment in WordPress.
MetaAggregate	String	True		Aggregated metadata for the comment returned by the WordPress API.

Returns information about external service connections and authentication tokens managed through the WordPress Keyring framework.

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	Int	False		The unique identifier of the Keyring connection record.
AdditionalExternalUsers	String	False		The list of additional external users linked to the Keyring connection.
IsExpires	Bool	False		Indicates whether the Keyring connection or its authentication token has an expiration date.
ExternalDisplay	String	False		The display name of the connected external account.
ExternalId	String	False		The unique identifier of the connected external account or service.
ExternalName	String	False		The name of the external account connected through Keyring.
ExternalProfilePicture	String	False		The URL of the profile picture for the connected external account.
Issued	Datetime	False		The date and time when the Keyring connection or token was issued.
Label	String	False		A custom label used to identify the Keyring connection in WordPress.
RefreshURL	String	False		The URL used to refresh or renew the authentication token for the Keyring connection.
Service	String	False		The service associated with the Keyring connection.
Sites	String	False		The list of sites associated with the Keyring connection.
Status	String	False		The current status of the Keyring connection, such as active or expired.
Type	String	False		The type of authentication or connection used for the Keyring integration..
UserId	Int	False		The unique identifier of the WordPress user associated with the Keyring connection.

Get a list of items in the media library.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Id supports the '=' comparison.
• PostId supports the '=' comparison.
• Date supports the '=' comparison.
• MimeType supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Media
SELECT * FROM Media WHERE Id=21

Update

To update a media you must specify the following column: Id.

UPDATE Media SET  Caption= 'Test Caption', Description = 'Sample media' WHERE ID = 183

Delete

To delete a media you must specify the following column: ID.

DELETE FROM Media WHERE ID = 21

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	Integer	True		The unique identifier assigned to the media item within the WordPress site.
Title	String	False		The title of the media file as displayed in the Media Library or attached post.
PostID	Integer	True		The unique identifier of the post or page the media item is attached to. Returns 0 if the media is unattached.
Allowdownload	String	False		Indicates whether the video file is available for download by viewers.
Alt	String	False		The alternative text for the media item, used for accessibility and Search Engine Optimization (SEO) purposes.
AuthorID	Integer	True		The unique identifier of the user who uploaded the media item.
Caption	String	False		A short caption or description displayed with the media item.
Date	Datetime	True		The upload date and time of the media item, recorded in ISO 8601 format.
Description	String	False		A longer description or additional information about the media item.
DisplayEmbed	String	False		Indicates whether the video can be embedded on external sites.
Extension	String	True		The file extension of the media item, such as jpg, mp4, or pdf.
File	String	True		The name of the uploaded media file as stored in WordPress.
GUID	String	True		The globally unique identifier for the media item, often corresponding to the original file URL.
Icon	String	True		A representative icon indicating the file type of the media item.
Length	Integer	True		The duration of the video file, measured in seconds.
MetaAggregate	String	True		Returns aggregated metadata about the media item, including file details and custom fields.
MimeType	String	True		Specifies the file's Multipurpose Internet Mail Extensions (MIME) type, such as image/jpeg or video/mp4.
Rating	String	False		Indicates the content rating of the video, such as suitable for all audiences or restricted.
Size	String	True		The total file size, displayed in a human-readable format such as KB or MB.
URL	String	True		The direct URL for accessing or downloading the uploaded media file.
VideopressGuid	String	True		The unique identifier assigned to the video by VideoPress.
IsVideopressProcessingDone	Boolean	True		Indicates whether VideoPress has finished processing and encoding the uploaded video.
Width	Integer	True		The width of the video or image in pixels.
Height	Integer	True		The height of the video or image in pixels.
ThumbnailsAggregate	String	True		Contains metadata about automatically generated image thumbnails created from the original upload.
ExifAggregate	String	True		Provides EXIF data and camera details captured when the image was taken, if available

List, Update, Create and Delete NavigationMenus of the WordPressOnline website.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Id supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For Example:

SELECT * FROM NavigationMenus where id='780374349';

Insert

To insert new navigation menu, the following column is required: Name.

INSERT INTO NavigationMenus(Name) VALUES('testing');

Update

To update a navigation menu, you must specify the following column: Id.

UPDATE NavigationMenus SET name='updated testing' where id='780374351';

Delete

To delete a navigation menu, you must specify the following column: Id.

DELETE FROM NavigationMenus where id='780374351';

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Int	True		The unique identifier of the navigation menu within the WordPress site.
Name	String	False		The display name of the navigation menu as it appears in the WordPress admin or site theme.
Description	String	False		A short summary or purpose of the navigation menu, typically defined by the site administrator.
Items	String	False		Includes details about each menu item, such as its ID, type, content reference, and any applicable nested child items.
Locations	String	False		Specifies the theme locations where the menu can be assigned, such as header, footer, or sidebar.

Create,Update,List and Delete the Posts for the WordPressOnline website.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Id supports the '=' comparison.
• AuthorId supports the '=' comparison.
• Date supports the '<', '>' comparisons.
• Modified supports the '<', '>' comparisons.
• Slug supports the '=' comparison.
• Status supports the '=' comparison.
• Sticky supports the '=' comparison.
• Type supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Posts
SELECT * FROM Posts WHERE ID=21

Insert

To insert a post :

INSERT INTO Posts (Title, Content, Excerpt) VALUES ('Post title', 'Post content', 'Post Excerpt')

Update

To update a post you must specify the following column: ID.

UPDATE Posts SET  Title= 'Modified post title', Content = 'Modified content', Excerpt = 'Modified excerpt' WHERE ID = 21

Delete

To delete a post you must specify the following column: ID.

DELETE FROM Posts WHERE ID = 21

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	Int	False		The unique identifier of the post.
SiteID	Int	False		The unique identifier of the WordPress site that the post belongs to.
AuthorAvatarURL	String	False		The URL of the author's profile avatar image.
IsAuthorEmailAvailable	Boolean	False		Indicates whether the author's email address is available.
AuthorFirstName	String	False		The first name of the post's author.
AuthorID	Int	False		The unique identifier of the author who created the post.
AuthorLastName	String	False		The last name of the post's author.
AuthorLogin	String	False		The author's WordPress username used to log in.
AuthorName	String	False		The display name of the post's author.
AuthorNiceName	String	False		The URL-friendly version of the author's username.
AuthorProfileURL	String	False		The URL of the author's public WordPress profile page.
AuthorSiteID	Int	False		The site ID associated with the author.
AuthorURL	String	False		The personal website URL provided by the author, if any.
Date	Datetime	False		The date and time when the post was created in the site's local timezone.
Modified	Datetime	False		The date and time when the post was last updated.
Title	String	False		The title of the post as displayed on the site.
ItemURL	String	False		The full permalink URL of the post.
ShortURL	String	False		The wp.me shortlink that provides a shortened version of the post URL.
Content	String	False		The full HTML content of the post.
Excerpt	String	False		A short excerpt or summary of the post content.
Slug	String	False		The URL-friendly slug used to identify the post.
Guid	String	False		The globally unique identifier (GUID) for the post, often representing its original permalink.
Status	String	False		The publication status of the post, such as publish, draft, pending, private, future, trash, or auto-draft. The allowed values are publish, private, draft, pending, future, trash, any.
IsSticky	Boolean	False		Indicates whether the post is marked as sticky and displayed at the top of the blog.
Password	String	False		The plaintext password used to protect the post, or an empty string if the post is not password-protected.
HasParent	Boolean	False		Indicates whether the post has a parent post (for example, a child page).
Type	String	False		The post type for this entry, such as post, page, or a custom post type allowed by the REST API.
DiscussionCommentCount	Int	False		The total number of comments associated with the post.
DiscussionCommentStatus	String	False		Indicates the current comment status for the post, such as open or closed.
HasDiscussionCommentsOpen	Boolean	False		Indicates whether new comments can be added to the post.
DiscussionPingStatus	String	False		Shows whether pingbacks and trackbacks are enabled for the post.
HasDiscussionPingsOpen	Boolean	False		Indicates whether the post accepts pingbacks.
HasLikesEnabled	Boolean	False		Indicates whether likes are enabled for the post.
HasSharingEnabled	Boolean	False		Indicates whether sharing buttons are enabled for the post.
LikeCount	Int	False		The total number of likes that the post has received.
ILike	Boolean	False		Indicates whether the authenticated user has liked the post.
IsFollowing	Boolean	False		Indicates whether the authenticated user is following the site where the post appears.
IsReblogged	Boolean	False		Indicates whether the authenticated user has reblogged this post.
GlobalID	String	False		A globally unique identifier representing the post across the entire WordPress.com network.
FeaturedImage	String	False		The URL of the post's featured image, if one is set.
PostThumbnail	String	False		The attachment object representing the featured image, if available.
Format	String	False		The display format of the post, such as standard, aside, gallery, image, quote, status, video, or audio.
HasGeo	Boolean	False		Indicates whether the post includes geolocation data.
MenuOrder	Int	False		Defines the order of pages or hierarchical posts in navigation menus.
PageTemplate	String	False		The page template assigned to this post or page.
PublicizeURLsAggreagtes	String	False		A list of URLs where the post was automatically shared via Publicize connections, such as Facebook or Twitter.
CategoriesAggregates	String	False		A set of categories, organized by name, that are assigned to the post.
TermsCategoryAggregates	String	False		A collection of taxonomy terms grouped by category name and keyed by term name.
TermsPostTagAggregates	String	False		A collection of taxonomy terms grouped by post tags and keyed by tag name.
TermsPostFormatAggregates	String	False		A collection of taxonomy terms grouped by post format and keyed by format name.
TermsMentionsAggregates	String	False		A collection of taxonomy terms related to user or site mentions in the post.
TagsAggregates	String	False		A set of tags, organized by tag name, that are applied to the post.
Attachments	String	False		A collection of post attachments organized by attachment ID. It returns up to 20 of the most recent attachments.
AttachmentCount	Int	False		The total number of attachments associated with the post.
MetadataAggregates	String	False		An array of key-value pairs representing the post's custom metadata fields.
HasCapabilitiesDeletePost	Boolean	False		Indicates whether the authenticated user has permission to delete the post.
HasCapabilitiesEditPost	Boolean	False		Indicates whether the authenticated user has permission to edit the post.
HasCapabilitiesPublishPost	Boolean	False		Indicates whether the authenticated user has permission to publish the post.

list all publicizeconnections that the current user has set up and update and delete specified publicize connection.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Name supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

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.

Query and update the active and inactive widgets for a site.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Id supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM SiteWidgets WHERE Id = 'block-1'

Update

To update a SiteWidgets you must specify the following column: Id.

UPDATE SiteWidgets SET Position = 5 WHERE Id = 'block-1'

Delete

To delete a SiteWidgets you must specify the following column: Id.

DELETE FROM SiteWidgets WHERE Id = '139'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier assigned to the widget instance.
IdBase	String	True		The base identifier shared by all instances of this widget type.
Position	Integer	False		The widget's display order within its assigned sidebar.
Sidebar	String	False		The identifier of the sidebar where the widget is currently active.
SettingsAggregate	String	False		A collection of configuration settings that define the widget's behavior and appearance.

Query and Update detailed WordAds settings information about a site.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud.

SELECT * FROM SiteWordAdSettings

Update

To update a site word ad settings you must specify the following Site ID column: ID, PayPalAddress. Incase the Terms of Service have not been signed, it will be required for Update. The API will always return a single record for the site, depending on the URL specified in the connection string.

UPDATE SiteWordAdSettings SET  PayPalAddress= '[email protected]', TermsOfService='signed' WHERE ID = 241575003

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	Integer	True		The unique identifier of the site associated with the WordAds settings.
Name	String	True		The display name or title of the WordPress site.
ItemURL	String	True		The full URL of the site whose WordAds settings are being managed.
IsSettingsOptimizedAds	Boolean	True		Indicates whether ad placement is optimized automatically by WordAds for better performance.
IsSettingsDisplayOptionsDisplayArchive	Boolean	False		Determines whether ads are displayed on archive pages such as category or tag listings.
IsSettingsDisplayOptionsDisplayFrontPage	Boolean	True		Determines whether ads appear on the site's front page or homepage.
IsSettingsDisplayOptionsDisplayPage	Boolean	True		Determines whether ads are displayed on static pages.
IsSettingsDisplayOptionsDisplayPost	Boolean	True		Determines whether ads are shown on individual post pages.
IsSettingsDisplayOptionsEnableHeaderAd	Boolean	True		Specifies whether a header ad is enabled at the top of the site.
IsSettingsDisplayOptionsInlineEnabled	Boolean	True		Specifies whether inline ads (within content) are enabled.
IsSettingsDisplayOptionsSidebar	Boolean	True		Specifies whether sidebar ads are enabled.
IsSettingsDisplayOptionsSecondBelowpost	Boolean	True		Specifies whether an additional ad unit appears below post content.
PayPalAddress	String	False		The PayPal email address associated with WordAds payouts.
TermsOfService	String	False		Indicates whether the WordAds Terms of Service have been accepted. Required for enabling or updating ad settings if not yet signed.
ShowToLoggedIn	String	False		Specifies whether ads should be shown to logged-in users.
IsCCPAEnabled	Boolean	False		Enables or disables targeted advertising for visitors in California, in compliance with the California Consumer Privacy Act (CCPA).
CCPAPrivacyPolicyURL	String	False		The URL displayed at the bottom of the CCPA notice pop-up, linking to the site's privacy policy. A pop-up window opens in a new browser tab, while a pop-up dialog box appears as an overlay on the same page.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
DisplayOptionsAggregate	String	A collection of ad display settings that define where ads appear, including enable_header_ad, second_belowpost, sidebar, and display options for front_page, post, page, and archive.

Get and Update WordAds TOS information about a site.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud.

SELECT * FROM SiteWordAdsTos

Update

To update a site word ad terms of service you must specify the following Site ID column: ID and TermsOfService

UPDATE SiteWordAdsTos SET TermsOfService='true' WHERE ID = 241575003

Columns

Name	Type	ReadOnly	References	Description
ID [KEY]	Int	True		The unique identifier of the site associated with the WordAds Terms of Service.
name	String	True		The display name or title of the WordPress site.
ItemURL	String	True		The full URL of the site linked to the WordAds Terms of Service agreement.
TOS	String	False		The WordAds Terms of Service text or agreement status for the site.
SettingsAggregate	String	False		A collection of WordAds Terms of Service settings and related compliance details, viewable only by users with post-editing permissions on the site.

Create,Update,List and Delete the Tags for the WordPressOnline website.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Slug supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Tags
SELECT * FROM Tags WHERE Slug='tagTest'

Insert

To insert a tag, following columns are required : Name

INSERT INTO Tags (Slug, Name, Description) VALUES ('tagtest', 'Tag name', 'Tag Description')

Update

To update a tag you must specify the following column: Slug.

UPDATE Tags SET  Name= 'Modified tag name', Description = 'Modified tag description' WHERE Slug='tagTest'

Delete

To delete a tag you must specify the following column: Slug.

DELETE FROM Tags WHERE Slug='tagTest'

Columns

Name	Type	ReadOnly	References	Description
Slug [KEY]	String	True		The URL-friendly identifier (slug) for the tag.
ID	Int	True		The unique numeric identifier assigned to the tag.
Name	String	False		The display name of the tag as shown in WordPress.
Description	String	False		A brief explanation or summary of what the tag represents.
FeedUrl	String	False		The RSS feed URL associated with this tag.
PostCount	Int	False		The total number of posts currently assigned to this tag.

Create,Update,List and Delete the Taxonomy Terms for the WordPressOnline website.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Taxonomy supports the '=' comparison.
• Slug supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud. For example, the following queries are processed server side:

SELECT * FROM TaxonomyTerms WHERE Taxonomy='post_tag'
SELECT * FROM TaxonomyTerms WHERE Slug='tagTest'
SELECT * FROM TaxonomyTerms WHERE Taxonomy='post_tag';
SELECT * FROM TaxonomyTerms WHERE Taxonomy='post_tag' and Slug='tagTest';

INSERT

To insert a taxonomy term, the following column is required: Taxonomy.

INSERT INTO TaxonomyTerms (Slug, Name, Taxonomy) VALUES ('tagtest', 'Taxonomy term name', 'post_tag')

UPDATE

To update a taxonomy term you must specify the following columns: Taxonomy and Slug.

UPDATE TaxonomyTerms SET  Name= 'Modified taxonomy term name', Description = 'Modified taxonomy term description' WHERE Taxonomy='post_tag' AND Slug='tagTest'

DELETE

To delete a taxonomy term you must specify the following columns: Taxonomy and Slug.

DELETE FROM TaxonomyTerms WHERE Taxonomy='post_tag' AND Slug='tagTest'

Columns

Name	Type	ReadOnly	References	Description
Slug [KEY]	String	True		The URL-friendly identifier (slug) for the taxonomy term.
Taxonomy	String	False	TaxonomyPostType.Name	The taxonomy this term belongs to, such as category, post_tag, or a custom taxonomy.
Description	String	False		A brief explanation or summary describing the purpose or meaning of the term.
FeedUrl	String	False		The RSS feed URL associated with this taxonomy term.
ID	Int	True		The unique numeric identifier assigned to the taxonomy term.
Name	String	False		The display name of the taxonomy term as it appears in WordPress.
Parent	Int	False		The ID of the parent term if this term is part of a hierarchical taxonomy.
PostCount	Int	False		The total number of posts currently assigned to this taxonomy term.

List the Users of the WordPressOnline website.

Table Specific Information

Select

The Cloud uses the WordPress API to process supported filters.

• Id supports the '=' comparison.
• SiteId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Users WHERE Id = 1
SELECT * FROM Users WHERE SiteId = 1255

Also, ordering by Id, and SiteId is handled by the WordPress API.

Update

To update a user you must specify the following column: Id.

UPDATE Users SET name = 'First Last' WHERE Id = '12345'

Delete

To delete a user you must specify the following column: Id.

DELETE FROM Users WHERE Id = '12345'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the user.
SiteID	Integer	True		The unique identifier of the WordPress site the user belongs to.
FirstName	String	False		The user's first name as displayed in their WordPress profile.
LastName	String	False		The user's last name as displayed in their WordPress profile.
Email	String	False		The email address associated with the user's WordPress account.
AvatarURL	String	True		The URL of the user's avatar image.
Name	String	False		The display name of the user, typically shown on posts and comments.
NiceName	String	False		A sanitized, URL-friendly version of the user's display name.
ProfileURL	String	True		The full URL to the user's public WordPress profile page.
Roles	String	False		A list of roles assigned to the user, such as administrator, editor, author, or subscriber.
IPAddress	String	True		The IP address associated with the user's activity.
IsSuperAdmin	Boolean	True		Indicates whether the user has network-level administrative privileges (Super Admin) in a multisite environment.
Login	String	False		The username used by the user to log in to WordPress.
IsSiteVisible	Boolean	True		Indicates whether the user's site is visible to the public.
ItemURL	String	False		The full URL of the user's primary WordPress site.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - WordPress Views

Name	Description
AuditHistoryforComments	Returns a history of changes and status updates for comments in WordPress.
BlogRecommendations	Returns a list of recommended WordPress blogs based on user interests or activity.
ClickEmails	Returns data about links clicked in WordPress emails, including the email ID, URL, and time of each click.
CommentCounts	Returns the total number of comments for WordPress posts, including counts by status such as approved, pending, and spam.
CommentLikes	Returns information about likes on WordPress comments, including the number of likes each comment has received.
CommentLikeStatus	Returns the like status of WordPress comments for the current user, including whether each comment has been liked.
DropDownPages	Returns a list of WordPress pages, including their IDs and titles, for use in dropdown selections.
EmailSettings	Returns the email configuration settings for the WordPress site, including sender details and notification preferences.
Feed	Returns metadata and subscription information for a specific feed in the WordPress Reader.
Follows	Returns a list of WordPress blogs or sites followed by the current user, including their Ids, names, and URLs.
Insights	Returns analytical data and performance insights for the WordPress site, including views, visitors, likes, and comments.
MatchingFeeds	Get the MatchingFeeds for a blog.
OpenEmails	Query the OpenEmails in Wordpress.
PostReblogStatus	Get reblog status for a post.
PostsTags	List the UserLikedPosts for the WordPressOnline website.
PostTypes	List the PostTypes for the WordPressOnline website.
ReaderMenuDefault	Default menu items from the WordPress Reader Menu.
ReaderMenuRecommended	Recommended topics from the WordPress Reader Menu.
ReaderMenuSubscribed	Subscribed topics from the WordPress Reader Menu.
RecentComments	Get a list of recent comments on a post.
SharingButtons	list and update all the sharing buttons for a site.
SiteCountryViews	Query the SiteCountryViews in Wordpress.
SiteEmailSummary	Query the SiteEmailsSummary in Wordpress.
SiteFileDownloads	Query the SiteFileDownloads in Wordpress.
SiteFollowers	Query the SiteFollowers in Wordpress.
SiteOutboundClicks	Query the SiteOutboundClicks in Wordpress.
SitePosts	List the UserSitesPosts for the WordPressOnline website.
SitePostViews	Query the SitePostViews in Wordpress.
SitePublicizeConnection	Query a list of publicize connections that are associated with the specified site.
SitePublicizeFollowerComment	List the SitePublicizeFollowerComment for the WordPressOnline website.
SitePublicizeFollowerCounts	List the SitePublicizeFollowerCounts for the WordPressOnline website.
Sites	Query information about a site.
SiteSearchTerms	Query the SiteSearchTerms in Wordpress.
SiteShortCodesRender	Get a rendered shortcode for a site
SitesPageTemplates	Get a list of page templates supported by a site.
SiteStats	Query the SiteStats in Wordpress.
SiteStatsReferrers	Query the SiteStatsReferrers in Worpress.
SiteStatsSummary	Query the SiteStatsSummary in Wordpress.
SiteStatsTags	Get the SiteStatsTags for a blog.
SiteStatsVideo	Query the SiteStatsVideo in Wordpress.
SiteTopAuthors	Query the SiteTopAuthors in Wordpress.
SiteTopComments	Query the SiteTopComments in Wordpress.
SiteTopPostsStats	Query the SiteTopPostsStats in Wordpress.
SiteTotalViewsforPost	Query the SiteTotalViewsforPost in Wordpress.
SiteVideoPlays	Query the SiteVideoPlays in Wordpress.
SiteWordAdsEarnings	List the SiteWordAdsEarnings for the WordPressOnline website.
SiteWordAdsStats	List the SiteWordAdsStats for the WordPressOnline website.
StatHighlights	Query the StatHighlights for a site in Wordpress.
SubscriberPosts	List the SubscriberPosts for the WordPressOnline website.
SubscriptionCount	Get the SubscriptionCount for a blog.
TaxonomyPostType	Get a list of taxonomies associated with a post type.
TopTags	Get a filtered list of top tags, grouped by letter.
TrendingTags	Get a list of trending tags.
UserBillingHistory	Query the Billing History in Wordpress.
UserFollowedPosts	List the UserFollowedPosts for the WordPressOnline website.
UserFollowingFeeds	Query the info about the user following feeds.
UserLikedPosts	List the UserLikedPosts for the WordPressOnline website.
UserLikes	Query the info about the posts liked by the user.
UserPreferences	Update and List the UserPreferences for the WordPressOnline website.
UserSitesPosts	List the UserSitesPosts for the WordPressOnline website.
UserSubscribedTags	Get a list of tags subscribed to by the user
VideoPoster	Get the poster for a specified VideoPress video.
VideopressChapter	Get the chapters for a specified VideoPress video of the WordPressOnline website.
Videos	Get the metadata for a specified VideoPress video.

Returns a history of changes and status updates for comments in WordPress.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters. Note: Events with status-trash or status-unapproved will not populate using simple SELECT, respective CommentId will be required to populate the values for those Events.

• CommentId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM AuditHistoryforComments WHERE CommentId = 10

Columns

Name	Type	References	Description
CommentId	Int	Comments.Id	Specifies the identifier of the comment whose changes are recorded in the audit history.
Event	String		The type of action recorded for the comment, such as create, update, or delete. The allowed values are check-ham, status-approved, status-trash, status-unapproved.
Time	Timestamp		The timestamp when the event related to the comment occurred.
User	String		The user who performed the action recorded in the audit log.

Returns a list of recommended WordPress blogs based on user interests or activity.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud.

SELECT * FROM BlogRecommendations

Columns

Name	Type	References	Description
BlogId [KEY]	Int		The unique identifier for the recommended blog returned by WordPress.
BlogDomain	String		The domain associated with the recommended WordPress blog, typically representing the blog's public web address (for example, example.wordpress.com).
EmailFollowUrl	String		The URL used to follow the recommended blog via email.
FeedId	String		The unique identifier for the feed associated with the recommended blog.
FollowRecoId	String		The unique identifier for the blog recommendation record returned by WordPress.
FollowSource	String		The source that generated the blog recommendation, such as user activity or followed topics.
Image	String		The URL of the image representing the recommended blog.
MetaAggregate	String		Aggregated metadata for the recommended blog returned by WordPress.
Nonce	String		A security token used by WordPress to validate the blog recommendation request.
Reason	String		The reason this blog was recommended, such as shared topics or related content.
Score	Double		The relevance score assigned to the recommended blog based on WordPress's recommendation algorithm.
Title	String		Specifies the title or display name of the recommended blog as returned by WordPress.
TitleShort	String		The short version of the blog's title returned by WordPress, typically used in compact views or recommendation summaries.
ItemURL	String		Specifies the full URL of the recommended blog's homepage as returned by WordPress.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
NoOfBlogRecommendations	Int		The number indicating the blog's position in the list of recommendations returned by WordPress.

Returns data about links clicked in WordPress emails, including the email ID, URL, and time of each click.

Table Specific Information

SELECT

View chart stats related to email clicks by period. Note: To view chart stats related to email clicks by period, you must specify the following column in the where clause: PostId.

• PostId supports the '=' comparison.
• ClickEmailSummaryDate supports the '=' comparison.
• ClickEmailSummaryPeriod supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example,

SELECT * FROM ClickEmails where POSTID=116;

Columns

Name	Type	References	Description
PostID [KEY]	Int		The unique identifier of the post associated with the clicked email link.
TimelineDataAggregate	String		Contains aggregated data showing when and how the email link was clicked over time.
TimelineFieldsAggregate	String		The array of timeline fields that describe details of the email click event.
TimelineUnit	String		The unit of measurement used to organize the email click event timeline.

Returns the total number of comments for WordPress posts, including counts by status such as approved, pending, and spam.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• PostId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM CommentCounts WHERE PostId = 21

Columns

Name	Type	References	Description
All	Int		Represents the total count of all comments on the post, regardless of status such as, approved, pending, spam, or trash.
Approved	Int		The number of approved comments for the post.
Pending	Int		The number of comments on the post that are awaiting moderation.
Trash	Int		The number of comments for the post that have been moved to the trash.
Spam	Int		The number of comments on the post that are marked as spam.
PostTrashed	Int		Indicates whether the associated post has been moved to the trash in WordPress.
TotalComments	Int		The total number of comments associated with the post across all statuses.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
PostId	Int		The unique identifier of the post for which the comment counts are summarized.

Returns information about likes on WordPress comments, including the number of likes each comment has received.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• CommentId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM CommentLikes WHERE CommentId = 10

Columns

Name	Type	References	Description
CommentId [KEY]	Int	Comments.Id	The unique identifier of the comment that received the like.
ID [KEY]	Int		The unique identifier of the user who liked the comment.
Name	String		The display name of the user who liked the comment.
Login	String		The WordPress username of the user who liked the comment.
Email	String		The email address of the user who liked the comment.
IPAddress	String		The IP address from which the comment was liked.
FirstName	String		The first name of the user who liked the comment.
LastName	String		The last name of the user who liked the comment.
NiceName	String		The URL-friendly version of the user's display name used in WordPress profile links.
SiteID	Int		The unique identifier of the site associated with the user who liked the comment.
IsSiteVisible	Bool		Indicates whether the site associated with the user is publicly visible in WordPress.
ProfileURL	String		The URL linking to the WordPress profile of the user who liked the comment.
DefaultAvatar	Bool		Indicates whether the user is using the default WordPress avatar image.
AvatarURL	String		The URL of the avatar image for the user who liked the comment.
ItemURL	String		The URL linking directly to the comment that was liked.
MetaAggregate	String		Aggregated metadata for the comment like record returned by the WordPress API.

Returns the like status of WordPress comments for the current user, including whether each comment has been liked.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• CommentId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM CommentLikeStatus WHERE CommentID = 0

Columns

Name	Type	References	Description
ILike	Bool		Indicates whether the current user has liked the comment.
LikeCount	Int		The total number of likes the comment has received in WordPress.
MetaAggregate	String		Aggregated metadata describing the like status for a comment, as provided by the WordPress API.
CommentID	Int	Comments.Id	The unique identifier of the comment associated with the like status.

Returns a list of WordPress pages, including their IDs and titles, for use in dropdown selections.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud.

SELECT * FROM DropDownPages

Columns

Name	Type	References	Description
ID [KEY]	Int		Specifies the unique ID assigned to the WordPress page, used for selection in dropdown lists or references.
Title	String		Specifies the title of the WordPress page displayed in dropdown selections.

Returns the email configuration settings for the WordPress site, including sender details and notification preferences.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud. For example,

SELECT * FROM EmailSettings;

Columns

Name	Type	References	Description
MailOption	String		The selected email delivery option or method configured for WordPress notifications.
DeliveryDay	Int		The day of the week scheduled for WordPress email delivery.
DeliveryHour	Int		The hour of the day scheduled for WordPress email delivery.
IsEmailBlocked	Bool		Indicates whether WordPress email delivery is blocked or disabled.
Frequency	String		The frequency at which WordPress email notifications are sent.

Returns metadata and subscription information for a specific feed in the WordPress Reader.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• FeedId supports the '=' comparison.
• FeedURL supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM Feed where FeedID='12'
SELECT * FROM Feed where FeedURL='url_string'

Columns

Name	Type	References	Description
FeedID [KEY]	String		Specifies the unique identifier assigned to the feed in WordPress, used to identify and retrieve feed entries.
FeedURL	String		Specifies the web address of the RSS or Atom feed associated with the WordPress site.
BlogID	String		Specifies the WordPress blog ID from which the feed originates.
Description	String		Provides a summary or description of the feed's content, as defined in WordPress.
Image	String		Specifies the image or logo representing the WordPress feed, typically displayed with feed entries.
IsFollowing	Bool		Indicates whether the current user is following the WordPress feed.
LastChecked	Datetime		Records the most recent timestamp when WordPress checked the feed for new content.
LastUpdate	Datetime		Indicates the most recent timestamp when the feed's content was updated or new entries were published.
Name	String		Specifies the name or display title of the feed, typically corresponding to the WordPress site or blog title.
NextRefreshTime	Datetime		Specifies the next scheduled time when WordPress refreshes the feed to check for new content.
OrganizationID	Int		Specifies the WordPress organization or site network ID linked to the feed, if applicable.
ResolvedFeedURL	String		Specifies the fully resolved URL of the WordPress feed after processing any redirects or canonical references.
SubscribersCount	Int		Indicates how many WordPress users are currently subscribed to the feed.
SubscriptionID	String		Specifies the WordPress subscription ID associated with the user's connection to the feed.
UnseenCount	Int		Indicates how many feed entries have not yet been viewed by the user in WordPress.
URL	String		Specifies the web address of the WordPress site or source from which the feed content originates.
IsMarkedForRefresh	Bool		Indicates whether the feed is marked for manual or immediate refresh in WordPress.
MetaAggregate	String		Aggregated metadata for the WordPress feed, including additional details returned by the API.

Returns a list of WordPress blogs or sites followed by the current user, including their Ids, names, and URLs.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud. For example,

SELECT * FROM Follows;

Columns

Name	Type	References	Description
ID [KEY]	String		The unique identifier of the blog or user being followed in WordPress.
Login	String		Specifies the WordPress username of the account that the current user is following.
Name	String		The display name of the blog or user being followed.
NiceName	String		The URL-friendly version of the blog or user's name used in WordPress profile URLs.
ItemURL	String		The URL of the WordPress blog or user profile being followed.
AvatarURL	String		The URL of the avatar image for the blog or user being followed.
ProfileURL	String		The URL linking to the public profile of the blog or user being followed.
IsIpAddressAvailable	Boolean		Indicates whether the IP address of the followed user or site is available in WordPress.
SiteID	Int		The unique identifier of the WordPress site being followed.
IsSiteVisible	Boolean		Indicates whether the site being followed is publicly visible.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
NoOfFollowers	Int		The total number of followers subscribed to the WordPress site or user.

Returns analytical data and performance insights for the WordPress site, including views, visitors, likes, and comments.

Table Specific Information

SELECT

The Cloud processes all the filters client-side within the Cloud.

SELECT * FROM Insights

Columns

Name	Type	References	Description
ID [KEY]	Int		The unique identifier of the WordPress site associated with the insights data.
Name	String		The name or title of the WordPress site associated with the insights.
HasCustom	Bool		Indicates whether the site has custom insights or analytics settings configured.
TodayApiInsightsCommentsNumber	Int		The number of comments recorded on the site today according to API insights.
TodayApiInsightsCommentsPercent	String		The percentage change in comment activity today compared to the previous period.
TodayApiInsightsConnectionsNumber	Int		The total number of new site connections recorded today.
TodayApiInsightsConnectionsPercent	String		The percentage change in new site connections today compared to the previous period.
TodayApiInsightsLikesNumber	Int		The total number of likes recorded on the site today.
TodayApiInsightsLikesPercent	String		The percentage change in likes today compared to the previous period.
TodayApiInsightsPostsNumber	Int		The total number of posts published on the site today.
TodayApiInsightsPostsPercent	String		The percentage change in post publishing activity today compared to the previous period.
TodayRestApiCallsNumber	Int		The total number of REST API calls made to the WordPress site today.
TodayRestApiCallsPercent	String		The percentage change in REST API call activity today compared to the previous period.
TodayRestApiErrorsNumber	Int		The total number of REST API errors that occurred on the site today.
TodayRestApiErrorsPercent	String		The percentage change in REST API errors today compared to the previous period.
TodayRestApiReadsNumber	Int		The total number of REST API read (GET) requests made to the site today.
TodayRestApiReadsPercent	String		The percentage change in REST API read (GET) requests today compared to the previous period.
TodayRestApiWritesNumber	Int		The total number of REST API write (POST, PUT, DELETE) requests made to the site today.
TodayRestApiWritesPercent	String		The percentage change in REST API write requests today compared to the previous period.

Get the MatchingFeeds for a blog.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

Note: To query the MatchingFeeds, you must specify the either of the following columns in the WHERE clause: QueryText, ItemUrl.

• FeedId supports the '=' comparison.
• QueryText supports the '=' comparison.
• ItemUrl supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example:

SELECT * FROM MatchingFeeds WHERE QueryText='test';
SELECT * FROM MatchingFeeds WHERE ItemUrl='http://www.thebereantest.com'
SELECT * FROM MatchingFeeds WHERE QueryText='test' 
SELECT * FROM MatchingFeeds WHERE ItemUrl='http://www.thebereantest.com'

Columns

Name	Type	References	Description
FeedID [KEY]	String		The unique identifier of the feed associated with a WordPress site or blog.
SubscribeURL	String		The URL used to subscribe to the feed or follow updates from the site.
MetaAggregate	String		Returns aggregated metadata about the feed, such as title, description, and site details.
RailCarAggregate	String		Provides structured feed data returned from the Reader service for the specified site.
ItemURL	String		Specifies the domain or site URL used to retrieve the corresponding feed ID. This value must be URL-encoded.

Pseudo-Columns

Pseudo-column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the data returned by the operation.

Name	Type	Description
QueryText	String		Specifies the search text or keywords used to query and match relevant feeds.

Query the OpenEmails in Wordpress.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• PostId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example,

SELECT * FROM OpenEmails where PostId='157';

Columns

Name	Type	References	Description
PostID [KEY]	Int		The unique identifier of the WordPress post associated with the email campaign.
ClientsAggregate	String		Returns aggregated information about the email clients used to open the campaign messages.
ClientsDataAggregate	String		Contains detailed data for each email client, including open counts and usage distribution.
ClientsFieldsAggregate	String		Provides field-level information describing the structure of the client data returned.
CountriesAggregate	String		Returns aggregated statistics grouped by country, showing where emails were opened.
CountriesDataAggregate	String		Contains detailed country-level data for email opens, such as open counts and percentages.
CountriesFieldsAggregate	String		Provides field definitions and labels for the country-based email analytics data.
CountriesInfoAggregate	String		Lists all countries included in the email analytics report.
DevicesAggregate	String		Returns aggregated data showing which devices were used to open the emails, such as mobile, desktop, or tablet.
DevicesDataAggregate	String		Contains detailed device-level data for email opens and engagement activity.
DevicesFieldsAggregate	String		Provides field definitions and labels for the device-related data returned.
OpensRate	Int		The average rate at which emails were opened during the reporting period.
TotalOpens	Int		The total number of email opens recorded during the reporting period.
TotalSends	Int		The total number of emails sent during the reporting period.
UniqueOpens	Int		The number of distinct recipients who opened the email at least once.
OpensRateOpensRate	Int		Represents the calculated open rate for the campaign or reporting period.
OpensRateTotalOpens	Int		Represents the total number of email opens used to calculate the open rate.
OpensRateTotalSends	Int		Represents the total number of sent emails used to calculate the open rate.
OpensRateUniqueOpens	Int		Represents the number of unique opens used to calculate the open rate.
TimelineDataAggregate	String		Contains time-based email performance data, including open and send counts across defined periods.
TimelineFieldsAggregate	String		Provides metadata and field descriptions for the timeline-based data returned.
TimelineUnit	String		Specifies the time unit used in the timeline, such as hour, day, week, month, or year.
NumberofPeriods	Int		Specifies how many time periods to include in the timeline report.
Period	String		Determines the time range used for the report, such as past hours, days, weeks, months, or years.
Date	Date		Specifies the most recent date to include in the email analytics report.
StatsFields	String		A comma-separated list of specific statistical fields to return in the response, such as TotalOpens or UniqueOpens.

Get reblog status for a post.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• PostId supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM PostReblogStatus where PostId=21

Columns

Name	Type	References	Description
PostId [KEY]	Int	Posts.Id	The unique identifier of the WordPress post for which the reblog status is being checked.
CanReblog	Bool		Indicates whether the post is eligible to be reblogged by any WordPress user.
CanUserReblog	Bool		Indicates whether the authenticated user has permission to reblog the specified post.
IsReblogged	Bool		Shows whether the authenticated user has already reblogged this post.
MetaAggregate	String		Contains additional metadata returned from the WordPress API related to the PostReblogStatus endpoint.

List the UserLikedPosts for the WordPressOnline website.

Table Specific Information

SELECT

The Cloud uses the WordPress API to process some of the filters.

• Date supports the '<', '>' comparisons.
• Modified supports the '<', '>' comparisons.
• Status supports the '=' comparison.
• Type supports the '=' comparison.

The Cloud processes other filters client-side within the Cloud.

For example, the following queries are processed server side.

SELECT * FROM PostsTags
SELECT * FROM PostsTags where Status='publish'
SELECT * FROM PostsTags where Type='post'

Columns

Name	Type	References	Description
ID [KEY]	Integer	Posts.Id	The unique identifier of the post.
SiteID	Integer		The unique identifier of the WordPress site that the post belongs to.
AuthorID	Int		The unique identifier of the author who created the post.
DateRangeBefore	String		Filters results to posts created before the specified date.
DateRangeAfter	String		Filters results to posts created after the specified date.
AuthorLogin	String		The username of the post's author.
IsAuthorEmailAvailable	Boolean		Indicates whether the author's email address is available.
AuthorName	String		The display name of the post's author.
AuthorAvatarURL	String		The URL of the author's avatar image.
AuthorFirstName	String		The first name of the post's author.
AuthorLastName	String		The last name of the post's author.
AuthorNiceName	String		The URL-friendly version of the author's username.
AuthorProfileURL	String		The URL of the author's public WordPress profile page.
AuthorSiteID	Int		The ID of the site associated with the author.
AuthorURL	String		The personal website URL provided by the author, if available.
IsAuthorIpAddressAvailable	Boolean		Indicates whether the author's IP address is available.
IsAuthorSiteVisible	Boolean		Indicates whether the author's site is publicly visible.
Date	Datetime		The date and time when the post was created in the site's local timezone.
Modified	Datetime		The date and time when the post was last updated.
Title	String		The title of the post.
ItemURL	String		The full permalink URL for the post.
ShortURL	String		The WordPress shortlink (`wp.me`) version of the post URL.
Content	String		The full HTML content of the post.
Excerpt	String		A short excerpt or summary of the post content.
Slug	String		The URL-friendly slug used to identify the post.
Guid	String		The globally unique identifier (GUID) for the post, often representing its original permalink.
Status	String		A comma-separated list of post statuses to query, such as publish, private, draft, pending, future, or trash. Defaults to publish.
IsSticky	Boolean		Indicates whether the post is marked as sticky and displayed at the top of the blog.
Password	String		The plaintext password used to protect the post, or an empty string if the post is not password-protected.
HasParent	Boolean		Indicates whether the post has a parent post (for example, a child page).
Type	String		The post type, such as post, page, or another registered custom post type.
HasCommentsOpen	Boolean		Indicates whether comments are currently open for the post.
IsPingsOpen	Boolean		Indicates whether pingbacks and trackbacks are enabled for the post.
HasLikesEnabled	Boolean		Indicates whether the post allows likes.
HasSharingEnabled	Boolean		Indicates whether sharing buttons are enabled for the post.
CommentCount	Int		The total number of comments associated with the post.
FeaturedImage	String		The URL of the post's featured image, if one is set.
PostThumbnail	String		The attachment object representing the featured image, if available.
Format	String		The display format of the post, such as standard, aside, gallery, image, quote, status, video, or audio.
HasGeo	Boolean		Indicates whether the post includes geolocation data.
MenuOrder	Int		The order in which pages or hierarchical posts appear in navigation menus.
PublicizeURLsAggregates	String		A list of URLs where the post was automatically shared via Publicize connections (for example, Facebook or Twitter).
CategoriesAggregates	String		A collection of categories (keyed by category name) applied to the post.
TagsAggregates	String		A collection of tags (keyed by tag name) applied to the post.
Attachments	String		A collection of attachments associated with the post (keyed by attachment ID). Returns up to 20 of the most recent attachments.
MetadataAggregates	String		A list of metadata key-value pairs associated with the post.
MetaAggregates	String		Additional metadata key-value pairs describing the post's extended properties.
HasCapabilitiesDeletePost	Boolean		Indicates whether the authenticated user has permission to delete the post.
HasCapabilitiesEditPost	Boolean		Indicates whether the authenticated user has permission to edit the post.
HasCapabilitiesPublishPost	Boolean		Indicates whether the authenticated user has permission to publish the post.
HasCurrentUserCanDeletePost	Boolean		Indicates whether the current user can delete the post.
HasCurrentUserCanEditPost	Boolean		Indicates whether the current user can edit the post.
HasCurrentUserCanPublishPost	Boolean		Indicates whether the current user can publish the post.
PseudoID	String		A unique pseudo identifier for the feed item, used when the post originates from a feed or external source.
IsExternal	Boolean		Indicates whether the post originates from an external source.
SiteName	String		The name of the site where the post was published.
SiteURL	String		The URL of the site where the post was published.
IsSitePrivate	Boolean		Indicates whether the site is private or restricted from public access.
FeaturedMedia	String		The media file featured or attached to the post.
Tags	String		The list of tags applied to the post.