Forum Discussion
Need help with custom API query
Hi there - the MailChimp connector in the Desktop also offers functions that can allow you to interact with the MailChimp API directly. We included those functions knowing that the tables we offered in the navigation pane were only a subset.
The documenation for these functions is actively being improved, but they take the subset of the API path as you saw in the Mailchimp documention. Try something like this (replacing the list ID):
= MailChimp.Instance("lists/{list-id}/growth-history")The function will return the raw result which you can open and parse into a table. Using your example also showed a bug in our MailChimp.Collections function which is the preferred function for this operation (Instance is a raw single page vs. Collections will actually page through all the data into a single table). We'll work on fixing that bug in a future update.
Hope that helps!
Hi there - the MailChimp connector in the Desktop also offers functions that can allow you to interact with the MailChimp API directly. We included those functions knowing that the tables we offered in the navigation pane were only a subset.
The documenation for these functions is actively being improved, but they take the subset of the API path as you saw in the Mailchimp documention. Try something like this (replacing the list ID):
= MailChimp.Instance("lists/{list-id}/growth-history")The function will return the raw result which you can open and parse into a table. Using your example also showed a bug in our MailChimp.Collections function which is the preferred function for this operation (Instance is a raw single page vs. Collections will actually page through all the data into a single table). We'll work on fixing that bug in a future update.
Hope that helps!