ODBC guide

Get order by ID

Read a single order by specifying the order ID. Use the order you want to inspect.

SELECT * FROM Orders 
WHERE AmazonOrderId='902-1845936-5435065'
--CONNECTION(
--	ServiceUrl='https://sellingpartnerapi-na.amazon.com'
--)