跳转至

Amazon Marketplace

The Amazon Marketplace connector is a Palantir-provided driver for Amazon Marketplace.

To create a new Amazon Marketplace source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Amazon Marketplace-specific configuration and networking. For the complete property reference, see the official Amazon Marketplace driver documentation ↗.

Configuration

The properties below are mandatory or recommended.

Property Required? Description Default
IncludeReports Recommended Set this connection property to true to expose already created reports as views, this property is available for both schemas (SellerCentral and VendorCentral). FALSE
InitiateOAuth Recommended Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. REFRESH
Marketplace Recommended The Marketplace region that you are registered to sell in. United States
OAuthClientId Recommended Specifies the client Id that was assigned when the custom OAuth application was created. (Also known as the consumer key.) This ID registers the custom application with the OAuth authorization server.
OAuthClientSecret Recommended Specifies the client secret that was assigned when the custom OAuth application was created. (Also known as the consumer secret). This secret registers the custom application with the OAuth authorization server.
Schema Recommended The type of schema to use. Marketplace
SellerId Recommended The Seller ID or merchant identifier you received when creating the account.

Networking

The table below lists the domains that the source needs to be able to access in order to successfully run.

For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead; the agent host itself must also be able to reach the listed domains. See using an agent as a proxy for details.

Domain Required
sts.\.amazon.com If Schema=SellingPartner, AWSRegion Mappings
sellingpartnerapi-\.amazon.com If Schema=SellingPartner, SellingPartner Mappings
sandbox.sellingpartnerapi-\.amazon.com If Schema=SellingPartner and UseSandbox=True, SellingPartner Sandbox Mappings
mws.amazonservices.\ If Schema=Marketplace, AWSMarketplace Mappings
api.amazon.com If using OAuth
Seller Central URLs If using OAuth
oa.cdata.com If using the embedded CData OAuth credentials

Extracting files

Files can be extracted from Amazon Marketplace by executing the GetReport ↗ stored procedure.

To extract a file, add the following SQL query in the sync definition.

EXECUTE GetReport @ReportDocumentId = '1234'

This will produce an output dataset with the file content stored in a Base64 encoded string column, which should be decoded to binary in a downstream data transformation.


中文翻译

Amazon Marketplace

Amazon Marketplace 连接器是 Palantir 提供的用于 Amazon Marketplace 的驱动程序

要创建新的 Amazon Marketplace 数据源,请遵循 Palantir 提供驱动程序的标准设置流程,然后使用以下各节进行 Amazon Marketplace 特定的配置和网络设置。有关完整的属性参考,请参阅官方 Amazon Marketplace 驱动程序文档 ↗

配置

以下属性为必填或推荐设置。

属性 是否必填 描述 默认值
IncludeReports 推荐 将此连接属性设置为 true 可将已创建的报表作为视图公开,该属性适用于两种模式(SellerCentral 和 VendorCentral)。 FALSE
InitiateOAuth 推荐 指定获取或刷新 OAuth 访问令牌的过程,该令牌可在经过身份验证和授权的用户工作时维持其访问权限。 REFRESH
Marketplace 推荐 您注册进行销售的市场区域。 United States
OAuthClientId 推荐 指定创建自定义 OAuth 应用程序时分配的客户端 ID(也称为消费者密钥)。此 ID 将自定义应用程序注册到 OAuth 授权服务器。
OAuthClientSecret 推荐 指定创建自定义 OAuth 应用程序时分配的客户端密钥(也称为消费者密钥)。此密钥将自定义应用程序注册到 OAuth 授权服务器。
Schema 推荐 要使用的模式类型。 Marketplace
SellerId 推荐 创建账户时收到的卖家 ID 或商家标识符。

网络设置

下表列出了数据源为成功运行而需要能够访问的域名。

对于每个域名,请添加相应的出口策略。如果数据源部署在本地且无法从 Foundry 直接访问,请改用代理出口策略;代理主机本身也必须能够访问列出的域名。有关详细信息,请参阅使用代理作为代理

域名 必需条件
sts.\.amazon.com 如果 Schema=SellingPartner,AWSRegion 映射
sellingpartnerapi-\.amazon.com 如果 Schema=SellingPartner,SellingPartner 映射
sandbox.sellingpartnerapi-\.amazon.com 如果 Schema=SellingPartnerUseSandbox=True,SellingPartner 沙箱映射
mws.amazonservices.\ 如果 Schema=Marketplace,AWSMarketplace 映射
api.amazon.com 如果使用 OAuth
Seller Central URLs 如果使用 OAuth
oa.cdata.com 如果使用嵌入式 CData OAuth 凭据

提取文件

可以通过执行 GetReport ↗ 存储过程从 Amazon Marketplace 提取文件。

要提取文件,请在同步定义中添加以下 SQL 查询。

EXECUTE GetReport @ReportDocumentId = '1234'

这将生成一个输出数据集,其中文件内容存储在 Base64 编码的字符串列中,需要在下游数据转换中解码为二进制格式。