Feed
Returns metadata and subscription information for a specific feed in the WordPress Reader.
Table Specific Information
SELECT
The add-in uses the WordPress API to process some of the filters.
- FeedId supports the '=' comparison.
- FeedURL supports the '=' comparison.
The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side.
SELECT * FROM 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. |