Forum Discussion

jessem's avatar
jessem
Frequent Visitor
10 years ago

Limiting parameters on custom query?

Specifically for a MailChimp query, I'm pulling in my member data from a few of my lists using this:

 

let
Source = MailChimp.Instance("lists/{list_id}/members?count=15000"),
lists = Source{[Key="lists"]}[Data]

in
Source

 

3 of the lists are relatively small so I don't have any problems, but one of the lists is rather large and keeps timing out. I'm trying to reduce the number of parameters that the query is calling from the beginning so that, hopefully, it can reduce the amount of data coming through and stop timing out. I have 33 different parameters that it's loading when I really only need 5 or 6 of them.

 

Here's the documentation on the API:

http://developer.mailchimp.com/documentation/mailchimp/reference/lists/members/

 

Thanks!

 

(FYI: the 15000 count at the end of the URL is to bypass the default limit of 10 responses. Using a smaller count will cut my data off)

 

 

3 Replies

    • kazlik's avatar
      kazlik
      Helper II

      Have you tried calling the API and same params in a browser or different platform to see if there are still timeouts? This could be an issue on their side.

  • Hi jessem I know this reply is very late. Since the Mailchimp service pack was deprecated, you would have to look for another way. As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options