Currently we are struggling to retrieve multiple rows from Publication list. We have cloud page where we need to fetch all records with same email address and usubscribe them all from Publication List. All the functions(lookuprows, lookuporderedrows etc) we tried are all for Data Extensions. Anyone have idea to how retrieve multiple records from publication list? Please suggest.


  • I am not sure but i strongly believe its either help.salesforce.com/… or help.salesforce.com/… where you should search. – Johannes Schapdick Aug 6 '18 at 13:45
  • Thanks for the response!! we are using ampscript in the cloud page, so there must be some function who does this sort of thing. – R Suri Aug 6 '18 at 13:53
  • LookUpRows on the Lists i just showed you? – Johannes Schapdick Aug 6 '18 at 13:55
  • [LookupRows("ENT._ListSubscribers","SubscriberKey","ListName","ABC_PL","EmailAddress",@sid)] Above is the function we tried to use but cloud page stops previewing. – R Suri Aug 6 '18 at 14:03
  • Any idea here? how can i query Publication list using Ampscript to get multiple records satisfying a condition? – R Suri Aug 7 '18 at 9:33

It's late, but I guess this can be done

SET @Rows = LookupRows("_ListSubscribers","SubscriberKey", @Sub_ID, "ListType","Publication List","Column Name","Value")

You can choose from the following columns listed in here.

This will give you a set of rows which fall under your preference criteria. Then you can move forward according to your need.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.