Query for mailinglist Acymailing

I want to do some auto actions when users have subscribed via Acymailing for a certain newsletter. This is not possible in CB Auto Actions, unless I do a trick with CB query. I hope I can design a query that fills a CB field; afterwards I can do auto actions based on the CB field. But how do I describe a proper query for the database of Acymailing? I can't find the name of the database and do not know which column I have to mention. Maybe I should ask this the Acymailing support team, but maybe you can also help me, since you promote integration of Acymailing and Community Builder.

So I want to make a CB field named 'mailinglist A'. When a user is on mailinglist A (in Acymailing), than the value of the CB field should become 1.

I am curious if this is possible.

CB Auto Actions performs actions on events. I recommend contacting AcyMailing and see if they've any Joomla events that you can act on as CB Auto Action can act on a Joomla event simply by preventing the event with "joomla_" when configuring the triggers for your auto action. Note you need to be sure you've CB Auto Actions Bot installed as well since it bridges Joomla events to CB Auto Actions.

Aside from that you could just use CB Query Field to check if the user is subscribed to your newsletter and have it respond with 1 or 0 in your query if they are or not. No reason to double store that information unless you need it to be searchable on a userlist.