searching contacts in Auto-Suppression Lists

Question

I want to know if a email adress is member of a Auto-Suppression Lists. (without exporting it as an csv). Is there a chance?

Answer 1

You can query your Auto-Suppression list using SQL.

In this case, try something like this in Query Studio:

SELECT 
[Email Address] AS Email 
FROM [YOUR_LISTS_NAME] 
WHERE [Email Address] = '[email protected]'

Depending on the result, you'll know if the email adress is in your list or not..

Edit:

As Adam pointed out on the comments, Auto-Suppression list is basically a Data Extension. Therefore, we can query it, treat it in SSJS as it is: a Data Extension using Data Extensions functions.. (check out Eliot's example)