The Amazon Marketplace connector is a Palantir-provided driver connector. The official documentation for this driver can be found here ↗.
Networking
If using an agent connection, the agent must be allowed to connect to the system you choose. This means that the agent must be able to reach the destination IP address, and the destination system must be configured to allow connections from the agent.
If using a direct connection, be sure to add the following egress policies to the connector:
Domain
Required
sts.<AWSRegion>.amazon.com
If Schema=SellingPartner, AWSRegion Mappings
sellingpartnerapi-<AWSRegion>.amazon.com
If Schema=SellingPartner, SellingPartner Mappings
sandbox.sellingpartnerapi-<AWSRegion>.amazon.com
If Schema=SellingPartner and UseSandbox=True, SellingPartner Sandbox Mappings
mws.amazonservices.<Marketplace>
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.
Copied!
1
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.