Sync App アプリケーションの接続 ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Amazon Marketplace への接続を作成します。Amazon Marketplace アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからAmazon Marketplace コネクタをダウンロードおよびインストールします。

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

Amazon Marketplace への接続

Amazon MWS API とSelling Partner API の比較

Amazon MWS (Marketplace Web Services) API は以前からあるAmazon Marketplace のAPI であり、Selling Partner (SP) API は、JSON ベースのREST API 設計基準やOAuth 2.0 など、MWS API と比べて多くの改良点があります。SP-API は、Amazon MWS API で利用可能なすべての機能を含みます。

どちらのAPI を接続に使用するかは、Schema で指定できます。 それぞれのAPI で、次に説明する異なる接続オプションを利用可能です。

Selling Partner API への接続

Amazon Selling Partner API を使用してAmazon Marketplace に接続する場合、以下のプロパティが必要です。

• Schema：SellingPartner に設定。
• InitiateOAuth：GETANDREFRESH に設定。
• Marketplace：販売登録されているマーケットプレイスのリージョンに設定。

また、SellingPartner プロパティを使用してSeller またはVendor 認証を選択することができます。

MWS API への接続

Amazon MWS API を使用してAmazon Marketplace に接続する場合、接続プロパティとしてSellerId、Marketplace、Marketplace が必要です。Schema をMarketplace に設定します。

Amazon Marketplace へのアクセスの設定

Amazon Marketplace に接続するには、はじめにCData デベロッパーを認可します。認可するには、次の手順に従ってください。

• CData MWS の開発者ID：195280669143 を使用します。
• セラーセントラルのアプリを管理ページに移動し、プライマリアカウントホルダーとしてAmazon セラーアカウントにログインします。
• 新しい開発者を認証するボタンをクリックし、Sync App から提供された開発者ID を使用して認可ワークフローに従います。

または、 Amazon Marketplace CData Driver に移動して右パネルの今すぐ承認をクリックします。

MWS 認証トークンの取得

MWS 認証トークンを取得する方法は次のとおりです。

• セラーセントラルのアプリを管理ページに移動し、プライマリアカウントホルダーとしてAmazon セラーアカウントにログインします。
• CData アプリを見つけます。
• MWS 認証トークンカラムの下で表示をクリックします。

出品者ID の取得

下記の手順に従って、出品者ID を取得します。

• セラーアカウントにログインします。
• 設定を選択し、画面右上の出品用アカウント情報を選択します。
• 出品者情報の下で「あなたの出品者トークン」を選択します。

Amazon Marketplace への認証

Amazon マーケットプレイスアカウント

次の接続プロパティを設定して接続します。

• SellerId：Amazon マーケットプレイスWeb サービス設定の出品者ID を設定。
• Marketplace：Amazon マーケットプレイスのリージョン（米国、カナダ、日本など）に設定。
• Schema：Schema をMarketplace に設定。

OAuth

Amazon Marketplace はOAuth 認証標準を利用しています。

OAuth で認証するには、組み込みアプリケーションを使用するか、新しいカスタムOAuth アプリを作成する必要があります。カスタムOAuth アプリを使用して、サービスアカウントまたはユーザーアカウントで認証できます。 詳しくは、カスタムOAuth アプリの作成 を参照してください。

Web アプリ

Web アプリケーション経由で接続する場合は、Amazon Marketplace にカスタムOAuth アプリを登録する必要があります。それからSync App を使用してOAuth トークンの値を取得および管理します。

OAuth アクセストークンの取得

次の接続プロパティを設定し、OAuthAccessToken を取得します。

• OAuthClientId：アプリ設定のクライアントId に設定。
• OAuthClientSecret：アプリ設定のクライアントシークレットに設定。
• Marketplace：販売登録されているマーケットプレイスのリージョンに設定。
• Schema：SP-API に接続するにはSellingPartner に設定。

続いてストアドプロシージャを呼び出し、OAuth 交換を完了します。

1. GetOAuthAuthorizationURL ストアドプロシージャを呼び出します。AuthMode インプットをWEB に、CallbackURL インプットをアプリケーション設定で指定したリダイレクトURI に設定します。ストアドプロシージャがOAuth エンドポイントのURL を返します。
2. ログインして、アプリケーションを認可します。コールバックURL にリダイレクトされます。
3. GetOAuthAccessToken ストアドプロシージャを呼び出します。AuthMode インプットをWEB に設定します。Verifier インプットを、コールバックURL のクエリ文字列の"spapi_oauth_code" パラメータに設定します。

OAuth アクセストークンのリフレッシュ

InitiateOAuth をREFRESH に設定してOAuth アクセストークンの期限が切れたときに自動的にリフレッシュするか、RefreshOAuthAccessToken ストアドプロシージャを呼び出してトークンを手動でリフレッシュできます。

自動リフレッシュ

InitiateOAuth でトークンをリフレッシュするには、最初のデータ接続で次のように設定します。

• OAuthAccessToken：これをGetOAuthAccessToken によって返されたアクセストークンに設定します。
• InitiateOAuth：REFRESH に設定。InitiateOAuth を使うと、OAuth 交換の繰り返しや、手動でのOAuthAccessToken 設定を避けられます。
• OAuthSettingsLocation：Sync App がOAuth 値を保存する場所のパスを設定。これらの値は接続間で永続化されます。
• OAuthClientId：アプリ設定のクライアントId に設定。
• OAuthClientSecret：アプリ設定のクライアントシークレットに設定。
• OAuthRefreshToken：これをGetOAuthAccessToken によって返されたリフレッシュトークンに設定します。
• Marketplace：販売登録されているマーケットプレイスのリージョンに設定。
• AppId：作成したSelling Partner アプリのアプリケーションId。
• Schema：SP-API に接続するにはSellingPartner に設定。
• AWSAccessKey：OAuthClientId に関連するAWS ユーザーに紐づくアクセスキー。
• AWSSecretKey：OAuthClientId に関連するAWS ユーザーに紐づくシークレットキー。

その後のデータ接続では、以下を設定します。

• InitiateOAuth
• OAuthSettingsLocation
• Marketplace：販売登録されているマーケットプレイスのリージョンに設定。
• AppId：作成したSelling Partner アプリのアプリケーションId。
• Schema：SP-API に接続するにはSellingPartner に設定。
• AWSAccessKey：OAuthClientId に関連するAWS ユーザーに紐づくアクセスキー。
• AWSSecretKey：OAuthClientId に関連するAWS ユーザーに紐づくシークレットキー。

手動でリフレッシュ

GetOAuthAccessToken ストアドプロシージャを使用してOAuthAccessToken を手動でリフレッシュできます。GetOAuthAccessToken によって返されたExpiresIn パラメータ値が経過した後にストアドプロシージャを呼び出します。以下の接続プロパティが設定されている必要があります。

• OAuthClientId：アプリ設定のクライアントId に設定。
• OAuthClientSecret：アプリ設定のクライアントシークレットに設定。
• Marketplace：販売登録されているマーケットプレイスのリージョンに設定。
• Schema：SP-API に接続するにはSellingPartner に設定。

次のパラメータセットを使用してRefreshOAuthAccessToken を呼び出すことができます。

• OAuthRefreshToken：これをGetOAuthAccessToken によって返されたOAuthRefreshToken に設定します。

このセクションでは、Amazon Marketplace Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App を使用すると、事前設定されたクエリによって内容が決定されるユーザー定義ビューと呼ばれる仮想テーブルを定義できます。 このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。 カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。 詳しくは、接続文字列オプションにあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Amazon Marketplace にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくはクエリ処理 を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログ を参照してください。基本的なロギングでは、 次の2つの接続プロパティを設定するだけです。LogModules 接続プロパティを使用してログに記録する情報のサブセットを選択できる、 より洗練されたロギングをサポートする多数の機能があります。

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

CData Sync App は、Amazon Marketplace オブジェクトをリレーショナルテーブルおよびビューとしてモデル化します。 Amazon Marketplace オブジェクトは他のオブジェクトとリレーションを持ちます。テーブルでは、これらのリレーションは外部キーを使用して表されます。 次のセクションでは、利用可能なAPI オブジェクトを示し、Amazon Marketplace API へのSQL の実行について詳しく説明します。

ほとんどのデータベースオブジェクトのスキーマは、シンプルなテキストベースのコンフィギュレーションファイルで定義されます。

Sync App は、Amazon Marketplace API にできるだけ多くのSELECT 構文処理をオフロードし、残りのクエリをインメモリで処理します。 Sync App がクライアントサイドのインメモリ処理でAPI 制限を回避する方法の詳細については、SupportEnhancedSQL を参照してください。

Using Marketplace API

See Marketplace Data Model for the available entities in the Marketplace API.

Using SellingPartner API

See Selling Partner Data Model for the available entities in the Selling Partner API.

The CData Sync App models the Amazon Marketplace API as relational views, and stored procedures.

To use Marketplace Data Model, simply set Schema to Marketplace.

Views

ビュー are tables that cannot be modified, such as Orders, Products. Typically, model data that is read-only and cannot be updated are shown as views.

Stored Procedures

ストアドプロシージャ are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Reports

Created reports can be exposed as views by setting IncludeReports connection property to true. Reports can be created with the RequestReport stored procedure.

After a report has been created and finished processing with a status _DONE_ it will be exposed as a view with the name "Report{ReportType}{ReportID}".

Only Tab-Delimited reports can be used as views. You can find a full list of reports here: Report Types.

In order to avoid API throttling, it is suggested to use the CreateSchema stored procedure to create report table schemas.

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Amazon Marketplace Connector for CData Sync ビュー

Name	Description
FeedSubmissionList	The GetFeedSubmissionList operation returns a list of feed submissions.
FeedSubmissionResult	The GetFeedSubmissionResult operation returns the feed processing report for a specific feed.
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.
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.
Products	The Products Table helps you get information to match your products to existing product listings on Amazon Marketplace websites.
ReportList	Usage information for the operation ReportList.rsd.
ReportRequestList	Usage information for the operation ReportRequestList.rsd.

The GetFeedSubmissionList operation returns a list of feed submissions.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM FeedSubmissionList WHERE FeedSubmissionId = '50377017868'

SELECT * FROM FeedSubmissionList WHERE FeedType = '_POST_PRODUCT_DATA_

SELECT * FROM FeedSubmissionList WHERE SubmittedDate = '2018-12-03T09:42:06'

SELECT * FROM FeedSubmissionList WHERE FeedProcessingStatus = '_DONE_'

Columns

Name	Type	References	Description
FeedSubmissionId [KEY]	String		The Id of the FeedSubmission.
FeedType	String		The Type of the feed.
SubmittedDate	Datetime		The Date when the feed is submitted.
FeedProcessingStatus	String		The Status of the Feed. 使用できる値は次のとおりです。_AWAITING_ASYNCHRONOUS_REPLY_, _CANCELLED_, _DONE_, _IN_PROGRESS_, _IN_SAFETY_NET_, _SUBMITTED_, _UNCONFIRMED_
StartedProcessingDate	Datetime		The Date when the feed started processing.
CompletedProcessingDate	Datetime		The Date when the feed stopped processing.

The GetFeedSubmissionResult operation returns the feed processing report for a specific feed.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM FeedSubmissionResult WHERE FeedSubmissionId = '50377017868'

Columns

Name	Type	References	Description
DocumentTransactionID [KEY]	String		The Transaction ID of the Document.
FeedSubmissionId	String		The Feed Submission Id.
StatusCode	String		The status code of the feed.
MessagesProcessed	Integer		The number of messages processed.
MessagesSuccessful	Integer		The number of messages processed successfully.
MessagesWithError	Integer		The number of messages processed with errors.
MessagesWithWarning	Integer		The number of messages processed with warnings.
MessageID [KEY]	String		The Message ID.
ResultCode	String		The Result Code.
ResultMessageCode	String		The Result Message Code.
ResultDescription	String		The result description.
AdditionalInfo_SKU	String		The SKU.
AdditionalInfo_FulfillmentCenterID	String		The Fulfillment Center Id.
AdditionalInfo_AmazonOrderID	String		The Amazon Order Id.
AdditionalInfo_AmazonOrderItemCode	String		The Amazon Order Item Code.

Returns a list of items in a specified inbound shipment.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String	InboundShipments.ShipmentId	The ID of the shipment.
SellerSKU [KEY]	String		The Seller SKU of the item.
QuantityShipped	Int		The item quantity that you are shipping.
QuantityInCase	Int		The item quantity in each case, for case-packed items.
QuantityReceived	Int		The item quantity that has been received at an Amazon fulfillment center.
FulfillmentNetworkSKU	String		Amazon's fulfillment network SKU of the item.
PrepDetailsListPrepInstruction	String		Preparation instructions for shipping an item to Amazon's fulfillment network.
PrepDetailsListPrepOwner	String		Indicates who will prepare the item.
ReleaseDate	Date		The date that a pre-order item will be available for sale.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdatedDate	Datetime

Returns a list of inbound shipments based on criteria that you specify.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM InboundShipments WHERE ShipmentStatus = 'Working'

SELECT * FROM InboundShipments WHERE ShipmentStatus IN ('Working','SHIPPED','IN_TRANSIT')

SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'

SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
ShipmentStatus	String		The status of your inbound shipment. Possible values are WORKING, SHIPPED, IN_TRANSIT, DELIVERED, CHECKED_IN, RECEIVING, CLOSED, CANCELLED, DELETED, and ERROR.
ShipmentName	String		The unique name of the inbound shipment.
ShipFromPostalCode	String		The PostalCode of the return address.
ShipFromName	String		The Name of the return address.
ShipFromCountryCode	String		The CountryCode of the return address.
ShipFromStateOrProvinceCode	String		The State Or Province Code of the return address.
ShipFromAddressLine1	String		The AddressLine of the return address.
ShipFromCity	String		The City of the return address.
LabelPrepType	String		The type of label preparation.
AreCasesRequired	Boolean		Boolean that indicates whether or not an inbound shipment contains case-packed boxes.
DestinationFulfillmentCenterId	String		The Amazon fulfillment center identifier created by Amazon.
ConfirmedNeedByDate	Date		Date that the shipment must arrive at an Amazon fulfillment center for pre-ordered items.
EstimatedBoxContentsFeeTotalUnits	Int		The number of units to ship for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitCurrencyCode	String		The currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitValue	Decimal		The manual processing fee per unit for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeCurrencyCode	String		The Total fee currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeValue	Decimal		The Total fee value for an estimate of the manual processing fee charged by Amazon for boxes without box content information.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdatedDate	Datetime

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.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM InventorySupply WHERE SellerSKU = 'Stest'

SELECT * FROM InventorySupply WHERE  QueryStartDateTime = '2016-03-16'

Columns

Name	Type	References	Description
UID [KEY]	String		Auto Generated Primary Key field.
FNSKU	String		The Fulfillment Network SKU (FNSKU) of the item. The FNSKU is a unique identifier for each inventory item stored in an Amazon fulfillment center.
SellerSKU	String		The Seller SKU of the item. Required if the QueryStartDateTime is not specified.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
Condition	String		The condition of the item.
TotalSupplyQuantity	Integer		The total item quantity that a seller has in Amazon's fulfillment network supply chain. This includes inventory that is available for shipping, inventory in inbound shipments, and inventory being transferred between Amazon fulfillment centers.
InStockSupplyQuantity	Integer		The item quantity that a seller has in Amazon fulfillment centers that is available for shipping.
EarliestAvailability_TimepointType	String		Indicates whether inventory is immediately available for picking, whether inventory availability is unknown, or whether inventory is expected to be available for picking by a specific date.
EarliestAvailability_DateTime	Datetime		The date and time by which inventory is expected to be available for picking.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
QueryStartDateTime	Datetime		A date used for selecting items that have had changes in inventory availability after (or at) a specified time. Required if SellerSKU is not specified.

Returns order items based on the Amazon Order Id that you specify.

Select

The Sync App 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 Sync App. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field. For example, the following query is processed server side:

SELECT * FROM OrderItems WHERE AmazonOrderId = '503-9993250-1405404'

SELECT * FROM OrderItems WHERE AmazonOrderId IN ('503-9993250-1405404', '503-9993250-1405404')

Columns

Name	Type	References	Description
OrderItemId [KEY]	String		The item ID of the order.
AmazonOrderId	String	Orders.AmazonOrderId	The Amazon ID of the order.
ASIN	String		The ASIN Code.
SellerSKU	String		The SellerSKU.
BuyerCustomizedInfoCustomizedURL	String		The Buyer CustomizedURL.
Title	String		Title.
QuantityOrdered	Integer		The quantity of items ordered.
QuantityShipped	Integer		The quantity of items shipped.
GrantedPointsNumber	Integer		The Granted Points Number.
GrantedPointsMonetaryValueAmount	Decimal		The Granted Points Amount.
GrantedPointsMonetaryValueCurrencyCode	String		The Granted Points CurrencyCode.
NumberOfItems	Integer		The Number Of Items.
ItemPriceAmount	Decimal		The Item Price Amount.
ItemPriceCurrencyCode	String		The Item Price Currency Code.
ShippingPriceAmount	Decimal		The Shipping Price Amount.
ShippingPriceCurrencyCode	String		The Shipping Price Currency Code.
GiftWrapPriceAmount	String		The Gift Wrap Price Amount.
GiftWrapPriceCurrencyCode	String		The Gift Wrap Price Currency Code.
TaxCollectionName	String		The TaxCollection Name.
TaxCollectionValue	String		The TaxCollection Value.
ItemTaxAmount	Decimal		The Item Tax Amount.
ItemTaxCurrencyCode	String		The Item Tax Currency Code.
ShippingTaxAmount	String		The Shipping Tax Amount.
ShippingTaxCurrencyCode	String		The ShippingTax Currency Code.
GiftWrapTaxAmount	Decimal		The Gift Wrap Tax Amount.
GiftWrapTaxCurrencyCode	String		The Gift Wrap Tax Currency Code.
ShippingDiscountAmount	String		The Shipping Discount Amount.
ShippingDiscountCurrencyCode	String		The Shipping Discount Currency Code.
PromotionDiscountAmount	Decimal		The Promotion Discount Amount.
PromotionDiscountCurrencyCode	String		The Promotion Discount Currency Code.
PromotionIds	String		The IDs of Promotions.
CODFeeAmount	Decimal		The COD FeeAmount.
CODFeeCurrencyCode	String		The COD FeeCurrency Code.
CODFeeDiscountAmount	String		The COD FeeDiscount Amount.
CODFeeDiscountCurrencyCode	String		The COD FeeDiscount Currency Code.
IsGift	Boolean		Boolean specifying if the item is gift.
GiftMessageText	String		The Gift Message Text.
GiftWrapLevel	String		The Gift Wrap Level.
InvoiceDataInvoiceRequirement	String		The requirement of InvoiceData.
InvoiceDataBuyerSelectedInvoiceCategory	String		The selected categories of the InvoiceData.
InvoiceDataInvoiceTitle	String		The Title of the InvoiceData.
InvoiceDataInvoiceInformation	String		The Information of the InvoiceData.
ConditionNote	String		The Condition Note.
ConditionId	String		The Condition Id.
ConditionSubtypeId	String		The Condition Subtype Id.
ScheduledDeliveryStartDate	Datetime		The Scheduled Delivery StartDate.
ScheduledDeliveryEndDate	Datetime		The Scheduled Delivery EndDate.
PriceDesignation	String		The Price Designation.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdateDate	Datetime		The last time the order is updated.

Returns orders created or updated during a time frame that you specify.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM Orders WHERE AmazonOrderId = '249-7638334-8161403'

SELECT * FROM Orders WHERE LastUpdateDate >= '2016-12-12'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND OrderStatus = 'Canceled'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND FulfillmentChannel = 'MFN'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND BuyerEmail = '[email protected]'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND PaymentMethod = 'Other'

Columns

Name	Type	References	Description
AmazonOrderId [KEY]	String		The Amazon ID of the order.
SellerOrderId	String		The Seller ID of the order.
PurchaseDate	Datetime		The date of the purchase.
LastUpdateDate	Datetime		The last update date.
OrderStatus	String		Status of the order.
FulfillmentChannel	String		The Fulfillment Channel.
SalesChannel	String		The Sales Channel.
OrderChannel	String		The Order Channel.
ShipServiceLevel	String		The level of the Ship Service.
ShippingAddressName	String		The Shipping Address Name.
ShippingAddressAddressLine1	String		The Shipping Address AddressLine.
ShippingAddressAddressLine2	String		The Shipping Address AddressLine.
ShippingAddressAddressLine3	String		The Shipping Address AddressLine.
ShippingAddressCity	String		The Shipping Address City.
ShippingAddressCountry	String		The Shipping Address Country.
ShippingAddressDistrict	String		The Shipping Address District.
ShippingAddressStateOrRegion	String		The Shipping Address State Or Region.
ShippingAddressPostalCode	String		The Shipping Address Postal Code.
ShippingAddressCountryCode	String		The Shipping Address Country Code.
ShippingAddressPhone	String		The Shipping Address Phone.
ShippingAddress_AddressType	String		The Shipping Address Type.
OrderTotalCurrencyCode	String		The Order Currency Code.
OrderTotalAmount	Decimal		The Order Amount.
NumberOfItemsShipped	Integer		The Number Of Items Shipped.
NumberOfItemsUnshipped	Integer		The Number Of Items Unshipped.
PaymentExecutionDetail	String		The Payment Execution Detail.
PaymentMethod	String		The Payment Method.
PaymentMethodDetail	String		The Details of payment method.
IsReplacementOrder	Boolean		Boolean specifying if it is a replacement order.
ReplacedOrderId	String		The Replaced OrderId.
MarketplaceId	String		The MarketplaceId.
BuyerEmail	String		The Buyer Email.
BuyerName	String		The Buyer Name.
BuyerCounty	String		The Buyer Country.
BuyerTaxInfo	String		The Buyer Tax Info.
ShipmentServiceLevelCategory	String		The Shipment Service Level Category.
ShippedByAmazonTFM	Boolean		The Shipped By Amazon TFM.
TFMShipmentStatus	String		The TFM Shipment Status.
CbaDisplayableShippingLabel	String		The Cba Displayable Shipping Label.
OrderType	String		The Type of Order.
EarliestShipDate	Datetime		The Earliest Ship Date.
LatestShipDate	Datetime		The Latest Ship Date.
EarliestDeliveryDate	Datetime		The Earliest Delivery Date.
LatestDeliveryDate	Datetime		The Latest Delivery Date.
IsBusinessOrder	Boolean		Boolean specifying if it is a Business Order.
IsIBA	Boolean		When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU).
PurchaseOrderNumber	String		The Purchase Order Number.
IsPrime	Boolean		Boolean specifying if it is a Prime Order.
IsPremiumOrder	Boolean		Boolean specifying if it is a Premium Order.

The Products Table helps you get information to match your products to existing product listings on Amazon Marketplace websites.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM Products WHERE SearchTerms = '249-7638334-8161403'

SELECT * FROM Products WHERE idType = 'SellerSKU' AND idlist = '{SellerSku code}'

SELECT * FROM Products WHERE idType = 'ASIN' AND idlist = '{ASIN code}'

SELECT * FROM Products WHERE idType = 'GCID' AND idlist = '{GCID code}'

SELECT * FROM Products WHERE idType = 'UPC' AND idlist = '{UPC code}'

SELECT * FROM Products WHERE idType = 'EAN' AND idlist = '{EAN code}'

SELECT * FROM Products WHERE idType = 'ISBN' AND idlist = '{ISBN code}'

SELECT * FROM Products WHERE idType = 'JAN' AND idlist = '{JAN code}'

SELECT * FROM Products WHERE idType = 'JAN' AND idlist IN ('{JAN code}', '{ISBN code}', '{GCID code}')

Columns

Name	Type	References	Description
MarketplaceASIN [KEY]	String		The Marketplace ASIN.
MarketplaceASINMarketplaceId	String		The MarketplaceId of Marketplace ASIN.
SKUIdentifierMarketplaceId	String		The SKUIdentifier of MarketplaceId.
SKUIdentifierSelerId	String		The MarketplaceId of SellerId.
SKUIdentifierSellerSKU	String		The MarketplaceId of SellerSKU.
AttributeSets	String		The product attributes.
Relationships	String		The product relationships.
SalesRankings	String		The product sales rankings.
SearchTerms	String
IdType	String		The product ID type. 使用できる値は次のとおりです。ASIN, GCID, SellerSKU, UPC, EAN, ISBN, JAN
IdList	String		A list of product IDs.

Usage information for the operation ReportList.rsd.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM ReportList WHERE ReportType IN '_GET_MERCHANT_LISTINGS_INACTIVE_DATA_'

SELECT * FROM ReportList WHERE ReportRequestId = '50566018029'

SELECT * FROM ReportList WHERE ReportRequestId IN ('50566018029', '50564018026')

SELECT * FROM ReportList WHERE AvailableDate > '2016-12-12' AND AvailableDate< '2018-11-12 12:00:00'

SELECT * FROM ReportList WHERE AvailableDate >= '2016-12-12' AND Acknowledged = 'true'

Columns

Name	Type	References	Description
ReportId [KEY]	String		Report ID.
ReportType	String		The type of the Report.
ReportRequestId	String		The Report Request ID.
Acknowledged	Boolean		A boolean value that indicates whether the order report has been acknowledged.
AvailableDate	Datetime		Date on which the report was available. By default, reports available from the last 90 days will be returned.

Usage information for the operation ReportRequestList.rsd.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM ReportRequestList WHERE ReportType = '_GET_MERCHANT_LISTINGS_INACTIVE_DATA_'

SELECT * FROM ReportRequestList WHERE ReportType IN ('_GET_MERCHANT_LISTINGS_INACTIVE_DATA_', '_GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_')

SELECT * FROM ReportRequestList WHERE ReportRequestId = '50566018029'

SELECT * FROM ReportRequestList WHERE ReportRequestId IN ('50566018029', '50564018026')

SELECT * FROM ReportRequestList WHERE RequestedDate > '2016-12-12'

SELECT * FROM ReportRequestList WHERE RequestedDate > '2016-12-12' AND RequestedDate > '2018-12-12 13:00'

SELECT * FROM ReportRequestList WHERE RequestedDate <= '2016-12-12' AND ReportProcessingStatus = '_DONE_'

SELECT * FROM ReportRequestList WHERE ReportProcessingStatus IN ('_DONE_', '_SUBMITTED_', '_CANCELLED_')

Columns

Name	Type	References	Description
ReportRequestId [KEY]	String		The Report Request Id.
ReportType	String		The type of the Report.
StartDate	Datetime		The start date of the request.
EndDate	Datetime		The end date of the request.
Scheduled	Boolean		A boolean value that indicates whether the report request was scheduled.
SubmittedDate	Datetime		The date and time the report was submitted.
ReportProcessingStatus	String		Processing status of the report. Possible values are: _SUBMITTED_, _IN_PROGRESS_, _CANCELLED_, _DONE_, _DONE_NO_DATA_
GeneratedReportId	String		The report id generated from Amazon MWS.
StartedProcessingDate	Datetime		The date and time that the report stated to be processed.
CompletedDate	Datetime		The date and time that the report was completed.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
RequestedDate	Datetime		The date and time that the report was requested. By default, reports requested within the range of the last 90 days will be returned.

The CData Sync App models the Selling Partner API as relational views, and stored procedures.

To use Amazon Selling Partner Data Model, simply set Schema to SellingPartner.

Views

ビュー are tables that cannot be modified, such as Orders, Products. Typically, data that are read-only and cannot be updated are shown as views.

Stored Procedures

ストアドプロシージャ are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Reports

For each report type there is a view exposed. For example, report type FEE_DISCOUNTS_REPORT will be exposed as a view named REPORT_FEE_DISCOUNTS_REPORT. These views can then be queried by using 'DataStartTime' and 'DataEndTime' optional datetime parameters. When both datetime parameters are specified, the driver automatically searches for an existing report that matches the specified interval, and if not found a new report is created. Reports can be manually created with the RequestReport stored procedure. You can also use ReportOptions JSON-aggregate pseudo-column to specify additional fields that may be required depending on report type. For more details about report options please check Amazon Selling-Partner API Documentation

After a report has been created and pushed to the result set, the next time you query this report type with the 'DataStartTime' and 'DataEndTime' same filters, the previously created report is downloaded instead of creating a new report.

Sync App はAmazon Marketplace のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Amazon Marketplace テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

Amazon Marketplace Connector for CData Sync テーブル

Name	Description
Destinations	Returns information about all destinations.
ListingsItems	Returns details about a listings item for a selling partner.
ListingsItemsAttributes	The GetFeedSubmissionList operation returns a list of feed submissions.
Subscriptions	Returns information about subscriptions of the specified notification type.
VendorShippingLabels	This table is part of Vendor Direct Fulfillment Shipping API. Returns a list of shipping labels created during the time frame that you specify. You define that time frame using the CreatedDate column. The date range to search must not be more than 7 days.

Returns information about all destinations.

Columns

Name	Type	ReadOnly	References	Description
DestinationId [KEY]	String	False		The destination identifier generated when you created the destination.
Name	String	False		The developer-defined name for this destination.
ResourceSqsArn	String	False		The Amazon Resource Name (ARN) associated with the SQS queue (Amazon Simple Queue Service queue destination).
ResourceEventBridgeName	String	False		The name of the partner event source associated with the destination (Amazon EventBridge destination).
ResourceEventBridgeRegion	String	False		The AWS region in which you will be receiving the notifications (Amazon EventBridge destination).
ResourceEventBridgeAccountId	String	False		The identifier for the AWS account that is responsible for charges related to receiving notifications (Amazon EventBridge destination).

Returns details about a listings item for a selling partner.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItems WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

INSERT INTO ListingsItems(ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', '{\"AttributeName\": \"test_attribute\", \"AttributeValue\": \"value\"}', '12345', 'XXXXXXXXXXXXXX')

DELETE FROM ListingsItems WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

When inserting, you can also use temp tables in order to insert multiple attributes, as shown in the example below:

INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr1','val1')
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr2','val2')
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr3','val3')

INSERT INTO ListingsItems(ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', 'Attributes#temp', '12345', 'XXXXXXXXXXXXXX')

Columns

Name	Type	ReadOnly	References	Description
SKU [KEY]	String	True		A selling partner provided identifier for an Amazon listing.
FulfillmentAvailability	String	False		Fulfillment availability for the listings item.
ProcurementCostCurrency	String	True		The price (ISO4217 currency code) that you want Amazon to pay you for this product.
ProcurementCostAmount	String	True		The price (numeric value) that you want Amazon to pay you for this product.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
Attributes	String	This field is required for INSERT statements. Aggregate field containing structured 'AttributeName' and 'AttributeValue' fields.
SellerId	String	A selling partner identifier, such as a merchant account or vendor code.
Requirements	String	This field can be specified for INSERT statements. 使用できる値は次のとおりです。LISTING, LISTING_PRODUCT_ONLY, LISTING_OFFER_ONLY
ProductType	String	This field is required for INSERT statements.

The GetFeedSubmissionList operation returns a list of feed submissions.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItemsAttributes WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'
UPDATE ListingsItemsAttributes SET AttributeValue = 'test_value', ProductType = 'LUGGAGE'
       WHERE SKU = '12345' AND AttributeName = 'item_name_value'

You can also retrieve all SKU fields from another sub-query, for example:

SELECT * FROM ListingsItems WHERE SellerId='XXXXXXXXXXXXXX' AND SKU IN (
        SELECT DISTINCT(SKUIdentifierSellerSKU) FROM CatalogItems WHERE MarketplaceId = 'XXXXXXXXXXXXXX' AND Query = 'test' AND SkuIdentifierSellerSku IS NOT NULL
)

Columns

Name	Type	ReadOnly	References	Description
SKU [KEY]	String	True		A selling partner provided identifier for an Amazon listing.
AttributeName [KEY]	String	False		The attribute name for the listings item.
AttributeValue	String	False		The attribute value for the listings item.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
ProductType	String	The Amazon product type of the listings item. Required for Updating an attribute.
SellerId	String	A selling partner identifier, such as a merchant account or vendor code.

Returns information about subscriptions of the specified notification type.

Columns

Name	Type	ReadOnly	References	Description
SubscriptionId [KEY]	String	False		The subscription identifier generated when the subscription is created.
NotificationType [KEY]	String	False		The type of notification. 使用できる値は次のとおりです。ACCOUNT_STATUS_CHANGED, ANY_OFFER_CHANGED, B2B_ANY_OFFER_CHANGED, BRANDED_ITEM_CONTENT_CHANGE, FBA_INVENTORY_AVAILABILITY_CHANGES, FBA_OUTBOUND_SHIPMENT_STATUS, FEE_PROMOTION, FEED_PROCESSING_FINISHED, FULFILLMENT_ORDER_STATUS, ITEM_PRODUCT_TYPE_CHANGE, LISTINGS_ITEM_STATUS_CHANGE, LISTINGS_ITEM_ISSUES_CHANGE, ORDER_STATUS_CHANGE, PRICING_HEALTH, PRODUCT_TYPE_DEFINITIONS_CHANGE, REPORT_PROCESSING_FINISHED
PayloadVersion	String	False		The version of the payload object to be used in the notification.
DestinationId	String	False		The identifier for the destination where notifications will be delivered.
MarketplaceIds	String	False		A list of marketplace identifiers to subscribe to (e.g. ATVPDKIKX0DER). To receive notifications in every marketplace, do not provide this list.
AggregationTimePeriod	String	False		The supported time period to use to perform marketplace-ASIN level aggregation. 使用できる値は次のとおりです。FiveMinutes, TenMinutes
EventFilterType	String	False		An eventFilterType value that is supported by the specific notificationType. This is used by the subscription service to determine the type of event filter.

This table is part of Vendor Direct Fulfillment Shipping API. Returns a list of shipping labels created during the time frame that you specify. You define that time frame using the CreatedDate column. The date range to search must not be more than 7 days.

Select

The following fields are filtered server-side:

• PurchaseOrderNumber supports the '=' comparison
• CreatedDate supports all the >, >=, =, <=, < comparisons

Some example queries:

SELECT * FROM VendorShippingLabels

SELECT * FROM VendorShippingLabels WHERE PurchaseOrderNumber = '12345'

SELECT * FROM VendorShippingLabels WHERE CreatedDate > '2022-09-10T12:00:00' AND CreatedDate < '2022-09-15T12:00:00'

Insert

When inserting, you can also use temp tables in order to insert fields for aggregate objects, as shown in the example below:

INSERT INTO Items#temp (ItemSequenceNumber, BuyerProductIdentifier, VendorProductIdentifier, Amount, UnitOfMeasure) 
                VALUES (                 1,              'item_id',               'prod_id',     10,        'unit');

INSERT INTO Container#temp (ContainerType, ContainerIdentifier, TrackingNumber,  PackedItems) 
                    VALUES (     'carton',      'container_id',       'string', 'Items#temp');

INSERT INTO Address1#temp(  Name,     AddressLine1,          City,           County, CountryCode)
                  VALUES ('Name', 'Fayettville NC', 'Fayettville', 'North Carolina',        'NC');

INSERT INTO TaxTest#temp (RegistrationType, RegistrationNumber, RegistrationMessages, RegistrationAddress) 
                  VALUES (           'VAT',           'string',             'string',    'Address1#temp');

INSERT INTO VendorShippingLabels (PurchaseOrderNumber, SellingPartyPartyId,  SellingPartyTaxRegistrationDetails, ShipFromPartyPartyId,       Containers)
                          VALUES ('1234567890',                    '11111',                      'TaxTest#temp',              '22222', 'Container#temp');

In order to get the Transaction ID returned from the API for the insert statement, you can issue a select statement from the LastResultInfo temp table, as shown below:

SELECT * FROM LastResultInfo#temp 

Container temporary table schema info:

Column Name	Type	Required	Description
ContainerType	String	True	The type of container.
ContainerIdentifier	String	True	The container identifier.
TrackingNumber	String	False	The tracking number.
ContainerSequenceNumber	Integer	False	An integer that must be submitted for multi-box shipments only, where one item may come in separate packages.
ManifestId	String	False	The manifest identifier.
ManifestDate	String	False	The date of the manifest.
ShipMethod	String	False	The shipment method.
ScacCode	String	False	SCAC code required for NA VOC vendors only.
Carrier	String	False	Carrier required for EU VOC vendors only.
Length	String	False	Physical dimensional measurements of a container.
Width	String	False	Physical dimensional measurements of a container.
Height	String	False	Physical dimensional measurements of a container.
DimensionUnit	String	False	Physical dimensional measurements of a container.
Value	String	False	The weight.
WeightUnit	String	False	The weight.
PackedItems	Aggregate	True	A list of packed items. See: PackedItems table schema.

PackedItems temporary table schema info:

Column Name	Type	Required	Description
ItemSequenceNumber	Integer	True	Item Sequence Number for the item. This must be the same value as sent in the order for a given item.
BuyerProductIdentifier	String	False	Buyer's Standard Identification Number (ASIN) of an item. Either buyerProductIdentifier or vendorProductIdentifier is required.
VendorProductIdentifier	String	False	The vendor selected product identification of the item. Should be the same as was sent in the Purchase Order, like SKU Number.
Amount	Decimal	True	Quantity of units shipped for a specific item at a shipment level. If the item is present only in certain packages or pallets within the shipment, please provide this at the appropriate package or pallet level.
UnitOfMeasure	String	True	Unit of measure for the shipped quantity.

TaxRegistrationDetails temporary table schema info:

Column Name	Type	Required	Description
RegistrationType	String	True	Tax registration type for the entity. Allowed Values: VAT, GST.
RegistrationNumber	String	True	Tax registration number for the party. For example, VAT ID.
RegistrationMessages	String	False	Tax registration message that can be used for additional tax related details
RegistrationAddress	Aggregate	False	Address of the party. See: AddressDetails table schema.

Address temporary table schema info:

Column Name	Type	Required	Description
Name	String	True	The name of the person, business or institution at that address.
AddressLine1	String	True	First line of street address.
AddressLine2	String	False	Additional address information, if required.
AddressLine3	String	False	Additional address information, if required.
City	String	False	The city where the person, business or institution is located.
County	String	False	The county where person, business or institution is located.
District	String	False	The district where person, business or institution is located.
StateOrRegion	String	False	The state or region where person, business or institution is located.
PostalOrZipCode	String	False	The postal or zip code of that address. It contains a series of letters or digits or both, sometimes including spaces or punctuation.
CountryCode	String	True	The two digit country code. In ISO 3166-1 alpha-2 format.
Phone	String	False	The phone number of the person, business or institution located at that address.

Columns

Name	Type	ReadOnly	References	Description
PurchaseOrderNumber [KEY]	String	False		This field will contain the Purchase Order Number for this order.
LabelFormat	String	True		Format of the label. 使用できる値は次のとおりです。PNG, ZPL
LabelData	String	True		Provides the details of the packages in this shipment.
SellingPartyPartyId	String	False		Assigned Identification for the party.
SellingPartyAddressLine1	String	False		First line of the address.
SellingPartyAddressLine2	String	False		Additional street address information, if required.
SellingPartyAddressLine3	String	False		Additional street address information, if required.
SellingPartyAddressCity	String	False		The city where the person, business or institution is located.
SellingPartyAddressCountryCode	String	False		The two digit country code in ISO 3166-1 alpha-2 format.
SellingPartyAddressCounty	String	False		The county where person, business or institution is located.
SellingPartyAddressDistrict	String	False		The district where person, business or institution is located.
SellingPartyAddressName	String	False		The name of the person, business or institution at that address.
SellingPartyAddressPhone	String	False		The phone number of the person, business or institution located at that address.
SellingPartyAddressPostalCode	String	False		The postal code of that address. It contains a series of letters or digits or both, sometimes including spaces or punctuation.
SellingPartyAddressStateOrRegion	String	False		The state or region where person, business or institution is located.
SellingPartyTaxRegistrationDetails	String	False		Tax registration details of the entity. See: TaxRegistrationDetails temporary table schema.
ShipFromPartyPartyId	String	False		Assigned Identification for the party.
ShipFromPartyAddressLine1	String	False		First line of the address.
ShipFromPartyAddressLine2	String	False		Additional street address information, if required.
ShipFromPartyAddressLine3	String	False		Additional street address information, if required.
ShipFromPartyAddressCity	String	False		The city where the person, business or institution is located.
ShipFromPartyAddressCountryCode	String	False		The two digit country code in ISO 3166-1 alpha-2 format.
ShipFromPartyAddressCounty	String	False		The county where person, business or institution is located.
ShipFromPartyAddressDistrict	String	False		The district where person, business or institution is located.
ShipFromPartyAddressName	String	False		The name of the person, business or institution at that address.
ShipFromPartyAddressPhone	String	False		The phone number of the person, business or institution located at that address.
ShipFromPartyAddressPostalCode	String	False		The postal code of that address. It contains a series of letters or digits or both, sometimes including spaces or punctuation.
ShipFromPartyAddressStateOrRegion	String	False		The state or region where person, business or institution is located.
ShipFromPartyTaxRegistrationDetails	String	False		Tax registration details of the entity. See: TaxRegistrationDetails temporary table schema.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
CreatedDate	String	Filters for created date. If left empty the default specified range is from 6 days earlier to today.
Containers	String	A list of the packages in this shipment. Only used for Insert statements. See: Container temporary table schema.

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Amazon Marketplace Connector for CData Sync ビュー

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.

The Catalog Items table helps you retrieve item details for items in the catalog.

The following filters are required:

• MarketplaceId
• One of the following: Query, SellerSKU, UPC, EAN, ISBN, JAN

For example:

SELECT * FROM CatalogItems WHERE MarketplaceID = 'XXXXXXXXXXXXX' AND ISBN = 'XXXXXXXXXXXXX'

Columns

Name	Type	References	Description
MarketplaceASIN [KEY]	String		The Marketplace ASIN.
MarketplaceASINMarketplaceId	String		The MarketplaceId of Marketplace ASIN.
SKUIdentifierMarketplaceId	String		The SKUIdentifier of MarketplaceId.
SKUIdentifierSelerId	String		The MarketplaceId of SellerId.
SKUIdentifierSellerSKU	String		The MarketplaceId of SellerSKU.
AttributeSets	String		The product attributes.
Relationships	String		The product relationships.
SalesRankings	String		The product sales rankings.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
Query	String		Keyword(s) to use to search for items in the catalog. Example: 'harry potter books'.
SellerSKU	String		Used to identify an item in the given marketplace. SellerSKU is qualified by the seller's SellerId
UPC	String		A 12-digit bar code used for retail packaging.
EAN	String		A European article number that uniquely identifies the catalog item, manufacturer, and its attributes.
ISBN	String		The unique commercial book identifier used to identify books internationally.
JAN	String		A Japanese article number that uniquely identifies the product, manufacturer, and its attributes.
MarketplaceId	String		Specifies the marketplace for which items are returned.

Returns competitive pricing information for a seller's offer listings based on seller SKU or ASIN.

Columns

Name	Type	References	Description
ASIN [KEY]	String		The value of Amazon Standard Identification Number for the product.
SellerSKU	String		Stock Keeping Unit that identifies a product in the Amazon catalog.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
CompetitivePriceId	String		The competitive price Id of the product.
LandedPriceAmount	Decimal		The landed price amount of the price.
LandedPriceCurrencyCode	String		The landed price currency code of the price.
ListingPriceAmount	Decimal		The listing price amount of the price.
ListingPriceCurrencyCode	String		The listing price currency code of the price.
PointsNumber	Integer		The points number of the price.
PointsMonetaryValueAmount	Decimal		The points monetary value amount of the price.
PointsMonetaryValueCurrencyCode	String		The points monetary value currency code of the price.
ShippingAmount	Decimal		The shipping amount of the buyying price.
ShippingCurrencyCode	String		The shipping currency code of the buyying price.
TradeInValueAmount	Decimal		The trade-in value amount of the buyying price.
TradeInValueCurrencyCode	String		The trade-in value currency code of the buyying price.
ProductCategoryId	String		The product category Id.
Rank	Integer		The value of the sales rankings.
BelongsToRequester	Boolean		The boolean value if the product belongs to the requester.
Condition	String		The condition of the product.
Status	String		The status of the product.
ItemType	String		Required. Indicates whether ASIN values or seller SKU values are used to identify items. 使用できる値は次のとおりです。ASIN, SKU
CustomerType	String		Indicates whether to request pricing information from the point of view of consumer or business buyers. Default is Consumer. 使用できる値は次のとおりです。Consumer, Business

The GetFeedSubmissionList operation returns a list of feed submissions.

Select

The Sync App 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 Sync App.

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.

Returns a list of items in a specified inbound shipment.

Select

The Sync App 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 Sync App.

• MarketplaceId supports the '=' comparison.
• LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.

For example, the following query is processed server side:

SELECT * FROM InboundShipmentItems  WHERE MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM InboundShipmentItems  WHERE LastUpdatedDate > '2020-01-01'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
SellerSKU [KEY]	String		The Seller SKU of the item.
QuantityShipped	Int		The item quantity that you are shipping.
QuantityInCase	Int		The item quantity in each case, for case-packed items.
QuantityReceived	Int		The item quantity that has been received at an Amazon fulfillment center.
FulfillmentNetworkSKU	String		Amazon's fulfillment network SKU of the item.
PrepDetailsListPrepInstruction	String		Preparation instructions for shipping an item to Amazon's fulfillment network.
PrepDetailsListPrepOwner	String		Indicates who will prepare the item.
MarketplaceId	String		Marketplace identifier for the report.
ReleaseDate	Date		The date that a pre-order item will be available for sale.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdatedDate	Datetime

Returns a list of inbound shipments based on criteria that you specify.

Select

The Sync App 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 Sync App.

• ShipmentId supports the '=' and 'IN' comparisons.
• ShipmentStatus supports the '='and 'IN' comparisons.
• MarketplaceId supports the '=' comparison.
• LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.

For example, the following query is processed server side:

SELECT * FROM InboundShipments WHERE ShipmentStatus = 'Working'

SELECT * FROM InboundShipments WHERE ShipmentStatus IN ('Working','SHIPPED','IN_TRANSIT')

SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'

SELECT * FROM InboundShipments WHERE MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
ShipmentStatus	String		The status of your inbound shipment. Possible values are WORKING, SHIPPED, IN_TRANSIT, DELIVERED, CHECKED_IN, RECEIVING, CLOSED, CANCELLED, DELETED, and ERROR.
ShipmentName	String		The unique name of the inbound shipment.
ShipFromPostalCode	String		The PostalCode of the return address.
ShipFromName	String		The Name of the return address.
ShipFromCountryCode	String		The CountryCode of the return address.
ShipFromDistrictOrCounty	String		The State Or Province Code of the return address.
ShipFromStateOrProvinceCode	String		The State Or Province Code of the return address.
ShipFromAddressLine1	String		The street address information of the return address.
ShipFromAddressLine2	String		Additional street address information of the return address.
ShipFromCity	String		The City of the return address.
LabelPrepType	String		The type of label preparation.
AreCasesRequired	Boolean		Boolean that indicates whether or not an inbound shipment contains case-packed boxes.
DestinationFulfillmentCenterId	String		The Amazon fulfillment center identifier created by Amazon.
ConfirmedNeedByDate	Date		Date that the shipment must arrive at an Amazon fulfillment center for pre-ordered items.
MarketplaceId	String		Marketplace identifier for the report.
BoxContentsSource	String		Where the seller provided box contents information for a shipment.
EstimatedBoxContentsFeeTotalUnits	Int		The number of units to ship for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitCurrencyCode	String		The currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitValue	Decimal		The manual processing fee per unit for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeCurrencyCode	String		The Total fee currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeValue	Decimal		The Total fee value for an estimate of the manual processing fee charged by Amazon for boxes without box content information.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdatedDate	Datetime

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.

Select

The Sync App 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 Sync App.

Note: Attributes 'GranularityType' and 'GranularityId' are required to query the view. You must set GranularityId to the MarketplaceId from the API matching your region.

• SellerSKU supports the '=', 'IN' comparisons.
• GranularityType supports the '='comparison.
• GranularityId supports the '=' comparison.
• MarketplaceId supports the '=' comparison.
• StartDateTime supports the '=', '<', '>', '<=', '>=' comparisons.

Following are example queries which are processed server side:

SELECT * FROM InventorySupply WHERE GranularityType = 'Marketplace' AND GranularityId = 'ATVPDKIKX0DER' AND SellerSKU = '123'

SELECT * FROM InventorySupply WHERE GranularityType = 'Marketplace' AND GranularityId = 'ATVPDKIKX0DER' AND StartDateTime > '2020-01-01'

Columns

Name	Type	References	Description
UID [KEY]	String		Auto Generated Primary Key field.
FNSKU	String		The Fulfillment Network SKU (FNSKU) of the item. The FNSKU is a unique identifier for each inventory item stored in an Amazon fulfillment center.
SellerSKU	String		The Seller SKU of the item. Required if the QueryStartDateTime is not specified.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
Condition	String		The condition of the item.
GranularityType	String
GranularityId	String
TotalQuantity	Integer		The total number of units in an inbound shipment or in Amazon fulfillment centers.
ProductName	String		The localized language product title of the item within the specific marketplace.
LastUpdatedTime	String		The date and time that any quantity was last updated.
FulfillableQuantity	Integer		The item quantity that can be picked, packed, and shipped.
InboundWorkingQuantity	Integer		The item quantity that can be picked, packed, and shipped.
InboundShippedQuantity	Integer		The item quantity that can be picked, packed, and shipped.
InboundReceivingQuantity	Integer		The item quantity that can be picked, packed, and shipped.
TotalReservedQuantity	Integer		The total number of units in Amazon's fulfillment network that are currently being picked, packed, and shipped.
PendingCustomerOrderQuantity	Integer		The number of units reserved for customer orders.
PendingTransshipmentQuantity	Integer		The number of units being transferred from one fulfillment center to another.
FcProcessingQuantity	Integer		The number of units that have been sidelined at the fulfillment center for additional processing.
TotalUnfulfillableQuantity	Integer		The total number of units in Amazon's fulfillment network in unsellable condition.
CustomerDamagedQuantity	Integer		The number of units in customer damaged disposition.
WarehouseDamagedQuantity	Integer		The number of units in warehouse damaged disposition.
DistributorDamagedQuantity	Integer		The number of units in distributor damaged disposition.
CarrierDamagedQuantity	Integer		The number of units in carrier damaged disposition.
DefectiveQuantity	Integer		The number of units in defective disposition.
ExpiredQuantity	Integer		The number of units in expired disposition.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
StartDateTime	Datetime		A start date and time in ISO8601 format. If specified, all inventory summaries that have changed since then are returned. You must specify a date and time that is no earlier than 18 months prior to the current date and time.
MarketplaceId	String		The marketplace ID for the marketplace for which to return inventory summaries.

Returns the lowest priced offers for a single item based on ASIN.

Columns

Name	Type	References	Description
ASIN [KEY]	String		Required. The Amazon Standard Identification Number (ASIN) of the item.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
SummaryLandedPriceAmount	Decimal		The landed price amount of the lowest price.
SummaryLandedPriceCurrencyCode	String		The landed price currency code of the lowest price.
SummaryListingPriceAmount	Decimal		The listing price amount of the lowest price.
SummaryListingPriceCurrencyCode	String		The listing price currency code of the lowest price.
ItemCondition	String		The condition of the lowest priced product listed. 使用できる値は次のとおりです。New, Used, Collectible, Refurbished, Club
FulfillmentChannel	String		The fulfillment channel for the lowest priced product listed.
OffersListingPriceAmount	Decimal		The listing price amount of the offered price.
OffersListingPriceCurrencyCode	String		The listing price currency code of the offered price.
OffersShippingAmount	Decimal		The shipping amount of the offered price.
OffersShippingCurrencyCode	String		The shipping currency code of the offered price.
FeedbackCount	Integer		The feedback count.
SellerPositiveFeedbackRating	Double		The positive feedback rating of the seller.
SellerId	String		The seller Id.
ShippingTimeAvailabilityType	String		The shipping time availability type.
ShippingTimeMaximumHours	Integer		The maximum hours of shipping time.
ShippingTimeMinimumHours	Integer		The minimum hours of shipping time.
ShipsFromCountry	String		The country from where the product is shipped.
ShipsFromState	String		The state from where the product is shipped.
IsFeaturedMerchant	Boolean		The boolean value of the merchant being featured.
IsFulfilledByAmazon	Boolean		The boolean value of the merchant being fulfilled by Amazon.
CustomerType	String		Indicates whether to request pricing information from the point of view of consumer or business buyers. Default is Consumer. 使用できる値は次のとおりです。Consumer, Business

Generated schema file.

Columns

Name	Type	References	Description
SellerSKU [KEY]	String		Identifies an item in the given marketplace.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
SummaryLandedPriceAmount	Decimal		The landed price amount of the lowest price.
SummaryLandedPriceCurrencyCode	String		The landed price currency code of the lowest price.
SummaryListingPriceAmount	Decimal		The listing price amount of the lowest price.
SummaryListingPriceCurrencyCode	String		The listing price currency code of the lowest price.
ItemCondition	String		The condition of the lowest priced product listed. 使用できる値は次のとおりです。New, Used, Collectible, Refurbished, Club
FulfillmentChannel	String		The fulfillment channel for the lowest priced product listed.
OffersListingPriceAmount	Decimal		The listing price amount of the offered price.
OffersListingPriceCurrencyCode	String		The listing price currency code of the offered price.
OffersShippingAmount	Decimal		The shipping amount of the offered price.
OffersShippingCurrencyCode	String		The shipping currency code of the offered price.
FeedbackCount	Integer		The feedback count.
SellerPositiveFeedbackRating	Double		The positive feedback rating of the seller.
SellerId	String		The seller Id.
ShippingTimeAvailabilityType	String		The shipping time availability type.
ShippingTimeMaximumHours	Integer		The maximum hours of shipping time.
ShippingTimeMinimumHours	Integer		The minimum hours of shipping time.
ShipsFromCountry	String		The country from where the product is shipped.
ShipsFromState	String		The state from where the product is shipped.
IsFeaturedMerchant	Boolean		The boolean value of the merchant being featured.
IsFulfilledByAmazon	Boolean		The boolean value of the merchant being fulfilled by Amazon.
MyOffer	Boolean		The boolean value of the offer being the seller's.
CustomerType	String		Indicates whether to request pricing information from the point of view of consumer or business buyers. Default is Consumer. 使用できる値は次のとおりです。Consumer, Business

The GetFeedSubmissionList operation returns a list of feed submissions.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItemsIssues WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

Columns

Name	Type	References	Description
SKU	String		A selling partner provided identifier for an Amazon listing.
Code	String		An issue code that identifies the type of issue.
Message	String		A message that describes the issue.
Severity	String		The severity of the issue. 使用できる値は次のとおりです。INFO, WARNING, ERROR

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
SellerId	String		A selling partner identifier, such as a merchant account or vendor code.

The GetFeedSubmissionList operation returns a list of feed submissions.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItemsOffers WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

Columns

Name	Type	References	Description
SKU	String		A selling partner provided identifier for an Amazon listing
MarketplaceId	String		A marketplace identifier. Identifies the Amazon marketplace for the listings item.
OfferType	String		Type of offer for the listings item. 使用できる値は次のとおりです。B2B, B2C
PriceAmount	String		Purchase price amount of the listings item.
PriceCurrency	String		Purchase price currency of the listings item.
Points	String		The number of Amazon Points offered with the purchase of an item, and their monetary value. Note that the Points element is only returned in Japan (JP).

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
SellerId	String		A selling partner identifier, such as a merchant account or vendor code.

The GetFeedSubmissionList operation returns a list of feed submissions.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItemsSummaries WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

Columns

Name	Type	References	Description
SKU	String		A selling partner provided identifier for an Amazon listing.
Asin	String		Amazon Standard Identification Number (ASIN) of the listings item.
ConditionType	String		Identifies the condition of the listings item. 使用できる値は次のとおりです。new_new, new_open_box, new_oem, refurbished_refurbished, used_like_new, used_very_good, used_good, used_acceptable, collectible_like_new, collectible_very_good, collectible_good, collectible_acceptable, club_club
CreatedDate	Datetime		Date the listings item was created, in ISO 8601 format.
ItemName	String		Name, or title, associated with an Amazon catalog item.
LastUpdatedDate	Datetime		Date the listings item was last updated, in ISO 8601 format.
MainImageLink	String		Link, or URL, for the main image.
MainImageHeight	Integer		Height of the main image in pixels.
MainImageWidth	Integer		Width of the main image in pixels.
MarketplaceId	String		A marketplace identifier. Identifies the Amazon marketplace for the listings item.
ProductType	String		The Amazon product type of the listings item.
Status	String		Statuses that apply to the listings item.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
SellerId	String		A selling partner identifier, such as a merchant account or vendor code.

Returns order items based on the Amazon Order Id that you specify.

Select

The Sync App 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 Sync App. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field.

• AmazonOrderId supports the '=' comparison.

For example, the following query is processed server side:

SELECT * FROM OrderItems WHERE AmazonOrderId = '503-9993250-1405404'

Columns

Name	Type	References	Description
OrderItemId [KEY]	String		An Amazon-defined order item identifier.
AmazonOrderId	String	Orders.AmazonOrderId	The Amazon ID of the order.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
SellerSKU	String		The seller stock keeping unit (SKU) of the item.
BuyerCustomizedInfoCustomizedURL	String		The Buyer CustomizedURL.
Title	String		The name of the item.
QuantityOrdered	Integer		The quantity of items ordered.
QuantityShipped	Integer		The quantity of items shipped.
GrantedPointsNumber	Integer		The Granted Points Number.
GrantedPointsMonetaryValueAmount	Decimal		The Granted Points Amount.
GrantedPointsMonetaryValueCurrencyCode	String		The Granted Points CurrencyCode.
NumberOfItems	Integer		The total number of items that are included in the ASIN.
ItemPriceAmount	Decimal		The Item Price Amount.
ItemPriceCurrencyCode	String		The Item Price Currency Code.
ShippingPriceAmount	Decimal		The Shipping Price Amount.
ShippingPriceCurrencyCode	String		The Shipping Price Currency Code.
ItemTaxAmount	Decimal		The Item Tax Amount.
ItemTaxCurrencyCode	String		The Item Tax Currency Code.
ShippingTaxAmount	String		The Shipping Tax Amount.
ShippingTaxCurrencyCode	String		The ShippingTax Currency Code.
ShippingDiscountAmount	String		The Shipping Discount Amount.
ShippingDiscountCurrencyCode	String		The Shipping Discount Currency Code.
ShippingDiscountTaxAmount	String		The Shipping Discount Tax Amount.
ShippingDiscountTaxCurrencyCode	String		The Shipping Discount Tax Currency Code.
PromotionDiscountAmount	Decimal		The Promotion Discount Amount.
PromotionDiscountCurrencyCode	String		The Promotion Discount Currency Code.
PromotionDiscountTaxAmount	Decimal		The Promotion Discount Tax Amount.
PromotionDiscountTaxCurrencyCode	String		The Promotion Discount Tax Currency Code.
PromotionIds	String		The IDs of Promotions.
CODFeeAmount	Decimal		The COD FeeAmount.
CODFeeCurrencyCode	String		The COD FeeCurrency Code.
CODFeeDiscountAmount	String		The COD FeeDiscount Amount.
CODFeeDiscountCurrencyCode	String		The COD FeeDiscount Currency Code.
IsGift	Boolean		Boolean specifying if the item is gift.
ConditionNote	String		The Condition Note.
ConditionId	String		The Condition Id.
ConditionSubtypeId	String		The Condition Subtype Id.
ScheduledDeliveryStartDate	Datetime		The Scheduled Delivery StartDate.
ScheduledDeliveryEndDate	Datetime		The Scheduled Delivery EndDate.
PriceDesignation	String		The Price Designation.
TaxCollectionModel	String		The tax collection model applied to the item.
TaxCollectionResponsibleParty	String		The party responsible for withholding the taxes and remitting them to the taxing authority.
SerialNumberRequired	Boolean		When true, the product type for this item has a serial number. Returned only for Amazon Easy Ship orders.
IsTransparency	Boolean		When true, transparency codes are required.
IossNumber	String		The IOSS number for the marketplace.
StoreChainStoreId	String		The store chain store identifier. Linked to a specific store in a store chain.
DeemedResellerCategory	String		Applies to selling partners that are not based in the EU and is used to help them meet the VAT Deemed Reseller tax laws in the EU and UK.
IsBuyerRequestedCancel	Boolean		When true, the buyer has requested cancellation.
BuyerCancelReason	String		The reason that the buyer requested cancellation.
BuyerCustomizedInfoURL	String		The location of a zip file containing Amazon Custom data.
GiftWrapPriceAmount	String		The Gift Wrap Price Amount.
GiftWrapPriceCurrencyCode	String		The Gift Wrap Price Currency Code.
GiftWrapTaxAmount	String		The Gift Wrap Tax Amount.
GiftWrapTaxCurrencyCode	String		The Gift Wrap Tax Currency Code.
GiftMessageText	String		A gift message provided by the buyer.
GiftWrapLevel	String		The gift wrap level specified by the buyer.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
LastUpdateDate	Datetime		The last time the order is updated.

Returns orders created or updated during a time frame that you specify.

Select

The Sync App 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 Sync App.

• AmazonOrderId supports the '=' comparison.
• SellerOrderId supports the '=' comparison.
• PurchaseDate supports the '=', '<', '>', '<=', '>=' comparison.
• LastUpdateDate supports the '=', '<', '>', '<=', '>=' comparison.
• OrderStatus supports the '=', 'IN' comparison.
• FulfillmentChannel supports the '=', 'IN' comparison.
• PaymentMethod supports the '=', 'IN' comparison.
• MarketplaceId supports the '=' comparison.
• BuyerEmail supports the '=' comparison.
• IsISPU supports the '=' comparison.

For example, the following query is processed server side:

SELECT * FROM Orders WHERE AmazonOrderId = '249-7638334-8161403'

SELECT * FROM Orders WHERE SellerOrderId = '249-7638334' AND purchasedate > '2010-01-01'

SELECT * FROM Orders WHERE LastUpdateDate >= '2016-12-12'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12'

SELECT * FROM Orders WHERE MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM Orders WHERE BuyerEmail = '[email protected]'

SELECT * FROM Orders WHERE IsISPU = false

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND OrderStatus = 'Canceled'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND FulfillmentChannel = 'MFN'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND BuyerEmail = '[email protected]'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND PaymentMethod = 'Other'

Columns

Name	Type	References	Description
AmazonOrderId [KEY]	String		The Amazon ID of the order.
SellerOrderId	String		The Seller ID of the order.
PurchaseDate	Datetime		The date of the purchase.
LastUpdateDate	Datetime		The last update date.
OrderStatus	String		Status of the order.
FulfillmentChannel	String		The Fulfillment Channel.
SalesChannel	String		The Sales Channel.
OrderChannel	String		The Order Channel.
ShipServiceLevel	String		The level of the Ship Service.
ShippingAddressName	String		The Shipping Address Name.
ShippingAddressAddressLine1	String		The Shipping Address AddressLine.
ShippingAddressAddressLine2	String		The Shipping Address AddressLine.
ShippingAddressAddressLine3	String		The Shipping Address AddressLine.
ShippingAddressCity	String		The Shipping Address City.
ShippingAddressCounty	String		The Shipping Address County.
ShippingAddressDistrict	String		The Shipping Address District.
ShippingAddressStateOrRegion	String		The Shipping Address State Or Region.
ShippingAddressPostalCode	String		The Shipping Address Postal Code.
ShippingAddressCountryCode	String		The Shipping Address Country Code.
ShippingAddressPhone	String		The Shipping Address Phone.
ShippingAddressMunicipality	String		The Shipping Municipality.
ShippingAddress_AddressType	String		The Shipping Address Type.
DefaultShipAddressName	String		The Shipping Address Name.
DefaultShipAddressLine1	String		Default Ship From Location Address AddressLine.
DefaultShipAddressLine2	String		Default Ship From Location Address AddressLine.
DefaultShipAddressLine3	String		Default Ship From Location Address AddressLine.
DefaultShipCity	String		Default Ship From Location Address City.
DefaultShipCounty	String		Default Ship From Location Address County.
DefaultShipDistrict	String		Default Ship From Location Address District.
DefaultShipStateOrRegion	String		Default Ship From Location Address State Or Region.
DefaultShipPostalCode	String		Default Ship From Location Address Postal Code.
DefaultShipCountryCode	String		Default Ship From Location Address Country Code.
DefaultShipPhone	String		Default Ship From Location Address Phone.
DefaultShipMunicipality	String		The Default Ship Municipality.
DefaultShip_AddressType	String		Default Ship From Location Address Type.
OrderTotalCurrencyCode	String		The Order Currency Code.
OrderTotalAmount	Decimal		The Order Amount.
NumberOfItemsShipped	Integer		The Number Of Items Shipped.
NumberOfItemsUnshipped	Integer		The Number Of Items Unshipped.
PaymentExecutionDetail	String		The Payment Execution Detail.
PaymentMethod	String		The Payment Method.
PaymentMethodDetails	String		The Details of payment method.
IsReplacementOrder	Boolean		Boolean specifying if it is a replacement order.
ReplacedOrderId	String		The Replaced OrderId.
MarketplaceId	String		The MarketplaceId.
BuyerEmail	String		The Buyer Email.
BuyerName	String		The Buyer Name.
BuyerCounty	String		The Buyer Country.
BuyerTaxInfo	String		The Buyer Tax Info.
BuyerInvoicePreference	String		Can be individual or business.
ShipmentServiceLevelCategory	String		The Shipment Service Level Category.
ShippedByAmazonTFM	Boolean		The Shipped By Amazon TFM.
TFMShipmentStatus	String		The TFM Shipment Status.
CbaDisplayableShippingLabel	String		The Cba Displayable Shipping Label.
OrderType	String		The Type of Order.
HasAutomatedShippingSettings	Boolean		If true, this order has automated shipping settings generated by Amazon. This order could be identified as an SSA order.
AutomatedCarrier	String		Auto-generated carrier for SSA orders
AutomatedShipMethod	String		Auto-generated ship method for SSA orders.
EarliestShipDate	Datetime		The Earliest Ship Date.
EasyShipShipmentStatus	String		The status of the Amazon Easy Ship order. This property is included only for Amazon Easy Ship orders.
HasRegulatedItems	Boolean		Whether the order contains regulated items which may require additional approval steps before being fulfilled.
PromiseResponseDueDate	Datetime		Indicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders.
LatestShipDate	Datetime		The Latest Ship Date.
EarliestDeliveryDate	Datetime		The Earliest Delivery Date .
LatestDeliveryDate	Datetime		The Latest Delivery Date.
IsBusinessOrder	Boolean		Boolean specifying if it is a Business Order.
IsEstimatedShipDateSet	Boolean		When true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders.
IsSoldByAB	Boolean		When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU).
IsIBA	Boolean		When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU).
IsISPU	Boolean		When true, this order is marked to be picked up from a store rather than delivered.
IsGlobalExpressEnabled	Boolean		When true, the order is a GlobalExpress order.
PurchaseOrderNumber	String		The Purchase Order Number.
IsPrime	Boolean		Boolean specifying if it is a Prime Order.
IsPremiumOrder	Boolean		Boolean specifying if it is a Premium Order.

Generated schema file.

Columns

Name	Type	References	Description
ASIN [KEY]	String		The value of Amazon Standard Identification Number for the product.
SellerSKU	String		Stock Keeping Unit that identifies a product in the Amazon catalog.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
LandedPriceAmount	Decimal		The landed price amount of the buying price.
LandedPriceCurrencyCode	String		The landed price currency code of the buying price.
ListingPriceAmount	Decimal		The listing price amount of the buying price.
ListingPriceCurrencyCode	String		The listing price currency code of the buying price.
ShippingAmount	Decimal		The shipping amount of the buying price.
ShippingCurrencyCode	String		The shipping currency code of the buying price.
FulfillmentChannel	String		The fulfillment channel for the product listed.
ItemCondition	String		The condition of the product listed.
ItemSubCondition	String		The sub-condition of the product listed.
RegularPriceAmount	Decimal		The regular price amount of the product.
RegularPriceCurrencyCode	String		The regular price currecny code for the product.
Status	String		The status of the product.
ItemType	String		Required. Indicates whether ASIN values or seller SKU values are used to identify items. 使用できる値は次のとおりです。ASIN, SKU
CustomerType	String		Indicates whether to request pricing information from the point of view of consumer or business buyers. Default is Consumer. 使用できる値は次のとおりです。Consumer, Business
OfferType	String		Indicates whether to request pricing information for the seller's B2C (business-to-consumer) or B2B (business-to-business) offers. Default is B2C. 使用できる値は次のとおりです。B2C, B2B

Returns report details for the reports that match the filters that you specify.

Select

The Sync App 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 Sync App.

Note: 'ReportType' attribute is required to query the view. You can view available values for 'ReportType' in Amazon Selling-Partner API Documentation, or you can query the 'ReportTypes' view.

• ReportId supports the '=' comparison.
• ReportType supports the '=', 'IN' comparisons.
• MarketplaceIds supports the '=', 'IN' comparisons.
• ProcessingStatus supports the '=', 'IN' comparisons.
• CreatedTime supports the '=', '<', '>', '<=', '>=' comparisons.

Following are example queries that are processed server side:

SELECT * FROM ReportList WHERE ReportId = '51013018828'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND CreatedTime > '2021-06-12' AND CreatedTime< '2021-08-01 12:00:00'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND MarketplaceIds = 'A1VC38T7YXB528'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND ProcessingStatus = 'DONE'

Note: When filtering with CreatedTime, values older than 90 days will not be accepted.

Columns

Name	Type	References	Description
ReportId [KEY]	String		Report Id.
ReportType	String		The type of the Report. ReportType is not required when UseSandbox=True.
ReportDocumentId	String		The identifier for the report document.
CreatedTime	Datetime		The date and time when the report was created. While filtering, CreatedTime value is only accepted till 90 days old.
DataStartTime	Datetime		The start of a date and time range used for selecting the data to report.
DataEndTime	Datetime		The end of a date and time range used for selecting the data to report.
MarketplaceIds	String		A list of marketplace identifiers for the report.
ProcessingStartTime	Datetime		The date and time when the report processing started.
ProcessingEndTime	Datetime		The date and time when the report processing completed.
ProcessingStatus	String		The processing status of the report.

Returns report details for the reports that match the filters that you specify.

Select

This view lists all the available Report Types of Selling Partner API and their respective format (JSON, XML, CSV, TSV, PDF, XLSX).

SELECT * FROM ReportTypes

Columns

Name	Type	References	Description
ReportTypeId [KEY]	String		Sequential id of the report type.
ReportTypeValue	String		Enumeration value of the report type.
ReportFormat	String		The download format of the report type 使用できる値は次のとおりです。JSON, XML, CSV, TSV, PDF, XLSX
Category	String		Report format category.
Description	String		Report format description.
URL	String		Amazon Selling-Partner API Documentation link of the report type.

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.

Select

The following fields are filtered server-side:

• PurchaseOrderNumber supports the '=' comparison
• CreatedDate supports all the >, >=, =, <=, < comparisons

Some example queries:

SELECT * FROM VendorCustomerInvoices

SELECT * FROM VendorCustomerInvoices WHERE PurchaseOrderNumber = '12345'

SELECT * FROM VendorCustomerInvoices WHERE CreatedDate > '2022-09-10T12:00:00' AND CreatedDate < '2022-09-15T12:00:00'

Columns

Name	Type	References	Description
PurchaseOrderNumber [KEY]	String		This field will contain the Purchase Order Number for this order.
Content	String		The Base64encoded customer invoice.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
CreatedDate	String		Filters for created date. If left empty the default specified range is from 6 days earlier to today.

The Selling Partner API for Retail Procurement Orders provides programmatic access to vendor orders data.

Select

The Sync App 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 Sync App.

• PurchaseOrderNumber supports the '=' comparison.
• PurchaseOrderState supports the '='comparison.
• PurchaseOrderDate supports the '<', '>' comparisons and ORDER BY clause.
• PurchaseOrderChangedDate supports the '<', '>' comparisons.
• SellerPartyId supports the '=' comparison.

Following are example queries which are processed server side:

SELECT * FROM VendorOrders

SELECT * FROM VendorOrders WHERE PurchaseOrderNumber = '123456789'

SELECT * FROM VendorOrders WHERE PurchaseOrderState = 'New'

SELECT * FROM VendorOrders ORDER BY PurchaseOrderDate DESC

SELECT * FROM VendorOrders WHERE PurchaseOrderDate > '2022-06-01T12:00:00' AND PurchaseOrderDate < '2022-06-10T12:00:00'

SELECT * FROM VendorOrders WHERE PurchaseOrderChangedDate > '2022-06-01T12:00:00' AND PurchaseOrderChangedDate < '2022-06-10T12:00:00'

SELECT * FROM VendorOrders WHERE SellerPartyId = '123456789'

Columns

Name	Type	References	Description
PurchaseOrderNumber	String		The purchase order number for this order.
PurchaseOrderState	String		The current state of the purchase order. 使用できる値は次のとおりです。New, Acknowledged, Closed
DealCode	String		If requested by the recipient, this field will contain a promotional/deal number.
DeliveryWindow	String		This indicates the delivery window. Format is start and end date separated by double hyphen (--)
ShipWindow	String		This indicates the ship window. Format is start and end date separated by double hyphen (--).
Items	String		A list of items in this purchase order.
PaymentMethod	String		Payment method used. 使用できる値は次のとおりです。Prepaid, CreditCard, Consignment, Invoice
PurchaseOrderDate	Datetime		The date the purchase order was placed.
PurchaseOrderChangedDate	Datetime		The date when purchase order was last changed by Amazon after the order was placed.
PurchaseOrderStateChangedDate	Datetime		The date when current purchase order state was changed.
PurchaseOrderType	String		Type of purchase order. 使用できる値は次のとおりです。RushOrder, NewProductIntroduction, ConsignedOrder, RegularOrder
BillPartyId	String		Assigned identification for the party. For example, warehouse code or vendor code.
BillAddressAddressLine1	String		First line of the address.
BillAddressAddressLine2	String		Additional address information, if required.
BillAddressAddressLine3	String		Additional address information, if required.
BillAddressCity	String		The city where the person, business or institution is located.
BillAddressCountryCode	String		The two digit country code in ISO 3166-1 alpha-2 format.
BillAddressCounty	String		The county where person, business or institution is located.
BillAddressDistrict	String		The district where person, business or institution is located.
BillAddressName	String		The name of the address of the person, business or institution.
BillAddressPhone	String		The phone number of the person, business or institution located at that address.
BillAddressPostalCode	String		The postal code of that address. It contains a series of letters or digits or both.
BillAddressStateOrRegion	String		The state or region where person, business or institution is located.
BillTaxRegistrationNumber	String		Tax registration number for the entity. For example, VAT ID.
BillTaxRegistrationType	String		Tax registration type for the entity. 使用できる値は次のとおりです。VAT, GST
ShipPartyId	String		Assigned identification for the party. For example, warehouse code or vendor code.
ShipAddressAddressLine1	String		First line of the address.
ShipAddressAddressLine2	String		Additional address information, if required.
ShipAddressAddressLine3	String		Additional address information, if required.
ShipAddressCity	String		The city where the person, business or institution is located.
ShipAddressCountryCode	String		The two digit country code in ISO 3166-1 alpha-2 format.
ShipAddressCounty	String		The county where person, business or institution is located.
ShipAddressDistrict	String		The district where person, business or institution is located.
ShipAddressName	String		The name of the address of the person, business or institution.
ShipAddressPhone	String		The phone number of the person, business or institution located at that address.
ShipAddressPostalCode	String		The postal code of that address. It contains a series of letters or digits or both.
ShipAddressStateOrRegion	String		The state or region where person, business or institution is located.
ShipTaxRegistrationNumber	String		Tax registration number for the entity. For example, VAT ID.
ShipTaxRegistrationType	String		Tax registration type for the entity.
BuyerPartyId	String		Assigned identification for the party. For example, warehouse code or vendor code.
BuyerAddressAddressLine1	String		First line of the address.
BuyerAddressAddressLine2	String		Additional address information, if required.
BuyerAddressAddressLine3	String		Additional address information, if required.
BuyerAddressCity	String		The city where the person, business or institution is located.
BuyerAddressCountryCode	String		The two digit country code in ISO 3166-1 alpha-2 format.
BuyerAddressCounty	String		The county where person, business or institution is located.
BuyerAddressDistrict	String		The district where person, business or institution is located.
BuyerAddressName	String		The name of the address of the person, business or institution.
BuyerAddressPhone	String		The phone number of the person, business or institution located at that address.
BuyerAddressPostalCode	String		The postal code of that address. It contains a series of letters or digits or both.
BuyerAddressStateOrRegion	String		The state or region where person, business or institution is located.
BuyerTaxRegistrationNumber	String		Tax registration number for the entity. For example, VAT ID.
BuyerTaxRegistrationType	String		Tax registration type for the entity.
SellerPartyId	String		Assigned identification for the party. For example, warehouse code or vendor code.
SellerAddressAddressLine1	String		First line of the address.
SellerAddressAddressLine2	String		Additional address information, if required.
SellerAddressAddressLine3	String		Additional address information, if required.
SellerAddressCity	String		The city where the person, business or institution is located.
SellerAddressCountryCode	String		The two digit country code in ISO 3166-1 alpha-2 format.
SellerAddressCounty	String		The county where person, business or institution is located.
SellerAddressDistrict	String		The district where person, business or institution is located.
SellerAddressName	String		The name of the address of the person, business or institution.
SellerAddressPhone	String		The phone number of the person, business or institution located at that address.
SellerAddressPostalCode	String		The postal code of that address. It contains a series of letters or digits or both.
SellerAddressStateOrRegion	String		The state or region where person, business or institution is located.
SellerTaxRegistrationNumber	String		Tax registration number for the entity. For example, VAT ID.
SellerTaxRegistrationType	String		Tax registration type for the entity.
ImportContainers	String		Types and numbers of container(s) for import purchase orders. Can be a comma-separated list if the shipment has multiple containers.
InternationalCommercialTerms	String		Incoterms (International Commercial Terms) are used to divide transaction costs and responsibilities between buyer and seller and reflect state-of-the-art transportation practices.
MethodOfPayment	String		If the recipient requests, contains the shipment method of payment. This is for import PO's only. 使用できる値は次のとおりです。PaidBySeller, PrepaidBySeller, FOBPortOfCall, DefinedByBuyerAndSeller, CollectOnDelivery, PaidByBuyer
PortOfDelivery	String		The port where goods on an import purchase order must be delivered by the vendor.
ShippingInstructions	String		Special instructions regarding the shipment.

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.

Select

The following fields are filtered server-side:

• PurchaseOrderNumber supports the '=' comparison
• CreatedDate supports all the >, >=, =, <=, < comparisons

Some example queries:

SELECT * FROM VendorPackingSlips

SELECT * FROM VendorPackingSlips WHERE PurchaseOrderNumber = '12345'

SELECT * FROM VendorPackingSlips WHERE CreatedDate > '2022-09-10T12:00:00' AND CreatedDate < '2022-09-15T12:00:00'

Columns

Name	Type	References	Description
PurchaseOrderNumber [KEY]	String		This field will contain the Purchase Order Number for this order.
Content	String		A Base64encoded string of the packing slip PDF.
ContentType	String		The format of the file such as PDF, JPEG etc

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
CreatedDate	String		Filters for created date. If left empty the default specified range is from 6 days earlier to today

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

---

プロパティ	説明
Schema	The type of schema to use.
AWSRegion	The hosting region for your Amazon Web Services.
AWSAccessKeyId	The AWS AccessKey Id that you received when you registered for Amazon MWS.
Marketplace	The Marketplace region that you are registered to sell in.
MWSAuthToken	The authorization token that you received when you registered for Amazon MWS.
SellerId	The Seller ID that you received when you registered for Amazon MWS.
AWSRoleARN	The Amazon Resource Name of the role to use when authenticating.
AppId	Application Id for Selling Partner app you created.
AWSSessionToken	AWS Session Token for Selling Partner app you created.
AWSAccessKey	Your AWS access key.
AWSSecretKey	Your AWS secret key.
SellingPartner	Specifies the type of Selling Partner.
IncludeRestrictedData	Determinies if Restricted Data Tokens (RDT) should be used to retrieve Personally Identifiable Information (PII)
UseSandbox	A boolean determining if the connection should be made to the Selling Partner sandbox account.

OAuth

---

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。
OAuthAppStatus	Specifies whether the specified SellingPartner OAuth App is in Draft status or Published Status.

SSL

---

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

Firewall

---

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

Proxy

---

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

Logging

---

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

Schema

---

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

Miscellaneous

---

プロパティ	説明
IncludeReports	Set this connection property to true to expose already created reports as views, this property is avaible for both schemes (Marketplace and SellingPartner).
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
ProcedurePooling	Whether or not to get feed results after an execution of a stored procedure.
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
ReportTypes	Set this connection property to one or more report types to filter reports.
RowScanDepth	The maximum number of rows to scan to look for the columns datatype in a report.
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
TypeDetectionScheme	Specifies how to determine the data types of columns when selecting from Reports.
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。
UseSimpleNames	テーブルとカラムに簡略名を使用するかどうかを決定するboolean。

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

---

プロパティ	説明
Schema	The type of schema to use.
AWSRegion	The hosting region for your Amazon Web Services.
AWSAccessKeyId	The AWS AccessKey Id that you received when you registered for Amazon MWS.
Marketplace	The Marketplace region that you are registered to sell in.
MWSAuthToken	The authorization token that you received when you registered for Amazon MWS.
SellerId	The Seller ID that you received when you registered for Amazon MWS.
AWSRoleARN	The Amazon Resource Name of the role to use when authenticating.
AppId	Application Id for Selling Partner app you created.
AWSSessionToken	AWS Session Token for Selling Partner app you created.
AWSAccessKey	Your AWS access key.
AWSSecretKey	Your AWS secret key.
SellingPartner	Specifies the type of Selling Partner.
IncludeRestrictedData	Determinies if Restricted Data Tokens (RDT) should be used to retrieve Personally Identifiable Information (PII)
UseSandbox	A boolean determining if the connection should be made to the Selling Partner sandbox account.

The type of schema to use.

解説

The available schemas are Marketplace and SellingPartner.

The hosting region for your Amazon Web Services.

解説

The hosting region for your Amazon Web Services. Available values are OHIO, NORTHERNVIRGINIA, NORTHERNCALIFORNIA, OREGON, CAPETOWN, HONGKONG, MUMBAI, OSAKA, SEOUL, SINGAPORE, SYDNEY, TOKYO, CENTRAL, BEIJING, NINGXIA, FRANKFURT, IRELAND, LONDON, MILAN, PARIS, STOCKHOLM, BAHRAIN, SAOPAULO, GOVCLOUDEAST, and GOVCLOUDWEST.

The AWS AccessKey Id that you received when you registered for Amazon MWS.

解説

Use this connection property to override the embedded AWSAccessKeyId.

The Marketplace region that you are registered to sell in.

解説

Available regions are United States, Canada, Mexico, Brazil, Spain, United Kingdom, France, Belgium, Netherlands, Germany, Italy, Sweden, Poland, Egypt, Turkey, Saudi Arabia, United Arab Emirates, India, China, Singapore, Japan, and Australia.

The authorization token that you received when you registered for Amazon MWS.

解説

The authorization token that you received when you registered for Amazon MWS.

The Seller ID that you received when you registered for Amazon MWS.

解説

If Seller ID not specified, then the Merchant identifier is required to authenticate.

The Amazon Resource Name of the role to use when authenticating.

解説

When authenticating outside of AWS, it is common to use a Role for authentication instead of your direct AWS account credentials. Entering the AWSRoleARN will cause the CData Sync App to perform a role based authentication instead of using the AWSAccessKey and AWSSecretKey directly. The AWSAccessKey and AWSSecretKey must still be specified to perform this authentication. You cannot use the credentials of an AWS root user when setting RoleARN. The AWSAccessKey and AWSSecretKey must be those of an IAM user.

Application Id for Selling Partner app you created.

解説

Application Id for Selling Partner app you created.

AWS Session Token for Selling Partner app you created.

解説

AWS Session Token can be obtained from AssumeRole request to AWS. AWSAccessKeyId and AWSSecretKey should also be provided when setting AWSSessionToken.

Your AWS access key.

解説

This is the Access Key tied to the AWS user that is associated with the the OAuthClientId.

Your AWS secret key.

解説

This is the Secret Key tied to the AWS user that is associated with the the OAuthClientId.

Specifies the type of Selling Partner.

解説

Specifies the type of Selling Partner, which can be Seller or Vendor.

Determinies if Restricted Data Tokens (RDT) should be used to retrieve Personally Identifiable Information (PII)

解説

Determinies if Restricted Data Tokens (RDT) should be used to retrieve Personally Identifiable Information (PII)

A boolean determining if the connection should be made to the Selling Partner sandbox account.

解説

A boolean determining if the connection should be made to the Selling Partner sandbox account.

Note: To use Sandbox account, set Schema to 'SellingPartner'.

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

---

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。
OAuthAppStatus	Specifies whether the specified SellingPartner OAuth App is in Draft status or Published Status.

OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId 値、およびクライアントシークレットOAuthClientSecret が提供されます。

OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId が提供されます。また、コンシューマーシークレットと呼ばれるクライアントシークレットも提供されます。クライアントシークレットをOAuthClientSecret プロパティに設定します。

Specifies whether the specified SellingPartner OAuth App is in Draft status or Published Status.

解説

Specifies whether the specified SellingPartner OAuth App is in Draft status or Published Status.

If you set this property to 'Draft', the version=beta parameter is added to OAuth authorization URI, and the workflow authorizes an application in Draft state. Otherwise, the workflow authorizes an application published on the Amazon Seller Central Partner Network.

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

---

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：

説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

---

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

プロキシベースのファイアウォールで使われるプロトコル。

解説

このプロパティは、Sync App がFirewallServer プロキシ経由でトンネルトラフィックを使うためのプロトコルを指定します。デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し次のプロキシタイプのどれかで接続するには、ProxyAutoDetect をfalse に設定します。

タイプ	デフォルトポート	説明
TUNNEL	80	これが設定されている場合、Sync App はAmazon Marketplace への接続を開き、プロキシを経由して通信が行われます。
SOCKS4	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 4 プロキシ経由で送信し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 5 プロキシ経由で送信します。プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

プロキシベースのファイアウォールの名前もしくはIP アドレス。

解説

ファイアウォールトラバーサルを許容するために設定するIP アドレス、DNS 名、もしくはプロキシホスト名を指定するプロパティです。プロトコルはFirewallType で指定されます。このプロパティとFirewallServer を使って、SOCKS 経由での接続、もしくはトンネリングが可能です。HTTP プロキシへの接続には、ProxyServer を使用します。

Sync App はデフォルトでシステムプロキシを使うので注意してください。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定してください。

プロキシベースのファイアウォールのTCP ポート。

解説

ファイアウォールトラバーサルを許容するために設定するプロキシベースのファイアウォールのTCP ポート。名前もしくはIP アドレスを指定するには、FirewallServer を使います。FirewallType でプロトコルを指定します。

プロキシベースのファイアウォールに認証するために使うユーザー名。

解説

FirewallUser およびFirewallPassword プロパティは、FirewallType により指定された認証方式に則り、FirewallServer、およびFirewallPort で指定されたプロキシに対しての認証に使われます。

プロキシベースのファイアウォールへの認証に使われるパスワード。

解説

このプロパティは、FirewallType により指定された認証メソッドに則り、FirewallServer およびFirewallPort で指定されたプロキシに渡されます。

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

---

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

解説

これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。

解説

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。HTTP プロキシへの認証には、Sync App はHTTP、Windows(NTLM)、もしくはKerberos 認証タイプを使用することができます。

SOCKS プロキシを経由して接続する、もしくは接続をトンネルするには、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定します。

ProxyServer プロキシが起動しているTCP ポート。

解説

HTTP トラフィックをリダイレクトするHTTP プロキシが実行されているポート。ProxyServer でHTTP プロキシを指定します。その他のプロキシタイプについては、FirewallType を参照してください。

ProxyServer プロキシへの認証で使われる認証タイプ。

解説

この値は、ProxyServer およびProxyPort で指定されるHTTP プロキシに認証するために使われる認証タイプを指定します。

Sync App は、デフォルトでsystem proxy settings を使い、追加での設定が不要です。他のプロキシへの接続をする場合には、ProxyServer およびProxyPort に加え、ProxyAutoDetect をfalse に設定します。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

認証タイプは、次のどれかになります。

• BASIC： Sync App はHTTP BASIC 認証を行います。
• DIGEST： Sync App はHTTP DIGEST 認証を行います。
• NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKereros トークンを取得します。
• PROPRIETARY： Sync App はNTLM もしくはKerberos トークンを発行しません。このトークンを、HTTP リクエストのAuthorization ヘッダーに含める必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyServer プロキシへの認証に使われるユーザー名。

解説

ProxyUser および ProxyPassword オプションは、ProxyServer で指定されたHTTP プロキシに対して接続および認証するために使用されます。

ProxyAuthScheme で使用可能な認証タイプを選択することができます。HTTP 認証を使う場合、これをHTTP プロキシで識別可能なユーザーのユーザー名に設定します。Windows もしくはKerberos 認証を使用する場合、このプロパティを次の形式のどれかでユーザー名に設定します。

user@domain
domain\user

ProxyServer プロキシへの認証に使われるパスワード。

解説

このプロパティは、NTLM(Windows)、Kerberos、もしくはHTTP 認証をサポートするHTTP プロキシサーバーに認証するために使われます。HTTP プロキシを指定するためには、ProxyServer およびProxyPort を設定します。認証タイプを指定するためにはProxyAuthScheme を設定します。

HTTP 認証を使う場合、さらにHTTP プロキシにProxyUser およびProxyPassword を設定します。

NTLM 認証を使う場合、Windows パスワードにProxyUser およびProxyPassword を設定します。Kerberos 認証には、これらを入力する必要があります。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシに接続する場合には、これをfalse に設定します。

ProxyServer プロキシへの接続時に使用するSSL タイプ。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この値は、AUTO、ALWAYS、NEVER、TUNNEL のいずれかです。有効な値は次のとおりです。

AUTO	デフォルト設定。URL がHTTPS URL の場合、Sync App は、TUNNEL オプションを使います。URL がHTTP URL の場合、コンポーネントはNEVER オプションを使います。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続は、トンネリングプロキシを経由します。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Sync App は、追加設定なしにデフォルトでシステムのプロキシ設定を使います。この接続のプロキシ例外を明示的に構成するには、ProxyAutoDetect をfalse に設定して、ProxyServer およびProxyPort を設定する必要があります。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

---

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

ログファイルに含めるコアモジュール。

解説

指定された（';' で区切られた）モジュールのみがログファイルに含まれます。デフォルトではすべてのモジュールが含まれます。

概要はログ ページを参照してください。