I'm attempting to follow the first example shown on http://help.exacttarget.com/en-US/documentation/exacttarget/content/ampscript/ampscript_syntax_guide/data_extension_ampscript_functions/ and it says that variable 3 and 4 are related to the data extension key but it doesn't specify what it is.
S1 The name of the data extension for the claim or retrieve action
S2 The name of the column in the data extension that indicates whether the row is claimed or not
S3 The name of the data extension key column
S4 The value of the data extension key column
Based on their example code and database they show i'm going to assume that data extension key is not the Primary Key in the data table. It also doesn't appear to be the data extensions External Key. So what is it?
Here is my current Ampscript
%%[VAR @CouponRow
SET @CouponRow = ClaimRow("newsletter_coupon_20", "IsClaimed", "newsletter_coupon_20_key", newsletter_coupon_20_key )
IF EMPTY(@CouponRow) THEN ]%%
No Coupon Available
%%[ ELSE ]%%
Coupon Code = %%= FIELD(@CouponRow, "coupon_code") =%%
%%[ ENDIF ]%%
It returns this error when I try to validate it
Error 1: Script SET Statement Invalid
An error occurred when attempting to resolve a script expression. See inner exception for detail. Script Expression: ClaimRow("newsletter_coupon_20", "IsClaimed", "newsletter_coupon_20_key", newsletter_coupon_20_key ) MemberID: redacted JobID: 0 The specified attribute or custom object field name was not found for this client. Function Call: ClaimRow("newsletter_coupon_20", "IsClaimed", "newsletter_coupon_20_key", newsletter_coupon_20_key ) Attribute or Field Name: newsletter_coupon_20_key
Invalid Content:
SET @CouponRow = ClaimRow("newsletter_coupon_20", "IsClaimed", "newsletter_coupon_20_key", newsletter_coupon_20_key )
I've been digging around in the Exact Target Help and I can't locate a description of what the Data Extension Key is.