how to get all customers binding to a given mailing list?

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

bhcuong2008
Posts: 26
Joined: Fri Apr 11, 2014 3:56 pm

how to get all customers binding to a given mailing list?

Post by bhcuong2008 »

Hi,

I'd like to get all customers binding to a given mailing list with Script Action. I've looked at
the Script Action Documentation 1.7, but I could not find any related functions for this task.

It's the same as search bar in recipient screen where we can choose a specific mailing list to get
all recipients within that list.

My purpose is to get stats of the mailing list such as the number of active/bounced/... recipients.

Please tell me how?

Thanks.
bhcuong2008
Posts: 26
Joined: Fri Apr 11, 2014 3:56 pm

Re: how to get all customers binding to a given mailing list

Post by bhcuong2008 »

I've also looked at web service 2.0. It doesn't have any method for getting all customers binding to a given mailing list.

I really need this method for automatic list report. With SQL, we could do it easily like this

select *.customer_id from binding_table where mailinglist_id = 100

I wonder how to do this via openemm web service v2.0 or Script Action methods.
Post Reply