MatchingFeeds
Get the MatchingFeeds for a blog.
Table Specific Information
SELECT
The connector 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 connector processes other filters client-side within the connector.
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
疑似カラムフィールドはSELECT ステートメントのWHERE 句で使用され、操作によって返されるデータをより細かく制御することができます。
| Name | Type | Description | |
| QueryText | String | Specifies the search text or keywords used to query and match relevant feeds. |