SmarterMail mailing list list-subscribers.jsons documentation
Question asked by John Doe - 9/8/2020 at 1:04 AM

I am trying to export mailing list subscribers to a different platform. I am using double opt-in. The dashboard export options generates a .csv but it exports all accounts regardless of their double opt-in status.

I found the list-subscribers.jsons file, but the JSON property names are cryptic (I guess to save space), so I don't know what each property name means.

Where can I find schema or some documentation for the file format?

For example, one entry might look like this:

{"e":"some@email.com","ba":"here goes some random hex string","c":{},"s":[{"m":1,"s":"ISO timestamp goes here","on":true,"d":true}]}

What is the meaning of the following?

I am using:
SmarterMail Enterprise
Build 7242 (Oct 30, 2019)

2 Replies

Reply to Thread
Employee Replied
Employee Post Marked As Answer
So the JSONs filetype is a collection of complete JSON elements.  You are correct that the labels were abbreviated to save on space.

e => email_address
ba => bounce_address
c => custom_fields
s => subscriptions
m => message_log

Inside subscriptions you have:
m => mailing_list_id
s => subscribed_on
on => opted_in_normal
od => opted_in_digest
d => double_opted_in
b => bounces
John Doe Replied
Perfect, thank you Robert!

Reply to Thread