Archive > Cloud Pages > How to get an email address from a subscriber Id using APMscript

This pixel uses the following code – https://pages.upmc.com/goto-consumer-preference-center-upmc-bu

%%[
SET @SubscriberID = RequestParameter(‘sfmcid’)
SET @EmailAddress = RequestParameter(‘notsubid’)

IF @SubscriberID > 0 THEN

]%%

IF @SubscriberID > 0 THEN %%[

SET @LookUpDataExtension = ‘_Subscribers’ /* you might need to include ENT. in child business units*/
SET @LookupData = LookupRows(@LookUpDataExtension,’SubscriberID’,@SubscriberID)
SET @DataRowcount = RowCount(@LookupData)

IF @DataRowcount > 0 THEN

]%%

IF @DataRowcount > 0 THEN %%[

  SET @row = Row(@LookupData , 1)
  SET @EmailAddress2 = Field(@row , "SubscriberKey")

  /** THANK YOU EMAIL **/
  SET @ts = CreateObject('TriggeredSend')
  SET @tsDef = CreateObject('TriggeredSendDefinition')
  SetObjectProperty(@tsDef, 'CustomerKey', '4967')
  SetObjectProperty(@ts, 'TriggeredSendDefinition', @tsDef)

 SET @ts_sub = CreateObject('Subscriber')
 SetObjectProperty(@ts_sub, 'EmailAddress', @EmailAddress2)
 SetObjectProperty(@ts_sub, 'SubscriberKey', @EmailAddress2)
 AddObjectArrayItem(@ts, 'Subscribers', @ts_sub)

 SET @de_col = CreateObject("Attribute")
 SetObjectProperty(@de_col, "Name", "email_address")
 SetObjectProperty(@de_col, "Value", @EmailAddress2)
 AddObjectArrayItem(@ts , "Attributes", @de_col )

 SET @ts_statusCode = InvokeCreate(@ts, @ts_statusMsg, @errorCode)
 IF @ts_statusCode != 'OK' THEN
  RaiseError(@ts_statusMsg, 0, @ts_statusCode, @errorCode)
 ENDIF
 /** THANK YOU EMAIL **/

ENDIF
ENDIF

Your email address will not be published. Required fields are marked *