DealWithContacts: ActiveCampaign Deal Contacts
read only REST
- Catalogus:
ActiveCampaign - Schema:
V3 - Primaire sleutels:
id - Label: Deal Contacts
Kan alleen gegevens ophalen.
API-bron
- Eindpunt:
/deals?include=contact
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 264 |
| Aantal rijen per minuut bij volledige scan | 13,400 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel DealWithContacts 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 |
|---|---|---|---|---|---|
adate |
datetime |
itgen_acn_adate | filters on the platform, writable | ||
anonymized |
int64 |
Anonymized | filters on the platform, writable | ||
bounced_ |
datetime |
Datum Afgewezen | filters on the platform, writable | ||
bounced_ |
int64 |
Hard Afgewezen | filters on the platform, writable | ||
bounced_ |
int64 |
Zacht Afgewezen | filters on the platform, writable | ||
cdate |
datetime |
Created | filters on the platform, writable, computed | ||
created_ |
varchar2 |
Gemaakt door | filters on the platform, writable, computed | ||
created_ |
datetime |
Created | filters on the platform, writable, computed | ||
created_ |
datetime |
Aangemaakte UTC-tijdstempel | filters on the platform, writable, computed | ||
deleted |
int64 |
Deleted | filters on the platform, writable | ||
deleted_ |
datetime |
Verwijderd op | filters on the platform, writable | ||
edate |
datetime |
itgen_acn_edate | filters on the platform, writable | ||
email |
varchar2 |
E-mailadres | filters on the platform, writable | ||
email_ |
varchar2 |
E-maildomein | filters on the platform, writable | ||
email_ |
char |
E-mail Leeg | filters on the platform, writable | ||
email_ |
varchar2 |
E-mail Lokaal | filters on the platform, writable | ||
first |
varchar2 |
Voornaam | filters on the platform, writable | ||
gravatar |
int64 |
Gravatar | filters on the platform, writable | ||
hash |
varchar2 |
Hash | filters on the platform, writable | ||
id |
int64 |
ID | filters on the platform, writable, computed | Unique ID. | |
ip |
int64 |
IP-adres | filters on the platform, writable | ||
last |
varchar2 |
Achternaam | filters on the platform, writable | ||
orgid |
int64 |
Organisatie ID | filters on the platform, writable | ||
orgname |
varchar2 |
Organisatienaam | filters on the platform, writable | ||
phone |
varchar2 |
Phone | filters on the platform, writable | ||
rating_ |
datetime |
Beoordelingsdatum | filters on the platform, writable | ||
segmentio_ |
int64 |
Segment ID | filters on the platform, writable | ||
sentcnt |
int64 |
Verzonden Aantal | filters on the platform, writable | ||
sentiment |
varchar2 |
Sentiment | filters on the platform, writable | ||
socialdata_ |
datetime |
Sociale Data Laatste Controle | filters on the platform, writable | ||
ua |
varchar2 |
Browser Specificatie | filters on the platform, writable | ||
udate |
datetime |
Laatst Bijgewerkt | filters on the platform, writable, computed | ||
updated_ |
varchar2 |
Bijgewerkt door | filters on the platform, writable, computed | ||
updated_ |
datetime |
Updated | filters on the platform, writable, computed | ||
updated_ |
datetime |
Bijgewerkte UTC-tijdstempel | filters on the platform, writable, computed |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: