API Connectors

users-love-us medal soc2
Send your WordPress data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

WordPress Connector Reference

6 metrics303 dimensions
Fields Actions

The WordPress connector exposes 309 fields (6 metrics, 303 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Available actions


Create Post Create a blog post on the connected WordPress site. Content is HTML or Gutenberg block markup and is stored as given. Defaults to a draft; pass status 'publish' to publish immediately, or status 'future' with a date to schedule. categories, tags, featured_media and author take numeric IDs, which the Categories, Tags, Media and Users tables provide. Editable afterwards via update_post.

Create a blog post on the connected WordPress site. Content is HTML or Gutenberg block markup and is stored as given. Defaults to a draft; pass status 'publish' to publish immediately, or status 'future' with a date to schedule. categories, tags, featured_media and author take numeric IDs, which the Categories, Tags, Media and Users tables provide. Editable afterwards via update_post.

Parameters
titlestringRequiredcontentstringexcerptstringslugstringstatusstringdatestringauthorstringfeatured_mediastringcomment_statusstringtemplatestringcategoriesstringtagsstringstickystring
Update Post Update an existing blog post on the connected WordPress site. post_id is the numeric ID from the Posts table. Only the fields provided are changed; everything else keeps its current value. Set status 'publish' to publish a draft, or 'draft' to unpublish. categories and tags replace the current terms rather than adding to them, and content, title and excerpt are replaced wholesale: send the complete new value, as text is never appended to what is already there. Changing the title, content or excerpt keeps the previous version as a revision in the Post Revisions table, which is the only way back from an accidental overwrite.

Update an existing blog post on the connected WordPress site. post_id is the numeric ID from the Posts table. Only the fields provided are changed; everything else keeps its current value. Set status 'publish' to publish a draft, or 'draft' to unpublish. categories and tags replace the current terms rather than adding to them, and content, title and excerpt are replaced wholesale: send the complete new value, as text is never appended to what is already there. Changing the title, content or excerpt keeps the previous version as a revision in the Post Revisions table, which is the only way back from an accidental overwrite.

Parameters
titlestringcontentstringexcerptstringslugstringstatusstringdatestringauthorstringfeatured_mediastringcomment_statusstringtemplatestringcategoriesstringtagsstringstickystringpost_idintegerRequired
Create Page Create a page on the connected WordPress site. Content is HTML or Gutenberg block markup and is stored as given. Defaults to a draft; pass status 'publish' to publish immediately, or status 'future' with a date to schedule. parent takes the ID of another page to nest this one under it, menu_order controls ordering among siblings, and template is a theme template file such as 'templates/full-width.php'. Editable afterwards via update_page.

Create a page on the connected WordPress site. Content is HTML or Gutenberg block markup and is stored as given. Defaults to a draft; pass status 'publish' to publish immediately, or status 'future' with a date to schedule. parent takes the ID of another page to nest this one under it, menu_order controls ordering among siblings, and template is a theme template file such as 'templates/full-width.php'. Editable afterwards via update_page.

Parameters
titlestringRequiredcontentstringexcerptstringslugstringstatusstringdatestringauthorstringfeatured_mediastringcomment_statusstringtemplatestringparentstringmenu_orderstring
Update Page Update an existing page on the connected WordPress site. page_id is the numeric ID from the Pages table. Only the fields provided are changed; everything else keeps its current value. Set status 'publish' to publish a draft, or 'draft' to unpublish. content, title and excerpt are replaced wholesale: send the complete new value, as text is never appended to what is already there. Changing the title, content or excerpt keeps the previous version as a revision in the Page Revisions table, which is the only way back from an accidental overwrite.

Update an existing page on the connected WordPress site. page_id is the numeric ID from the Pages table. Only the fields provided are changed; everything else keeps its current value. Set status 'publish' to publish a draft, or 'draft' to unpublish. content, title and excerpt are replaced wholesale: send the complete new value, as text is never appended to what is already there. Changing the title, content or excerpt keeps the previous version as a revision in the Page Revisions table, which is the only way back from an accidental overwrite.

Parameters
titlestringcontentstringexcerptstringslugstringstatusstringdatestringauthorstringfeatured_mediastringcomment_statusstringtemplatestringparentstringmenu_orderstringpage_idintegerRequired
Create Category Create a post category on the connected WordPress site. name is required; slug is derived from the name when omitted. parent takes another category's ID to nest this one under it. The new category's ID can then be passed to create_post or update_post.

Create a post category on the connected WordPress site. name is required; slug is derived from the name when omitted. parent takes another category's ID to nest this one under it. The new category's ID can then be passed to create_post or update_post.

Parameters
namestringRequiredslugstringdescriptionstringparentstring
Update Category Update an existing post category on the connected WordPress site. category_id is the numeric ID from the Categories table. Only the fields provided are changed. Renaming a category does not change its slug unless slug is passed too, so existing links keep working.

Update an existing post category on the connected WordPress site. category_id is the numeric ID from the Categories table. Only the fields provided are changed. Renaming a category does not change its slug unless slug is passed too, so existing links keep working.

Parameters
category_idintegerRequirednamestringslugstringdescriptionstringparentstring
Create Tag Create a post tag on the connected WordPress site. name is required; slug is derived from the name when omitted. Tags are flat, so unlike categories they cannot be nested. The new tag's ID can then be passed to create_post or update_post.

Create a post tag on the connected WordPress site. name is required; slug is derived from the name when omitted. Tags are flat, so unlike categories they cannot be nested. The new tag's ID can then be passed to create_post or update_post.

Parameters
namestringRequiredslugstringdescriptionstring
Update Tag Update an existing post tag on the connected WordPress site. tag_id is the numeric ID from the Tags table. Only the fields provided are changed. Renaming a tag does not change its slug unless slug is passed too, so existing links keep working.

Update an existing post tag on the connected WordPress site. tag_id is the numeric ID from the Tags table. Only the fields provided are changed. Renaming a tag does not change its slug unless slug is passed too, so existing links keep working.

Parameters
tag_idintegerRequirednamestringslugstringdescriptionstring

WordPress Fields

WordPress categories fields

The categories report of the WordPress connector includes 10 fields.

ID Type Name Description
categories___links OBJECT Category Links Links to REST API resources related to the category, such as its parent term and assigned posts.
categories__count NUMERIC Category Post Count The number of published posts assigned to the category.
categories__description TEXT Category Description The HTML description of the category.
categories__id TEXT Category ID The unique identifier of the category.
categories__link TEXT Category URL (WordPress) The URL of the category archive.
categories__meta OBJECT Category Meta The meta fields registered for the category.
categories__name TEXT Category Name The HTML title of the category.
categories__parent TEXT Category Parent ID (WordPress) The ID of the parent category, or `0` for a top-level category.
categories__slug TEXT Category Slug The alphanumeric identifier of the category, unique to its taxonomy.
categories__taxonomy TEXT Category Taxonomy The taxonomy the term belongs to, always `category`.

WordPress comments fields

The comments report of the WordPress connector includes 19 fields.

ID Type Name Description
comments___links OBJECT Comment Links Links to REST API resources related to the comment, such as its author and the commented post.
comments__author TEXT Comment Author ID The ID of the user who wrote the comment, or `0` when the author was not a registered user.
comments__author_avatar_urls OBJECT Comment Author Avatar URLs The avatar URLs of the comment author, keyed by image size.
comments__author_name TEXT Comment Author Name The display name of the comment author.
comments__author_url TEXT Comment Author URL The website URL of the comment author.
comments__content OBJECT Comment Content The content of the comment, as an object holding the rendered HTML.
comments__date TIMESTAMP Comment Date The date the comment was published, in the site's timezone.
comments__date_gmt TIMESTAMP Comment Date (GMT) The date the comment was published, as GMT.
comments__id TEXT Comment ID The unique identifier of the comment.
comments__link TEXT Comment URL The URL of the comment.
comments__meta OBJECT Comment Meta The meta fields registered for the comment.
comments__parent TEXT Comment Parent ID The ID of the comment this comment replies to, or `0` for a top-level comment.
comments__post TEXT Comment Post ID The ID of the post the comment was left on.
comments__status TEXT Comment Status The state of the comment, e.g. `approved`, `hold` or `spam`.
comments__type TEXT Comment Type The type of the comment, e.g. `comment` or `pingback`.
comments_author_avatar_urls_24 TEXT Comment Author Avatar URL (24px) The URL of the comment author avatar at 24 by 24 pixels.
comments_author_avatar_urls_48 TEXT Comment Author Avatar URL (48px) The URL of the comment author avatar at 48 by 48 pixels.
comments_author_avatar_urls_96 TEXT Comment Author Avatar URL (96px) The URL of the comment author avatar at 96 by 96 pixels.
comments_content_rendered TEXT Comment Content (Rendered) The rendered value of the comment content, as a flat field instead of the nested object.

WordPress editor_blocks fields

The editor_blocks report of the WordPress connector includes 24 fields.

ID Type Name Description
editor_blocks___links OBJECT Editor Block Links Links to REST API resources related to the editor block, such as its post type and terms.
editor_blocks__content OBJECT Editor Block Content The content of the editor block, as an object holding the rendered HTML.
editor_blocks__date TIMESTAMP Editor Block Publish Date The date the editor block was published, in the site's timezone.
editor_blocks__date_gmt TIMESTAMP Editor Block Publish Date (GMT) The date the editor block was published, as GMT.
editor_blocks__excerpt OBJECT Editor Block Excerpt The excerpt of the editor block, as an object holding the rendered HTML.
editor_blocks__guid OBJECT Editor Block GUID The globally unique identifier of the editor block, as an object holding the rendered value.
editor_blocks__id TEXT Editor Block ID The unique identifier of the editor block.
editor_blocks__link TEXT Editor Block URL The URL of the editor block.
editor_blocks__meta OBJECT Editor Block Meta The meta fields registered for the editor block.
editor_blocks__modified TIMESTAMP Editor Block Modified Date The date the editor block was last modified, in the site's timezone.
editor_blocks__modified_gmt TIMESTAMP Editor Block Modified Date (GMT) The date the editor block was last modified, as GMT.
editor_blocks__slug TEXT Editor Block Slug The alphanumeric identifier of the editor block, unique to its post type.
editor_blocks__status TEXT Editor Block Status The named status of the editor block, e.g. `publish` or `draft`.
editor_blocks__template TEXT Editor Block Template The theme file used to display the editor block.
editor_blocks__title OBJECT Editor Block Title The title of the editor block, as an object holding the rendered title.
editor_blocks__type TEXT Editor Block Type The post type of the editor block, always `wp_block`.
editor_blocks__wp_pattern_category OBJECT Editor Block Pattern Categories The IDs of the terms assigned to the editor block in the `wp_pattern_category` taxonomy.
editor_blocks__wp_pattern_sync_status TEXT Editor Block Pattern Sync Status Whether the editor block stays synced across the site: `unsynced` for a pattern inserted as a copy, empty when synced.
editor_blocks_content_protected BOOLEAN Editor Block Content Protected Whether the editor block content is protected by a password.
editor_blocks_content_rendered TEXT Editor Block Content (Rendered) The rendered value of the editor block content, as a flat field instead of the nested object.
editor_blocks_excerpt_protected BOOLEAN Editor Block Excerpt Protected Whether the editor block excerpt is protected by a password.
editor_blocks_excerpt_rendered TEXT Editor Block Excerpt (Rendered) The rendered value of the editor block excerpt, as a flat field instead of the nested object.
editor_blocks_guid_rendered TEXT Editor Block GUID (Rendered) The rendered value of the editor block guid, as a flat field instead of the nested object.
editor_blocks_title_rendered TEXT Editor Block Title (Rendered) The rendered value of the editor block title, as a flat field instead of the nested object.

WordPress media fields

The media report of the WordPress connector includes 34 fields.

ID Type Name Description
media___links OBJECT Media Links Links to REST API resources related to the media item, such as its author and replies.
media__alt_text TEXT Media Alt Text The alternative text displayed when the media item is not displayed.
media__author TEXT Media Author ID The ID of the user who uploaded the media item.
media__caption OBJECT Media Caption The caption of the media item, as an object holding the rendered HTML.
media__class_list OBJECT Media Class List The CSS class names for the media item container element.
media__comment_status TEXT Media Comment Status Whether comments are open on the media item, either `open` or `closed`.
media__date TIMESTAMP Media Upload Date The date the media item was uploaded, in the site's timezone.
media__date_gmt TIMESTAMP Media Upload Date (GMT) The date the media item was uploaded, as GMT.
media__description OBJECT Media Description The description of the media item, as an object holding the rendered HTML.
media__featured_media TEXT Media Featured Media ID The ID of the featured media of the media item.
media__guid OBJECT Media GUID The globally unique identifier of the media item, as an object holding the rendered value.
media__id TEXT Media ID (WordPress) The unique identifier of the media item.
media__link TEXT Media URL (WordPress) The URL of the media item attachment page.
media__media_details OBJECT Media Details Details about the media file specific to its type, such as dimensions, file size and generated image sizes.
media__media_type TEXT Media Type The type of the media item, e.g. `image` or `file`.
media__meta OBJECT Media Meta The meta fields registered for the media item.
media__mime_type TEXT Media MIME Type The MIME type of the media file, e.g. `image/jpeg`.
media__modified TIMESTAMP Media Modified Date The date the media item was last modified, in the site's timezone.
media__modified_gmt TIMESTAMP Media Modified Date (GMT) The date the media item was last modified, as GMT.
media__ping_status TEXT Media Ping Status Whether the media item can be pinged, either `open` or `closed`.
media__slug TEXT Media Slug The alphanumeric identifier of the media item, unique to its post type.
media__source_url TEXT Media Source URL The URL of the original media file.
media__status TEXT Media Status The named status of the media item, e.g. `inherit`.
media__template TEXT Media Template The theme file used to display the media item.
media__title OBJECT Media Title The title of the media item, as an object holding the rendered title.
media__type TEXT Media Post Type The post type of the media item, always `attachment`.
media_caption_rendered TEXT Media Caption (Rendered) The rendered value of the media caption, as a flat field instead of the nested object.
media_description_rendered TEXT Media Description (Rendered) The rendered value of the media description, as a flat field instead of the nested object.
media_guid_rendered TEXT Media GUID (Rendered) The rendered value of the media guid, as a flat field instead of the nested object.
media_media_details_file TEXT Media File Path The path of the media file relative to the uploads directory.
media_media_details_filesize NUMERIC Media File Size The size of the media file in bytes.
media_media_details_height NUMERIC Media Height The height of the media file in pixels.
media_media_details_width NUMERIC Media Width The width of the media file in pixels.
media_title_rendered TEXT Media Title (Rendered) The rendered value of the media title, as a flat field instead of the nested object.

WordPress page_revisions fields

The page_revisions report of the WordPress connector includes 18 fields.

ID Type Name Description
page_revisions___links OBJECT Page Revision Links Links to REST API resources related to the page revision, such as its author and the revised page.
page_revisions__author TEXT Page Revision Author ID The ID of the author of the page revision.
page_revisions__content OBJECT Page Revision Content The content of the page revision, as an object holding the rendered HTML.
page_revisions__date TIMESTAMP Page Revision Date The date the page revision was created, in the site's timezone.
page_revisions__date_gmt TIMESTAMP Page Revision Date (GMT) The date the page revision was created, as GMT.
page_revisions__excerpt OBJECT Page Revision Excerpt The excerpt of the page revision, as an object holding the rendered HTML.
page_revisions__guid OBJECT Page Revision GUID The globally unique identifier of the page revision, as an object holding the rendered value.
page_revisions__id TEXT Page Revision ID The unique identifier of the page revision.
page_revisions__meta OBJECT Page Revision Meta The meta fields registered for the page revision.
page_revisions__modified TIMESTAMP Page Revision Modified Date The date the page revision was last modified, in the site's timezone.
page_revisions__modified_gmt TIMESTAMP Page Revision Modified Date (GMT) The date the page revision was last modified, as GMT.
page_revisions__parent TEXT Page Revision Parent ID The ID of the page the revision belongs to.
page_revisions__slug TEXT Page Revision Slug The alphanumeric identifier of the page revision, unique to its post type.
page_revisions__title OBJECT Page Revision Title The title of the page revision, as an object holding the rendered title.
page_revisions_content_rendered TEXT Page Revision Content (Rendered) The rendered value of the page revision content, as a flat field instead of the nested object.
page_revisions_excerpt_rendered TEXT Page Revision Excerpt (Rendered) The rendered value of the page revision excerpt, as a flat field instead of the nested object.
page_revisions_guid_rendered TEXT Page Revision GUID (Rendered) The rendered value of the page revision guid, as a flat field instead of the nested object.
page_revisions_title_rendered TEXT Page Revision Title (Rendered) The rendered value of the page revision title, as a flat field instead of the nested object.

WordPress pages fields

The pages report of the WordPress connector includes 29 fields.

ID Type Name Description
pages___links OBJECT Page Links Links to REST API resources related to the page, such as its author, replies and revisions.
pages__author TEXT Page Author ID The ID of the author of the page.
pages__class_list OBJECT Page Class List The CSS class names for the page container element.
pages__comment_status TEXT Page Comment Status Whether comments are open on the page, either `open` or `closed`.
pages__content OBJECT Page Content The content of the page, as an object holding the rendered HTML and whether the content is password protected.
pages__date TIMESTAMP Page Publish Date The date the page was published, in the site's timezone.
pages__date_gmt TIMESTAMP Page Publish Date (GMT) The date the page was published, as GMT.
pages__excerpt OBJECT Page Excerpt The excerpt of the page, as an object holding the rendered HTML and whether the excerpt is password protected.
pages__featured_media TEXT Page Featured Media ID The ID of the featured media of the page.
pages__guid OBJECT Page GUID The globally unique identifier of the page, as an object holding the rendered value.
pages__id TEXT Page ID The unique identifier of the page.
pages__link TEXT Page URL The URL of the page.
pages__menu_order TEXT Page Menu Order The order of the page in relation to other pages.
pages__meta OBJECT Page Meta The meta fields registered for the page.
pages__modified TIMESTAMP Page Modified Date The date the page was last modified, in the site's timezone.
pages__modified_gmt TIMESTAMP Page Modified Date (GMT) The date the page was last modified, as GMT.
pages__parent TEXT Page Parent ID The ID of the parent of the page.
pages__ping_status TEXT Page Ping Status Whether the page can be pinged, either `open` or `closed`.
pages__slug TEXT Page Slug The alphanumeric identifier of the page, unique to its post type.
pages__status TEXT Page Status The named status of the page, e.g. `publish` or `draft`.
pages__template TEXT Page Template The theme file used to display the page.
pages__title OBJECT Page Title The title of the page, as an object holding the rendered title.
pages__type TEXT Page Type The post type of the page, always `page`.
pages_content_protected BOOLEAN Page Content Protected Whether the page content is protected by a password.
pages_content_rendered TEXT Page Content (Rendered) The rendered value of the page content, as a flat field instead of the nested object.
pages_excerpt_protected BOOLEAN Page Excerpt Protected Whether the page excerpt is protected by a password.
pages_excerpt_rendered TEXT Page Excerpt (Rendered) The rendered value of the page excerpt, as a flat field instead of the nested object.
pages_guid_rendered TEXT Page GUID (Rendered) The rendered value of the page guid, as a flat field instead of the nested object.
pages_title_rendered TEXT Page Title (Rendered) The rendered value of the page title, as a flat field instead of the nested object.

WordPress plugins fields

The plugins report of the WordPress connector includes 15 fields.

ID Type Name Description
plugins___links OBJECT Plugin Links Links to REST API resources related to the plugin.
plugins__author TEXT Plugin Author The author of the plugin.
plugins__author_uri TEXT Plugin Author URL The website address of the plugin author.
plugins__description OBJECT Plugin Description The description of the plugin, as an object holding the raw and rendered text.
plugins__name TEXT Plugin Name The name of the plugin.
plugins__network_only BOOLEAN Plugin Is Network Only Whether the plugin can only be activated network-wide.
plugins__plugin TEXT Plugin File The plugin file relative to the plugins directory, which uniquely identifies the plugin.
plugins__plugin_uri TEXT Plugin URL The website address of the plugin.
plugins__requires_php TEXT Plugin Required PHP Version The minimum PHP version required by the plugin.
plugins__requires_wp TEXT Plugin Required WordPress Version The minimum WordPress version required by the plugin.
plugins__status TEXT Plugin Status The activation status of the plugin, e.g. `active` or `inactive`.
plugins__textdomain TEXT Plugin Text Domain The text domain of the plugin, used to load its translations.
plugins__version TEXT Plugin Version The version number of the plugin.
plugins_description_raw TEXT Plugin Description (Raw) The raw, unrendered value of the plugin description, as a flat field instead of the nested object.
plugins_description_rendered TEXT Plugin Description (Rendered) The rendered value of the plugin description, as a flat field instead of the nested object.

WordPress post_revisions fields

The post_revisions report of the WordPress connector includes 18 fields.

ID Type Name Description
post_revisions___links OBJECT Post Revision Links Links to REST API resources related to the post revision, such as its author and the revised post.
post_revisions__author TEXT Post Revision Author ID The ID of the author of the post revision.
post_revisions__content OBJECT Post Revision Content The content of the post revision, as an object holding the rendered HTML.
post_revisions__date TIMESTAMP Post Revision Date The date the post revision was created, in the site's timezone.
post_revisions__date_gmt TIMESTAMP Post Revision Date (GMT) The date the post revision was created, as GMT.
post_revisions__excerpt OBJECT Post Revision Excerpt The excerpt of the post revision, as an object holding the rendered HTML.
post_revisions__guid OBJECT Post Revision GUID The globally unique identifier of the post revision, as an object holding the rendered value.
post_revisions__id TEXT Post Revision ID The unique identifier of the post revision.
post_revisions__meta OBJECT Post Revision Meta The meta fields registered for the post revision.
post_revisions__modified TIMESTAMP Post Revision Modified Date The date the post revision was last modified, in the site's timezone.
post_revisions__modified_gmt TIMESTAMP Post Revision Modified Date (GMT) The date the post revision was last modified, as GMT.
post_revisions__parent TEXT Post Revision Parent ID The ID of the post the revision belongs to.
post_revisions__slug TEXT Post Revision Slug The alphanumeric identifier of the post revision, unique to its post type.
post_revisions__title OBJECT Post Revision Title The title of the post revision, as an object holding the rendered title.
post_revisions_content_rendered TEXT Post Revision Content (Rendered) The rendered value of the post revision content, as a flat field instead of the nested object.
post_revisions_excerpt_rendered TEXT Post Revision Excerpt (Rendered) The rendered value of the post revision excerpt, as a flat field instead of the nested object.
post_revisions_guid_rendered TEXT Post Revision GUID (Rendered) The rendered value of the post revision guid, as a flat field instead of the nested object.
post_revisions_title_rendered TEXT Post Revision Title (Rendered) The rendered value of the post revision title, as a flat field instead of the nested object.

WordPress posts fields

The posts report of the WordPress connector includes 31 fields.

ID Type Name Description
posts___links OBJECT Post Links Links to REST API resources related to the post, such as its author, replies and terms.
posts__author TEXT Post Author ID The ID of the author of the post.
posts__categories OBJECT Post Categories The IDs of the terms assigned to the post in the `category` taxonomy.
posts__class_list OBJECT Post Class List The CSS class names for the post container element.
posts__comment_status TEXT Post Comment Status Whether comments are open on the post, either `open` or `closed`.
posts__content OBJECT Post Content The content of the post, as an object holding the rendered HTML and whether the content is password protected.
posts__date TIMESTAMP Post Publish Date The date the post was published, in the site's timezone.
posts__date_gmt TIMESTAMP Post Publish Date (GMT) The date the post was published, as GMT.
posts__excerpt OBJECT Post Excerpt The excerpt of the post, as an object holding the rendered HTML and whether the excerpt is password protected.
posts__featured_media TEXT Post Featured Media ID The ID of the featured media of the post.
posts__format TEXT Post Format The format of the post, e.g. `standard`, `aside` or `video`.
posts__guid OBJECT Post GUID (WordPress) The globally unique identifier of the post, as an object holding the rendered value.
posts__id TEXT Post ID The unique identifier of the post.
posts__link TEXT Post URL (WordPress) The URL of the post.
posts__meta OBJECT Post Meta The meta fields registered for the post.
posts__modified TIMESTAMP Post Modified Date The date the post was last modified, in the site's timezone.
posts__modified_gmt TIMESTAMP Post Modified Date (GMT) The date the post was last modified, as GMT.
posts__ping_status TEXT Post Ping Status Whether the post can be pinged, either `open` or `closed`.
posts__slug TEXT Post Slug The alphanumeric identifier of the post, unique to its post type.
posts__status TEXT Post Status The named status of the post, e.g. `publish` or `draft`.
posts__sticky BOOLEAN Post Is Sticky Whether the post is treated as sticky and pinned to the top of post listings.
posts__tags OBJECT Post Tags The IDs of the terms assigned to the post in the `post_tag` taxonomy.
posts__template TEXT Post Template The theme file used to display the post.
posts__title OBJECT Post Title The title of the post, as an object holding the rendered title.
posts__type TEXT Post Type (WordPress) The post type of the post, always `post`.
posts_content_protected BOOLEAN Post Content Protected Whether the post content is protected by a password.
posts_content_rendered TEXT Post Content (Rendered) The rendered value of the post content, as a flat field instead of the nested object.
posts_excerpt_protected BOOLEAN Post Excerpt Protected Whether the post excerpt is protected by a password.
posts_excerpt_rendered TEXT Post Excerpt (Rendered) The rendered value of the post excerpt, as a flat field instead of the nested object.
posts_guid_rendered TEXT Post GUID (Rendered) The rendered value of the post guid, as a flat field instead of the nested object.
posts_title_rendered TEXT Post Title (Rendered) The rendered value of the post title, as a flat field instead of the nested object.

WordPress settings fields

The settings report of the WordPress connector includes 19 fields.

ID Type Name Description
settings__date_format TEXT Site Date Format The format used for all date strings on the site.
settings__default_category TEXT Site Default Category ID The ID of the category assigned to new posts by default.
settings__default_comment_status TEXT Site Default Comment Status Whether people are allowed to submit comments on new posts.
settings__default_ping_status TEXT Site Default Ping Status Whether link notifications from other blogs (pingbacks and trackbacks) are allowed on new posts.
settings__default_post_format TEXT Site Default Post Format The format assigned to new posts by default.
settings__description TEXT Site Tagline The tagline of the site.
settings__email TEXT Site Admin Email The address used for admin purposes, like new user notifications.
settings__language TEXT Site Language The WordPress locale code of the site.
settings__page_for_posts TEXT Site Posts Page ID The ID of the page that displays the latest posts.
settings__page_on_front TEXT Site Front Page ID The ID of the page displayed on the front page.
settings__posts_per_page NUMERIC Site Posts Per Page The maximum number of posts shown on blog pages.
settings__show_on_front TEXT Site Show On Front What is shown on the front page, either `posts` or `page`.
settings__site_icon TEXT Site Icon ID The ID of the media item used as the site icon.
settings__start_of_week TEXT Site Start Of Week The number of the weekday the week starts on, where `0` is Sunday.
settings__time_format TEXT Site Time Format The format used for all time strings on the site.
settings__timezone TEXT Site Timezone A city in the same timezone as the site.
settings__title TEXT Site Title The title of the site.
settings__url TEXT Site URL The URL of the site.
settings__use_smilies BOOLEAN Site Use Smilies Whether emoticons like :-) and :-P are converted to graphics on display.

WordPress statuses fields

The statuses report of the WordPress connector includes 6 fields.

ID Type Name Description
statuses__draft OBJECT Post Status Definition (Draft) The definition of the `draft` post status used for unpublished content, including its label, visibility and query flags.
statuses__future OBJECT Post Status Definition (Future) The definition of the `future` post status used for scheduled content, including its label, visibility and query flags.
statuses__pending OBJECT Post Status Definition (Pending) The definition of the `pending` post status used for content awaiting review, including its label, visibility and query flags.
statuses__private OBJECT Post Status Definition (Private) The definition of the `private` post status used for content visible only to authorized users, including its label, visibility and query flags.
statuses__publish OBJECT Post Status Definition (Publish) The definition of the `publish` post status used for publicly visible content, including its label, visibility and query flags.
statuses__trash OBJECT Post Status Definition (Trash) The definition of the `trash` post status used for content moved to the trash, including its label, visibility and query flags.

WordPress tags fields

The tags report of the WordPress connector includes 9 fields.

ID Type Name Description
tags___links OBJECT Tag Links Links to REST API resources related to the tag, such as its assigned posts.
tags__count NUMERIC Tag Post Count The number of published posts assigned to the tag.
tags__description TEXT Tag Description The HTML description of the tag.
tags__id TEXT Tag ID The unique identifier of the tag.
tags__link TEXT Tag URL The URL of the tag archive.
tags__meta OBJECT Tag Meta The meta fields registered for the tag.
tags__name TEXT Tag Name The HTML title of the tag.
tags__slug TEXT Tag Slug The alphanumeric identifier of the tag, unique to its taxonomy.
tags__taxonomy TEXT Tag Taxonomy The taxonomy the term belongs to, always `post_tag`.

WordPress taxonomies fields

The taxonomies report of the WordPress connector includes 4 fields.

ID Type Name Description
taxonomies__category OBJECT Taxonomy Definition (Category) The definition of the `category` taxonomy, including its labels, capabilities, associated post types and REST route.
taxonomies__nav_menu OBJECT Taxonomy Definition (Navigation Menu) The definition of the `nav_menu` taxonomy, including its labels, capabilities, associated post types and REST route.
taxonomies__post_tag OBJECT Taxonomy Definition (Post Tag) The definition of the `post_tag` taxonomy, including its labels, capabilities, associated post types and REST route.
taxonomies__wp_pattern_category OBJECT Taxonomy Definition (Pattern Category) The definition of the `wp_pattern_category` taxonomy, including its labels, capabilities, associated post types and REST route.

WordPress themes fields

The themes report of the WordPress connector includes 29 fields.

ID Type Name Description
themes___links OBJECT Theme Links Links to REST API resources related to the theme.
themes__author OBJECT Theme Author The author of the theme, as an object holding the raw and rendered text.
themes__author_uri OBJECT Theme Author URL The website of the theme author, as an object holding the raw and rendered value.
themes__description OBJECT Theme Description The description of the theme, as an object holding the raw and rendered text.
themes__is_block_theme BOOLEAN Theme Is Block Theme Whether the theme is a block-based theme.
themes__name OBJECT Theme Name The name of the theme, as an object holding the raw and rendered text.
themes__requires_php TEXT Theme Required PHP Version The minimum PHP version required by the theme.
themes__requires_wp TEXT Theme Required WordPress Version The minimum WordPress version required by the theme.
themes__screenshot TEXT Theme Screenshot URL The URL of the screenshot of the theme.
themes__status TEXT Theme Status The named status of the theme, either `active` or `inactive`.
themes__stylesheet TEXT Theme Stylesheet The stylesheet directory of the theme, which uniquely identifies it.
themes__stylesheet_uri TEXT Theme Stylesheet URL The URL of the stylesheet directory of the theme.
themes__tags OBJECT Theme Tags The tags indicating the styles and features of the theme.
themes__template TEXT Theme Template The template of the theme, which points to the parent theme for a child theme and matches the stylesheet otherwise.
themes__template_uri TEXT Theme Template URL The URL of the template directory of the theme.
themes__textdomain TEXT Theme Text Domain The text domain of the theme, used to load its translations.
themes__theme_supports OBJECT Theme Supports The editor and WordPress features supported by the theme.
themes__theme_uri OBJECT Theme URL The URL of the webpage of the theme, as an object holding the raw and rendered value.
themes__version TEXT Theme Version The current version of the theme.
themes_author_raw TEXT Theme Author (Raw) The raw, unrendered value of the theme author, as a flat field instead of the nested object.
themes_author_rendered TEXT Theme Author (Rendered) The rendered value of the theme author, as a flat field instead of the nested object.
themes_author_uri_raw TEXT Theme Author URL (Raw) The raw, unrendered value of the theme author url, as a flat field instead of the nested object.
themes_author_uri_rendered TEXT Theme Author URL (Rendered) The rendered value of the theme author url, as a flat field instead of the nested object.
themes_description_raw TEXT Theme Description (Raw) The raw, unrendered value of the theme description, as a flat field instead of the nested object.
themes_description_rendered TEXT Theme Description (Rendered) The rendered value of the theme description, as a flat field instead of the nested object.
themes_name_raw TEXT Theme Name (Raw) The raw, unrendered value of the theme name, as a flat field instead of the nested object.
themes_name_rendered TEXT Theme Name (Rendered) The rendered value of the theme name, as a flat field instead of the nested object.
themes_theme_uri_raw TEXT Theme URL (Raw) The raw, unrendered value of the theme url, as a flat field instead of the nested object.
themes_theme_uri_rendered TEXT Theme URL (Rendered) The rendered value of the theme url, as a flat field instead of the nested object.

WordPress types fields

The types report of the WordPress connector includes 11 fields.

ID Type Name Description
types__attachment OBJECT Post Type Definition (Attachment) The definition of the `attachment` post type used for media items, including its labels, capabilities, supported features and REST route.
types__nav_menu_item OBJECT Post Type Definition (Navigation Menu Item) The definition of the `nav_menu_item` post type used for navigation menu entries, including its labels, capabilities, supported features and REST route.
types__page OBJECT Post Type Definition (Page) The definition of the `page` post type, including its labels, capabilities, supported features and REST route.
types__post OBJECT Post Type Definition (Post) The definition of the `post` post type, including its labels, capabilities, supported features and REST route.
types__wp_block OBJECT Post Type Definition (Editor Block) The definition of the `wp_block` post type used for reusable editor blocks and patterns, including its labels, capabilities, supported features and REST route.
types__wp_font_face OBJECT Post Type Definition (Font Face) The definition of the `wp_font_face` post type used for font faces, including its labels, capabilities, supported features and REST route.
types__wp_font_family OBJECT Post Type Definition (Font Family) The definition of the `wp_font_family` post type used for font families, including its labels, capabilities, supported features and REST route.
types__wp_global_styles OBJECT Post Type Definition (Global Styles) The definition of the `wp_global_styles` post type used for theme global style variations, including its labels, capabilities, supported features and REST route.
types__wp_navigation OBJECT Post Type Definition (Navigation Menu) The definition of the `wp_navigation` post type used for block theme navigation menus, including its labels, capabilities, supported features and REST route.
types__wp_template OBJECT Post Type Definition (Template) The definition of the `wp_template` post type used for block templates, including its labels, capabilities, supported features and REST route.
types__wp_template_part OBJECT Post Type Definition (Template Part) The definition of the `wp_template_part` post type used for reusable template parts, including its labels, capabilities, supported features and REST route.

WordPress users fields

The users report of the WordPress connector includes 12 fields.

ID Type Name Description
users___links OBJECT User Links Links to REST API resources related to the user.
users__avatar_urls OBJECT User Avatar URLs The avatar URLs of the user, keyed by image size.
users__description TEXT User Description (WordPress) The biographical description of the user.
users__id TEXT User ID The unique identifier of the user.
users__link TEXT User URL The URL of the author archive of the user.
users__meta OBJECT User Meta The meta fields registered for the user.
users__name TEXT User Name The display name of the user.
users__slug TEXT User Slug The alphanumeric identifier of the user, used in author archive URLs.
users__url TEXT User Website URL The website URL of the user.
users_avatar_urls_24 TEXT User Avatar URL (24px) The URL of the user avatar at 24 by 24 pixels.
users_avatar_urls_48 TEXT User Avatar URL (48px) The URL of the user avatar at 48 by 48 pixels.
users_avatar_urls_96 TEXT User Avatar URL (96px) The URL of the user avatar at 96 by 96 pixels.

WordPress other fields

The WordPress connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID The domain of the connected WordPress site.
account_name TEXT Account Name The domain of the connected WordPress site.
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date The date the record is attributed to, taken from the timestamp the resource is filtered on (its publish or modified date).
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20