ODBC guide

Read account orders by email

Gets account orders filtered by email or other criteria. Use the AccountOrders table and pass Email='...' (or CustomKey, OrderID, OrderReference, SubscriptionId, Products, Refunds, SubscriptionStatus) in the WITH clause.

SELECT * FROM AccountOrders
WITH (
	  Email='bob@abc.com'
)
	  
--search by one or more parameters below
/*
WITH (
	  Email='X'
	, CustomKey='X'
	, GlobalKey='X'
	, OrderID='X'
	, OrderReference='X'
	, SubscriptionId='X'
	, Products='PROD-1,PROD-2,PROD-3'
	, Refunds='true'
	, SubscriptionStatus='active'
)
*/