Connections: ActiveCampaign Connections
insert update delete REST
- Catalogus:
ActiveCampaign - Schema:
V3 - Primaire sleutels:
id - Label: Connections
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
API-bron
- Eindpunt:
/connections
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 217 |
| Aantal rijen per minuut bij volledige scan | 4,340 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Connections worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
cdate |
datetime |
Created | filters on the platform, writable, computed | ||
connection |
varchar2 |
Verbindingstype | filters on the platform, writable | Type of the connection, such as ecommerce. | |
credential |
datetime |
Aanmeldgegevens Vervaldatum | filters on the platform, writable, computed | Moment the credentials of the connection expire. | |
disconnect |
datetime |
Verbreekdatum | filters on the platform, writable, computed | Moment the connection was disconnected. | |
externalid |
varchar2 |
Externe ID | filters on the platform, writable | ||
id |
int64 |
ID | filters on the platform, writable, computed | ||
is |
int64 |
Internal | filters on the platform, writable | ||
last |
datetime |
Laatste Synchronisatie | filters on the platform, writable | ||
link |
varchar2 |
Link (URL) | filters on the platform, writable | ||
listId |
int64 |
Lijst ID | filters on the platform, writable, computed | ID of the list associated with the connection. | |
logo |
varchar2 |
Logo (URL) | filters on the platform, writable | ||
name |
varchar2 |
Name | filters on the platform, writable | ||
plan |
varchar2 |
Planniveau | filters on the platform, writable, computed | Plan tier of the connected service. | |
service |
varchar2 |
Service | filters on the platform, writable | ||
service |
varchar2 |
Dienstnaam | filters on the platform, writable, computed | Name of the service as registered by ActiveCampaign. | |
status |
int64 |
Status | filters on the platform, writable | ||
sync |
int64 |
Synchronisatiestatus | filters on the platform, writable | ||
sync_ |
datetime |
Synchronisatie Aanvraagtijd | filters on the platform, writable, computed | Moment a synchronisation was requested. | |
sync_ |
datetime |
Synchronisatie Starttijd | filters on the platform, writable, computed | Moment the running synchronisation started. | |
udate |
datetime |
Laatst Bijgewerkt | filters on the platform, writable, computed |
Geciteerd door
- eComOrderProducts
connectionid(Candidate) - eComOrders
connectionid(Candidate)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:
Wijzigingen in deze tabel, 26.0 tot 27.0
+connectionType(varchar2)+credentialExpiration(datetime)+disconnectDate(datetime)+listId(int64)+planTier(varchar2)+serviceName(varchar2)+sync_request_time(datetime)+sync_start_time(datetime)