Level 102
Seems it takes parameters. One is $count (10) and one is $offset (page) https://github.com/mailchimp/mailchimp-marketing-php/blob/master/lib/Api/ListsApi.php#L1701
1 like
Feb 14, 2022
15
Level 2
Laravel and Mailchimp API question
Greetings!
I'm new to Laravel. Trying to build an application that gets data using Mailchimp API. It works, but when I'm trying to get a list of lists (sounds funny) I get only 10 out of 15 existed. Anyone already solved that problem? Would be thankful for an advice. Thanks in advance.
The code I use:
Route::get('/', function(){ $client = new MailchimpMarketing\ApiClient(); $client->setConfig([ 'apiKey' => config('services.mailchimp.key'), 'server' => 'usXX', ]);
$response = $client->lists->getAllLists();
$lists = $response->lists;
return view('index', [
'lists' => $lists,
]);
});
Level 2
@Sinnbeck Thanks! I knew some kind of pagination was involved. ) You mean I can modify the code of that ListsApi.php changing $count = '10' to $count = '20'? Is it legal? I will not get in jail for that? )
Level 102
@AnatoliyViktorovich I honestly have no clue as I dont use mailchimp, but I doubt very much you will go to jail :D Worst case they will throttle your connection or close your api key.
Seems the max is a 1000, so anything below that is probably fine: https://mailchimp.com/developer/marketing/api/lists/get-lists-info/
The number of records to return. Default value is 10. Maximum value is 1000
1 like
Level 2
@Sinnbeck Thanks! It works!!! I spent days with chimp support trying to figure this out... And you needed just few minutes. )
One more question if you don't mind. How do I sort received lists by number of members in it Desc? Can't figure it out.
Level 102
@AnatoliyViktorovich I'm just used to reading the source code when I need to implement new stuff :) That and API docs.
If the a number of members is a field, you can order them by the parameters $sort_field = null, $sort_dir = null. Check the source again. If you are using php 8, you can use named parameters to make your life a bit easier :)
Level 2
@Sinnbeck I'll try. ) I'm new to Laravel, I'm ne to OOP php, I'm new to Mailchimp api... So I'm not sure where should I start reading. )))
Level 102
@AnatoliyViktorovich Well start by looking at what you are getting back. If there is a key called something like "member_count" or similar, you can probably sort by it :)
If you can show the data of just a single "row", I can probably help
Level 2
$response = $client->lists->getAllLists(); $lists = $response->lists;
As I understend I'm getting an array of list objects in $lists. when I do dd($lists); I can see +"member_count": 67 under +"stats": {#671 ▼.
Level 102
@AnatoliyViktorovich If you only have 15 then maybe the easiest is just to do
$lists = collect($response->lists)->sortBy('stats.member_count')->values();
Level 2
@Sinnbeck Yes! It works! You're a magician!!! ) I just changed to sortByDesc. Thank you!!!
So that collect is about collections, provided either by Laravel or by php8? I hardly remember reading about it somewhere. Can you advice where to read about it? It looks like I wiill need to use it alot. )
Level 102
@AnatoliyViktorovich Those are laravel collections :) Arrays on steroids you can say
1 like
Level 2
@Sinnbeck Thank you very much!
Level 102
@AnatoliyViktorovich Happy to help.
1 like
Level 2
I'm stuck again. By analogy with fetching a list of lists via mailchimp api and sorting them with collections help, I wanted to do the same with campaigns list.
Api docs tells me $response = $client->campaigns->list(); It works, But again it has $count = '10' limit in CampaignsApi.php. If with "lists" I changed it to 20 and it solved the problem (I have just 15 lists), I don't know what to do with "campaigns" as I have hundreds of them. And by default they show the oldest first and I need the latest. In theory I could raise $count to 1000. And then sort by date desc with your collection. But then I have to limit somehow to ten as I don't need to display more. Please advise.
Level 102
@AnatoliyViktorovich Please make a new thread so others can give a hand also :) This thread is marked as solved, so most people will ignore it.
But most likely you just want to get it paginated.
1 like
Please or to participate in this conversation.