I have several backups that pull campaign information. And all of them have suddenly started retrieving only 99 campaigns. I have over 800 in my account. As recently as April 20, my AC account backup retrieved 800 campaigns. Since then, it's only been pulling in 99.
Hello Cheryl,
Our developers ask you to create a separate Export package with the Campaigns table. Please share this package Id or link with us.
They also need your permission to run the package in debug mode with extended logging.
We look forward to your reply
Best regards,
Olena
Technical Support Engineer
Hi Olena,
Here's the link: https://app.skyvia.com/#/69052/packages/166781
And they have my permission to run the package in debug mode with extended logging.
Thank you!
Hi Cheryl,
Thanks for providing the package.
Our technical team will perform further investigation.
I will revert to you with the result as soon as possible.
Best regards,
Olena
Technical Support Engineer
Hello Cheryl,
Our developers investigated the case and here is what they found:
The export package performs the request to ActiveCampaign API.
Then Active Campaign returns a response containing the campaigns collection and their total count.
But there is a bug in the ActiveCampaign API, the total count is correct, but the actual count of the returned campaigns collection is less than the total count.
This happens when the paging strategy is applied.
When the page size is set to 100, in this case, ActiveCampaign API returns fewer records and considers there are no more pages.
The team set the "PageSize" 1 as a workaround, this is the only way to get the entire result set currently.
But this table will be read for quite a long time if there is a lot of data.
This problem is common for the other ActiveCampaign users, we are currently waiting for ActiveCampaign to fix the bug.
Should you have any questions, please feel free to contact us.
