SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Amazon Selling Partner (SP-API).

• Download report to local disk
• Generic request: read any API endpoint
• Get order by ID
• List order items for a single order
• List order items for all orders
• List orders
• List report types
• Read report data (TSV)
• Sandbox: get order by ID (fake data)
• Sandbox: list order items (fake data)
• Sandbox: list orders (fake data)