0

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?

Improve this question

1 Answer 1

Reset to default
2

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
Improve this answer
2
  • Instead, we can use SSJS also in the automation to update the publication list. Right? @Adam Spriggs
    – SFDC FanBoy
    Commented Apr 11, 2018 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..
    – Adam Spriggs
    Commented Apr 11, 2018 at 13:32

You must log in to answer this question.

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