pulling email list

330 views
Skip to first unread message

Keyinora Darkmoon

unread,
Feb 10, 2014, 4:01:14 PM2/10/14
to mailchimp-...@googlegroups.com
hello,
I have been trying to figure out the best why to pull all the fields in my email list so that i can store it on my companies DB.
what i have been able to get so far is just the email address, and the status if they are subscribe or not, when using one of the API (mailChimp.net).
 I can't seem to figure out how to get the rest of the fields, and the documentation for both his API, and the others on your site haven't been very helpful. 
So i was wondering, what do i need to uses to accomplish this?

MailChimp Support

unread,
Feb 10, 2014, 5:05:38 PM2/10/14
to mailchimp-...@googlegroups.com
Hey, Keyinora. That's as easy as calling lists/members: http://apidocs.mailchimp.com/api/2.0/lists/members.php With just an API key and your list ID, it will return every email address and their individual field values.

-- Anna

Keyinora Darkmoon

unread,
Feb 14, 2014, 3:06:57 PM2/14/14
to mailchimp-...@googlegroups.com
Ah, awesome thanks Anna, i also was wondering with that method can i specify what fields are returned? say i don't want timestamp, or address to be returned. Can that be done with that method


--
You received this message because you are subscribed to the Google Groups "MailChimp API Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.
To post to this group, send email to mailchimp-...@googlegroups.com.
Visit this group at http://groups.google.com/group/mailchimp-api-discuss.
For more options, visit https://groups.google.com/groups/opt_out.

MailChimp Support

unread,
Feb 14, 2014, 4:26:15 PM2/14/14
to mailchimp-...@googlegroups.com
You won't be able to limit what's returned, but of course you can limit which returned parameters you choose to use further.

-- Anna


On Friday, February 14, 2014 3:06:57 PM UTC-5, Keyinora Darkmoon wrote:
Ah, awesome thanks Anna, i also was wondering with that method can i specify what fields are returned? say i don't want timestamp, or address to be returned. Can that be done with that method
On Mon, Feb 10, 2014 at 5:05 PM, MailChimp Support <rsg...@gmail.com> wrote:
Hey, Keyinora. That's as easy as calling lists/members: http://apidocs.mailchimp.com/api/2.0/lists/members.php With just an API key and your list ID, it will return every email address and their individual field values.

-- Anna


On Monday, February 10, 2014 4:01:14 PM UTC-5, Keyinora Darkmoon wrote:
hello,
I have been trying to figure out the best why to pull all the fields in my email list so that i can store it on my companies DB.
what i have been able to get so far is just the email address, and the status if they are subscribe or not, when using one of the API (mailChimp.net).
 I can't seem to figure out how to get the rest of the fields, and the documentation for both his API, and the others on your site haven't been very helpful. 
So i was wondering, what do i need to uses to accomplish this?

--
You received this message because you are subscribed to the Google Groups "MailChimp API Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-discuss+unsub...@googlegroups.com.

Keyinora Darkmoon

unread,
Feb 18, 2014, 3:17:46 PM2/18/14
to mailchimp-...@googlegroups.com

for the batch-subscribe method, having some trouble getting the struct down

https://us7.api.mailchimp.com/2.0/lists/batch-subscribe.xml?apikey=*********&id=********&batch[email][email=Barry...@americanlandlease.com]&batch[merge_vars]fname=barry

can you point out what i did wrong in my query string, and provide me with the correct format to sub an email,and pass the first, and last name


To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.

MailChimp Support

unread,
Feb 18, 2014, 4:31:54 PM2/18/14
to mailchimp-...@googlegroups.com
Using a url is a bit more complex. The arrays just need some adjusting:
https://us7.api.mailchimp.com/2.0/lists/batch-subscribe.xml?apikey=*********&id=********&batch[0][email]=Ba...@email.com&batch[0]merge_vars][fname]=barry
If you needed to add a second person to your call:
https://us7.api.mailchimp.com/2.0/lists/batch-subscribe.xml?apikey=*********&id=********&batch[0][email]=Ba...@email.com&batch[0]merge_vars][fname]=barry&batch[1][email]=Ma...@email.com&batch[1]merge_vars][fname]=Mary

Hope that helps!
-- Anna


On Tuesday, February 18, 2014 3:17:46 PM UTC-5, Keyinora Darkmoon wrote:

for the batch-subscribe method, having some trouble getting the struct down



can you point out what i did wrong in my query string, and provide me with the correct format to sub an email,and pass the first, and last name
On Fri, Feb 14, 2014 at 4:26 PM, MailChimp Support <rsg...@gmail.com> wrote:
You won't be able to limit what's returned, but of course you can limit which returned parameters you choose to use further.

-- Anna


On Friday, February 14, 2014 3:06:57 PM UTC-5, Keyinora Darkmoon wrote:
Ah, awesome thanks Anna, i also was wondering with that method can i specify what fields are returned? say i don't want timestamp, or address to be returned. Can that be done with that method
On Mon, Feb 10, 2014 at 5:05 PM, MailChimp Support <rsg...@gmail.com> wrote:
Hey, Keyinora. That's as easy as calling lists/members: http://apidocs.mailchimp.com/api/2.0/lists/members.php With just an API key and your list ID, it will return every email address and their individual field values.

-- Anna


On Monday, February 10, 2014 4:01:14 PM UTC-5, Keyinora Darkmoon wrote:
hello,
I have been trying to figure out the best why to pull all the fields in my email list so that i can store it on my companies DB.
what i have been able to get so far is just the email address, and the status if they are subscribe or not, when using one of the API (mailChimp.net).
 I can't seem to figure out how to get the rest of the fields, and the documentation for both his API, and the others on your site haven't been very helpful. 
So i was wondering, what do i need to uses to accomplish this?

--
You received this message because you are subscribed to the Google Groups "MailChimp API Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-discuss+unsubscri...@googlegroups.com.
To post to this group, send email to mailchimp-...@googlegroups.com.

Keyinora Darkmoon

unread,
Feb 18, 2014, 4:39:41 PM2/18/14
to mailchimp-...@googlegroups.com
getting -99 error An email address must contain a single @
the email am putting in does have a @, not sure why it won't go through


To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.

MailChimp Support

unread,
Feb 18, 2014, 5:07:17 PM2/18/14
to mailchimp-...@googlegroups.com
Missed an extra [email] in the array. There's an email array within the email parameter. Sorry about that:
https://us7.api.mailchimp.com/
2.0/lists/batch-subscribe.xml?apikey=*********&id=********&batch[0][email][email]=Ba...@email.com&batch[0]merge_vars][fname]=barry

-- Anna


On Tuesday, February 18, 2014 4:39:41 PM UTC-5, Keyinora Darkmoon wrote:
getting -99 error An email address must contain a single @
the email am putting in does have a @, not sure why it won't go through

Keyinora Darkmoon

unread,
Feb 19, 2014, 1:41:53 PM2/19/14
to mailchimp-...@googlegroups.com
I was also wondering, not sure if i asked this already, but. currently we create a csv file, and upload it, and click the auto-update existing list, so we don't lose them when we import. does setting update_existing for the batch-subscribe method accomplish the same thing?


To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.

MailChimp Support

unread,
Feb 19, 2014, 1:53:33 PM2/19/14
to mailchimp-...@googlegroups.com
Yep! You're exactly right. The update_exisiting boolean when set to "true" would update all subscribers with the data contained in the API call, even if the subscribers are already on the list(just like the auto update checkbox in the web app).

-Brian

Keyinora Darkmoon

unread,
Feb 19, 2014, 3:26:03 PM2/19/14
to mailchimp-...@googlegroups.com
awesome, I also noticed that the method also has a Double_option boolean value, and that if i set it false that people won't get an email about it. question is. for anyone that is already on my list, will they get this email again, or does it just skip them, as long as i have update_existing set to true? the worry i have is that we will be doing this alot, and i can see how people would get rather annoyed by getting optin emails over and over agin.


To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.

MailChimp Support

unread,
Feb 19, 2014, 3:50:42 PM2/19/14
to mailchimp-...@googlegroups.com
If they are already on your list, and an API call is run with the double_optin boolean is set the to true, it would not send out another confirmation email to that subscriber.

-Brian

Keyinora Darkmoon

unread,
Feb 19, 2014, 4:37:30 PM2/19/14
to mailchimp-...@googlegroups.com
what would be the best course of action to test out my code? create a test list? is there any downside to this?

I want to try my batch-sub code out



On Wed, Feb 19, 2014 at 3:50 PM, MailChimp Support <bgoud...@rsglab.com> wrote:
If they are already on your list, and an API call is run with the double_optin boolean is set the to true, it would not send out another confirmation email to that subscriber.

-Brian

--

MailChimp Support

unread,
Feb 19, 2014, 5:12:50 PM2/19/14
to mailchimp-...@googlegroups.com
Yep! Exactly! Just create a test list in your MailChimp account to test those calls out on. No harm at all in doing that. Let us know if we can provide any more support!

-Brian

Keyinora Darkmoon

unread,
Feb 20, 2014, 11:15:28 AM2/20/14
to mailchimp-...@googlegroups.com
if i was to go format by json for the batch-sub, do i need to add a count indicated like batch[1]?
{ "apikey": "example apikey", "id": "example id", "batch": [ { "email": { "email": "example email", "euid": "example euid", "leid": "example leid" }, "email_type": "example email_type", "merge_vars": { "...": "..." } } ], "double_optin": true, "update_existing": true, "replace_interests": true }




On Wed, Feb 19, 2014 at 5:12 PM, MailChimp Support <bgoud...@rsglab.com> wrote:
Yep! Exactly! Just create a test list in your MailChimp account to test those calls out on. No harm at all in doing that. Let us know if we can provide any more support!

-Brian

--

MailChimp Support

unread,
Feb 20, 2014, 11:18:25 AM2/20/14
to mailchimp-...@googlegroups.com
No.  If you were to take that example code and just fill in the parameters as illustrated, that is all you would need.

-Tyler

Keyinora Darkmoon

unread,
Feb 20, 2014, 4:10:36 PM2/20/14
to mailchimp-...@googlegroups.com
I have setup json with my system, and i noticed that i can only send a max of 18, any more then that and it won't added. Is this the max amount of batch sub you can do for that function?


On Thu, Feb 20, 2014 at 11:18 AM, MailChimp Support <tw...@rsglab.com> wrote:
No.  If you were to take that example code and just fill in the parameters as illustrated, that is all you would need.

-Tyler

--

MailChimp Support

unread,
Feb 21, 2014, 6:14:16 AM2/21/14
to mailchimp-...@googlegroups.com
Hi Keyinora,

If you refer to lists/batch-subscribe you'll notice that there is a limit for how large your batch is, but realistically you should not be running into it at 18 subscribers. 

Are you receiving any error messages ?  If so, make sure to pay attention to the specific details along with the error to see why the call might be failing.

If you're receiving a success message, then chances are the way your calls are being made is causing the data to be dropped even though it has a proper syntax and you will want to examine your code further.  I would suggest first starting with a simple call, passing only data such as the email address and first name.  From there once you get that consistently working you can add more data to your subscriber structs.

-Tyler

Keyinora Darkmoon

unread,
Feb 21, 2014, 10:31:23 AM2/21/14
to mailchimp-...@googlegroups.com
no error messages but for status it is returning 0, what does that indicate?


--

Keyinora Darkmoon

unread,
Feb 24, 2014, 12:01:58 PM2/24/14
to mailchimp-...@googlegroups.com
I think my syntacs is off

folling this example , do i need any comma to separate the emails like {"email" :{"email": "example")}, {"email" :{"email": "example")}, or like this  {"email" :{"email": "example")} {"email" :{"email": "example")}
{ "apikey": "example apikey", "id": "example id", "batch": [ { "email": { "email": "example email", "euid": "example euid", "leid": "example leid" }, "email_type": "example email_type", "merge_vars": { "...": "..." } } ], "double_optin": true, "update_existing": true, "replace_interests": true }

MailChimp Support

unread,
Feb 24, 2014, 3:57:58 PM2/24/14
to mailchimp-...@googlegroups.com
Hey, Keyinora. Since this forum is for answering questions about the MailChimp API specifically, we won't be the best resource to instruct on how to use JSON or validate JSON code for you. Instead you'll need to work with a JSON validator (like this one: http://jsonlint.com/), maybe find a few JSON/coding community forums addressing how to set up multiple structs, and test different scenarios on your own. Best of luck!

-- Anna


On Monday, February 24, 2014 12:01:58 PM UTC-5, Keyinora Darkmoon wrote:
I think my syntacs is off

folling this example , do i need any comma to separate the emails like {"email" :{"email": "example")}, {"email" :{"email": "example")}, or like this  {"email" :{"email": "example")} {"email" :{"email": "example")}
{ "apikey": "example apikey", "id": "example id", "batch": [ { "email": { "email": "example email", "euid": "example euid", "leid": "example leid" }, "email_type": "example email_type", "merge_vars": { "...": "..." } } ], "double_optin": true, "update_existing": true, "replace_interests": true }
On Fri, Feb 21, 2014 at 10:31 AM, Keyinora Darkmoon <ddrav...@gmail.com> wrote:
no error messages but for status it is returning 0, what does that indicate?
On Fri, Feb 21, 2014 at 6:14 AM, MailChimp Support <tw...@rsglab.com> wrote:
Hi Keyinora,

If you refer to lists/batch-subscribe you'll notice that there is a limit for how large your batch is, but realistically you should not be running into it at 18 subscribers. 

Are you receiving any error messages ?  If so, make sure to pay attention to the specific details along with the error to see why the call might be failing.

If you're receiving a success message, then chances are the way your calls are being made is causing the data to be dropped even though it has a proper syntax and you will want to examine your code further.  I would suggest first starting with a simple call, passing only data such as the email address and first name.  From there once you get that consistently working you can add more data to your subscriber structs.

-Tyler

--
You received this message because you are subscribed to the Google Groups "MailChimp API Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-discuss+unsub...@googlegroups.com.

Keyinora Darkmoon

unread,
Feb 26, 2014, 12:58:47 PM2/26/14
to mailchimp-...@googlegroups.com
is there a way to pull from a list the emails that have unsubscribed?


To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.

Anna

unread,
Feb 26, 2014, 1:46:39 PM2/26/14
to mailchimp-...@googlegroups.com
Yes, thats possible through lists/members: http://apidocs.mailchimp.com/api/2.0/lists/members.php
Most answers to questions about functionality can be found by reviewing our documentation at http://apidocs.mailchimp.com/2.0/

-- Anna


On Wednesday, February 26, 2014 12:58:47 PM UTC-5, Keyinora Darkmoon wrote:
is there a way to pull from a list the emails that have unsubscribed?
On Mon, Feb 24, 2014 at 3:57 PM, MailChimp Support <rsg...@gmail.com> wrote:
Hey, Keyinora. Since this forum is for answering questions about the MailChimp API specifically, we won't be the best resource to instruct on how to use JSON or validate JSON code for you. Instead you'll need to work with a JSON validator (like this one: http://jsonlint.com/), maybe find a few JSON/coding community forums addressing how to set up multiple structs, and test different scenarios on your own. Best of luck!

-- Anna


On Monday, February 24, 2014 12:01:58 PM UTC-5, Keyinora Darkmoon wrote:
I think my syntacs is off

folling this example , do i need any comma to separate the emails like {"email" :{"email": "example")}, {"email" :{"email": "example")}, or like this  {"email" :{"email": "example")} {"email" :{"email": "example")}
{ "apikey": "example apikey", "id": "example id", "batch": [ { "email": { "email": "example email", "euid": "example euid", "leid": "example leid" }, "email_type": "example email_type", "merge_vars": { "...": "..." } } ], "double_optin": true, "update_existing": true, "replace_interests": true }
On Fri, Feb 21, 2014 at 10:31 AM, Keyinora Darkmoon <ddrav...@gmail.com> wrote:
no error messages but for status it is returning 0, what does that indicate?
On Fri, Feb 21, 2014 at 6:14 AM, MailChimp Support <tw...@rsglab.com> wrote:
Hi Keyinora,

If you refer to lists/batch-subscribe you'll notice that there is a limit for how large your batch is, but realistically you should not be running into it at 18 subscribers. 

Are you receiving any error messages ?  If so, make sure to pay attention to the specific details along with the error to see why the call might be failing.

If you're receiving a success message, then chances are the way your calls are being made is causing the data to be dropped even though it has a proper syntax and you will want to examine your code further.  I would suggest first starting with a simple call, passing only data such as the email address and first name.  From there once you get that consistently working you can add more data to your subscriber structs.

-Tyler

--
You received this message because you are subscribed to the Google Groups "MailChimp API Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-discuss+unsubscri...@googlegroups.com.
To post to this group, send email to mailchimp-...@googlegroups.com.

Keyinora Darkmoon

unread,
Feb 27, 2014, 4:39:59 PM2/27/14
to mailchimp-...@googlegroups.com
Hello,

when i do Batch-subscribe, i get one error 220 for the same email every time i upload, now it does look like every other email goes through, but i was curious why this one wouldn't


To unsubscribe from this group and stop receiving emails from it, send an email to mailchimp-api-di...@googlegroups.com.

phol...@rsglab.com

unread,
Mar 3, 2014, 10:51:40 AM3/3/14
to mailchimp-...@googlegroups.com
Hi Keyinora,
For further assistance, please email api...@mailchimp.com -- as of today, this group is closed to new messages (see this post for more details). 

Thanks,

-Pete
Reply all
Reply to author
Forward
0 new messages