I need to check the status in all subscribers and then update the status in publication lists using a query. How can I directly target publication lists in the query activity?

Or do I need to get the data in a data extension and then use import activity to update the publication lists?


The latter. You can't update System Data View data with a Query Activity. It's a read-only view. You'll have to export the results in a Data Extension to a file and import it into the List or Publication. Steps in the Automation would be:

  1. Query Activity to select subscribers to update
  2. Export the Data Extension to a file using a Data Extract activity
  3. Import the file with an Import Activity
  • Instead, we can use SSJS also in the automation to update the publication list. Right? @Adam Spriggs
    – sfdcFanBoy
    Apr 11 '18 at 3:38
  • 1
    Yes, you could use a Script Activity. You're limited to working with 2500 rows at a time and also a strict 30 minute timeout window.. Apr 11 '18 at 13:32

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.