MailChimp - List Campaigns doesn't list campaigns

[Jronash]

Anyone here use the MailChimp connector?

In a flow I'm building, I have the ID of a MailChimp campaign, and I want to use the MailChimp connector to retrieve the Campaign Title.  There isn't a Get campaign action, but there is a 'List campaigns', which implies it will return all the campaigns in an account.

Fine, I think, I'll just get all the campaigns and use a Filter Array to find the one with my ID.  But List campaigns only returns 10 campaigns, and it seems to be fairly random.  There are a few from 2013, a few from 2016, some from last year, etc.

The action has no inputs, so I can't change the limit or ask for a specific date range or anything like that.

Is this how it's supposed to work?  It seems pretty useless...

[rmcal]

Sorry I have nothing useful to add -- but have come here in search of a similar answer (using Logic Apps with the Mailchimp Connector). The mailchimp API requires pagination and only will return 10 campaigns by default. Hopefully we're missing something simple!

[Jronash]

I don't think we're missing anything - some flow actions have additional settings that allow you to return multiple pages of results in situations like this, but the MailChimp connector does not.

From what I can tell, it's just a case where someone threw together a connector very quickly and didn't bother testing it to see if the functionality was useful or not.

The MailChimp API is good, so it would be relatively easy to build a custom connector that would work better than theirs, but that's overkill for a tiny project like this.  Maybe sometime down the road.

[tonyvisconti]

so who builds these connectors and how do we request they add pagination? The show list members action is also missing pagination.

[Jronash]

MailChimp would be responsible for the connector.

[rmcal]

FYI I put in a ticket back in January and Mailchimp said they did NOT create this connector. I suggested they should try to contact Microsoft since it's advertised as 'premium' and sure seems like they designed it...

"Taking a look at that integration I can confirm that was not developed by Mailchimp and would not be able to be supported by us. Mailchimp has an open API reference that any developer can use to create their own integrations."

[Jronash]

Huh, that's interesting.  In my experience, premium connectors are usually provided by the company they represent.

However, on the MailChimp connector page, Microsoft is listed as the contact.  Looks like you are correct that you'd need to follow up with Microsoft about this.

[tonyvisconti]

I looked at doing a custom connector using the wizard (Create a custom connector from scratch | Microsoft Docs) but those do not allow you to dynamically set the api url. 

Instead I am going to just try to hit the api directly with an http get request

Custom Connector with Dynamic URL - Power Platform Community (microsoft.com)

[Jronash]

You could use the List campaigns endpoint to return all campaigns (with a custom connector), or you could use the Get campaign info endpoint to get information about a specific campaign, if you know the ID. 

https://mailchimp.com/developer/marketing/api/campaigns/

Either should be possible with a custom connector.

[ndaswani]

Hi, we have basically worked arround a solution for it by declaring a VARIABLE that has the ID of the list I want to collect the information from ( MAILCHIMP - AUDIENCES -Audience name and campaign defaults) and then sendind the information trough the variable on POWER AUTOMATE.