Feeds
The GetFeedSubmissionList operation returns a list of feed submissions.
Select
The connector will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
Note: 'FeedType' attribute is required to query the view. You can view available values for 'FeedType' here.
- FeedId supports the '=' comparison.
- FeedType supports the '=' and 'IN' comparisons.
- MarketplaceIds supports the '=' and 'IN' comparisons.
- ProcessingStatus supports the '=' and 'IN' comparisons.
- CreatedTime supports the '=', '<', '>', '<=' and '>=' comparisons.
Following are example queries that are processed server side:
SELECT * FROM Feeds WHERE FeedId = '50950018754'
SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA'
SELECT * FROM Feeds WHERE FeedType IN ( 'POST_PRODUCT_PRICING_DATA', 'POST_INVENTORY_AVAILABILITY_DATA' )
SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA' AND MarketplaceIds = 'A1VC38T7YXB528'
SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA' AND ProcessingStatus = 'DONE'
SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA' AND CreatedTime > '2021-06-20' AND CreatedTime < '2021-08-01 12:00:00'
Note: When filtering with CreatedTime, values older than 90 days will not be accepted.
Columns
| Name | Type | References | Description |
| FeedId [KEY] | String | The Id of the Feed. This identifier is unique only in combination with a seller ID. | |
| FeedType | String | The Type of the feed. FeedType is not required when UseSandbox=True. | |
| MarketplaceIds | String | A list of marketplace identifiers for the report. | |
| CreatedTime | Datetime | The date and time when the feed was created. While filtering, CreatedTime value is only accepted till 90 days old. | |
| ProcessingStatus | String | The processing status of the report. | |
| ProcessingStartTime | Datetime | The Date when the feed processing started. | |
| ProcessingEndTime | Datetime | The Date when the feed processing completed. | |
| ResultFeedDocumentId | String | The identifier for the feed document. This identifier is unique only in combination with a seller ID. |