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

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?
"ba"
"c"
"s"
"s"."m"
"s"."s"
"s"."on"
"s"."d"

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

2 Replies

Reply to Thread
2
Robert Emmett 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
Robert Emmett
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com
0
John Doe Replied
Perfect, thank you Robert!

Reply to Thread