Returns the list of promo codes under a promo rule.

View-Specific Information

Select

The driver uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.

Column	Supported Operators
StoreId	=
PromoRuleId	=
Id	=

For example, the following queries are processed server-side:

SELECT * FROM EcommercePromoCodes
SELECT * FROM EcommercePromoCodes WHERE Id = 'test_promorule2'
SELECT * FROM EcommercePromoCodes WHERE PromoRuleId = 'test_promorule2' AND StoreId = 'YM_Store'
SELECT * FROM EcommercePromoCodes WHERE PromoRuleId = 'test_promorule2' AND StoreId = 'YM_Store' AND Id = 'test_promorule2'

Note: To retrieve the StoreId, query the EcommerceStores view. To retrieve the PromoRuleId, query the PromoRules view.

Columns

Name	Type	ReadOnly	References	Description
StoreId [KEY]	String	False		The Id of the store.
PromoRuleId [KEY]	String	False	EcommercePromoRules.Id	The Id of the associated promo rule.
Id [KEY]	String	False		The unique identifier of the promo code.
Code	String	False		The actual promotional code.
RedemptionUrl	String	False		URL used to redeem the promo code.
UsageCount	Integer	False		Number of times the code has been used.
Enabled	Boolean	False		Indicates whether the promo code is currently enabled.
CreatedAtForeign	Datetime	False		The date and time the promotion was created in ISO 8601 format.
UpdatedAtForeign	Datetime	False		The date and time the promotion was updated in ISO 8601 format.
Links	String	True		A list of link types and descriptions for the API schema documents.