Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Amazon Marketplace Views
Name | Description |
CatalogItems | The Catalog Items table helps you retrieve item details for items in the catalog. |
CompetitivePricing | Returns competitive pricing information for a seller's offer listings based on seller SKU or ASIN. |
Feeds | The GetFeedSubmissionList operation returns a list of feed submissions. |
InboundShipmentItems | Returns a list of items in a specified inbound shipment. |
InboundShipments | Returns a list of inbound shipments based on criteria that you specify. |
InventorySupply | Returns information about the availability of inventory that a seller has in Amazon's fulfillment network and in current inbound shipments. You can check the current availability status for your Fulfillment by Amazon inventory as well as discover when availability status changes. |
ItemOffers | Returns the lowest priced offers for a single item based on ASIN. |
ListingOffers | Generated schema file. |
ListingsItemsIssues | The GetFeedSubmissionList operation returns a list of feed submissions. |
ListingsItemsOffers | The GetFeedSubmissionList operation returns a list of feed submissions. |
ListingsItemsSummaries | The GetFeedSubmissionList operation returns a list of feed submissions. |
OrderItems | Returns order items based on the Amazon Order Id that you specify. |
Orders | Returns orders created or updated during a time frame that you specify. |
ProductPricing | Generated schema file. |
ReportList | Returns report details for the reports that match the filters that you specify. |
ReportTypes | Returns report details for the reports that match the filters that you specify. |
VendorCustomerInvoices | This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of customer invoices created during a time frame that you specify. The date range to search must be no more than 7 days. |
VendorOrders | The Selling Partner API for Retail Procurement Orders provides programmatic access to vendor orders data. |
VendorPackingSlips | This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of packing slips for the purchase orders that match the criteria specified. Date range to search must not be more than 7 days. |