The Amazon Marketplace connector is a Palantir-provided driver connector. The official documentation for this driver can be found here ↗.
Networking
The table below lists the domains that the source needs to be able to access in order to successfully run.
If running the connection on a Foundry worker, be sure to add corresponding egress policies for each of those domains.
If those domains are in a different network from Foundry's network, and you are using agent proxy egress policies (preferred) or an agent worker (not recommended), the agent must be able to reach the domain addresses. Additionally, the systems on those domains must be configured to allow connections from the agent. Learn more about agent networking.
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.