I am using Windsor to pull data from Active Campain data into Power BI. There are endpoints for Contacts data and Automations data; however, there is no endpoint for the necessary bridge table that links these two sets of data.
The automation_contact_list endpoint (see Active Campaign Developer Documentation in the link below) brings together the contact_id and automation_id so it can be used as a bridge between the Contacts and Automations data tables.
https://www.activecampaign.com/api/example.php?call=automation_contact_list
Without this bridge endpoint, there is no way to connect Contacts data to Automations data which silos the data and limits the ability to report on it.
For example in Power BI, I am trying to answer the questions - “How many contacts came from each automation we have put in place?” or “Was is the success rate of converting contacts to retained clients for each automation?” - and I am currently unable to do so.