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. Aug 6, 2018 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, 2018 at 13:53
  • LookUpRows on the Lists i just showed you? Aug 6, 2018 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, 2018 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, 2018 at 9:33

1 Answer 1


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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .