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 '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? 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.