ActivitiesByContactId: ActiveCampaign Activities by Contact ID
read only REST
- Catalog:
ActiveCampaign - Schema:
V3 - Primary Keys:
id - Label: Activities by Contact ID
Can only retrieve data.
API Source
- Endpoint:
/activities?contact={id}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 264 |
| Full scan rows per minute | 5,890 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | ID of the record. |
Table Columns
The columns of the table ActivitiesByContactId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
id |
int64 |
ID | filters on the platform, writable, computed | Unique ID. | |
json |
varchar2 |
JSON Data | filters on the platform, writable | Further particulars of the activity, as answered by ActiveCampaign. | |
permission |
varchar2 |
Permission | filters on the platform, writable | Permission needed to see the activity. | |
reference |
varchar2 |
Reference Model Name | filters on the platform, writable | Name of the kind of record the activity refers to. | |
reference_ |
varchar2 |
Reference Action | filters on the platform, writable | What happened to the record the activity refers to. | |
reference_ |
int64 |
Reference ID | filters on the platform, writable | ID of the record the activity refers to. | |
reference_ |
varchar2 |
Reference Type | filters on the platform, writable | Kind of record the activity refers to, such as Note. | |
subscriberid |
int64 |
Subscriber ID | filters on the platform, writable | ID of the contact the activity belongs to. | |
tstamp |
datetime |
Tstamp | filters on the platform, writable | Moment the activity took place. | |
user |
int64 |
User | filters on the platform, writable | ID of the user that caused the activity. | |
userid |
int64 |
User ID | filters on the platform, writable | ID of the user that caused the activity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Table function ActiveCampaign.V3.ActivitiesByContactId is added
The table function has 11 columns and can select.
- importance 3