'sends' entity in API?

Ask a question
,
1

I’m working with an extract of Active Campaign data (Fivetran) where the resulting tables loosely mirror the AC docs at developers.activecampaign/reference

I’m seeking send level data at the contact_id level. I cannot see an entity that looks like ‘sends’.

How would one retreive from the API data with: contact_id | automation name | campaign name | send_time`?

2

Hi Gavin!

ActiveCampaign doesn’t have a sends table - here’s how to get what you need:

  1. Pull from /api/3/messages - gets your sends with contact ID and timestamps
  2. Then grab campaign details from /api/3/campaigns/{id} to get campaign names: Retrieve a campaign
  3. If it’s an automation email, the campaign will have an automation ID - use that to get the automation name from /api/3/automations/{id} : https://developers.activecampaign.com/reference/retrieve-an-automation

Automation emails are actually sent as campaigns under the hood, which is why they all show up in the messages endpoint. There’s no separate “automation sends” - it’s all in messages/campaigns.

Hope this helps!

1 Like
3

This is great, thanks a lot!