Dynamic subscribers list as an SQL Query

[cbertelli]

Listmonk is already able to query the address list in a very effective and sophisticated way, but the subscribers list is static.

Could it be possible to use a direct database query to an external database, say using a pre-built logical view, to create a special subscriber list? In this case the list could be dynamically integrated with a CRM or something of the like.

[knadh]

hm, this is not possible without significantly hacking listmonk's core. The recommended method is to keep a CRM and listmonk DB in sync via the APIs, like listening to an event stream and modifying subscribers. lists, subscribers, subscriber_lists are all tables listmonk needs to mutate for a variety of reasons, so they can't be static views.