Mailjet获取Campaign仅返回10条数据，与统计数不符求助

问题情况 #

调用$mj->get(Resources::$Campaign);仅返回10条记录，但实际账号下已创建14个Campaign（调用$mj->get(Resources::$Campaignstatistics);返回的CampaignCount为14），新增Campaign后返回结果仍只有10条。

排查与解决方法 #

• 默认分页限制：Mailjet的Campaign列表接口默认每页返回10条数据，这是接口的默认分页配置，你看到的10条只是第一页内容，并非全部数据。
• 手动指定分页参数：通过添加Limit（每页数量）和Offset（偏移量）参数，分页获取所有Campaign。示例代码：

// 获取全部14条数据，一次性设置足够大的Limit（最大支持1000）
$allCampaigns = $mj->get(Resources::$Campaign, ['Limit' => 14]);

// 或者分页获取
$page1 = $mj->get(Resources::$Campaign, ['Limit' => 10, 'Offset' => 0]);
$page2 = $mj->get(Resources::$Campaign, ['Limit' => 10, 'Offset' => 10]);

• 状态过滤导致的数量差异：Campaignstatistics的CampaignCount包含账号下所有状态的Campaign（比如草稿、已发送、已删除等），而Campaign列表接口默认可能只返回特定状态（如已发送）的Campaign。如果要获取所有状态的Campaign，添加状态过滤参数：

$allStatusCampaigns = $mj->get(Resources::$Campaign, ['Status' => '*']);

相关返回数据 #

Campaign接口返回结果 #

array:10 [▼
  0 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T00:16:17Z"
    "CustomValue" => "mj.nl=10869002"
    "FirstMessageID" => 99642142916612309
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658184996
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10869002
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T00:16:18Z"
    "SendStartAt" => "2024-06-27T00:16:17Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  1 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T00:55:54Z"
    "CustomValue" => "mj.nl=10868672"
    "FirstMessageID" => 103864267611641594
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185006
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868672
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T00:55:54Z"
    "SendStartAt" => "2024-06-27T00:55:54Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  2 => array:22 [▶]
  3 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T01:02:09Z"
    "CustomValue" => "mj.nl=10868679"
    "FirstMessageID" => 94857068329212717
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185012
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868679
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T01:02:10Z"
    "SendStartAt" => "2024-06-27T01:02:09Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  4 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T01:03:48Z"
    "CustomValue" => "mj.nl=10868675"
    "FirstMessageID" => 104427217524379737
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185014
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868675
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T01:03:48Z"
    "SendStartAt" => "2024-06-27T01:03:48Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  5 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T01:16:32Z"
    "CustomValue" => "mj.nl=10868842"
    "FirstMessageID" => 100768042879416552
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185020
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868842
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T01:16:32Z"
    "SendStartAt" => "2024-06-27T01:16:32Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  6 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T01:31:55Z"
    "CustomValue" => "mj.nl=10868680"
    "FirstMessageID" => 98516243014696096
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185026
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868680
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T01:31:56Z"
    "SendStartAt" => "2024-06-27T01:31:55Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  7 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T02:15:28Z"
    "CustomValue" => "mj.nl=10868706"
    "FirstMessageID" => 102175417750407536
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185036
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868706
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T02:15:29Z"
    "SendStartAt" => "2024-06-27T02:15:28Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  8 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T02:27:34Z"
    "CustomValue" => "mj.nl=10868721"
    "FirstMessageID" => 99079192973947619
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185038
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868721
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T02:27:34Z"
    "SendStartAt" => "2024-06-27T02:27:34Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
  9 => array:22 [▼
    "CampaignType" => 2
    "ClickTracked" => 0
    "CreatedAt" => "2024-06-27T02:58:21Z"
    "CustomValue" => "mj.nl=10868825"
    "FirstMessageID" => 56013521536099887
    "FromEmail" => "hauchung162@gmail.com"
    "FromID" => 6453917149
    "FromName" => ""
    "HasHtmlCount" => 1
    "HasTxtCount" => 1
    "ID" => 7658185050
    "IsDeleted" => false
    "IsStarred" => false
    "ListID" => 10463354
    "NewsLetterID" => 10868825
    "OpenTracked" => 1
    "SendEndAt" => "2024-06-27T02:58:21Z"
    "SendStartAt" => "2024-06-27T02:58:21Z"
    "SpamassScore" => 0
    "Status" => 0
    "Subject" => "Test mail"
    "UnsubscribeTrackedCount" => 0
  ]
]

Campaignstatistics接口返回结果 #

0 => array:20 [▼
    "AverageClickDelay" => 0
    "AverageClickedCount" => 0
    "AverageOpenDelay" => 0
    "AverageOpenedCount" => 0
    "BlockedCount" => 0
    "BouncedCount" => 0
    "CampaignCount" => 14
    "ClickedCount" => 0
    "DeferredCount" => 2
    "DeliveredCount" => 51
    "HardBouncedCount" => 0
    "OpenedCount" => 20
    "ProcessedCount" => 53
    "QueuedCount" => 0
    "SoftBouncedCount" => 0
    "SpamComplaintCount" => 0
    "TotalClicksCount" => 0
    "TotalOpensCount" => 0
    "TransactionalCount" => 0
    "UnsubscribedCount" => 0
  ]
]

内容的提问来源于stack exchange，提问作者Accounts English