Hello! this may be a tricky question to fully describe, but here goes: I'm looking to use the API with Python to essentially see which email campaigns were sent to which contacts and when. We have ~26,000 contacts. I was able to get all the contacts using the cursor (pagination), but the only way I've found to connect contact_id ("https://api.cc.email/v3/contacts/") to campaign_id ("https://api.cc.email/v3/emails/") is via campaign_activity_id (using "https://api.cc.email/v3/reports/contact_reports/"). So, unfortunately, I obviously hit the API limits not even halfway through (since the contact_reports is by individual contact), it also takes an extremely long time to make the actual request and takes over an hour to even get to the API limit (10,000 requests). Is there something that I am missing and there's a much more straightforward way to map relationships between contact:campaign_activity_id:campaign_id? We're looking to produce visualizations in our BI solution but so far, it seems that there is no direct reference/mapping table that would contain these relationships.
... View more
