Pulling data from the Constant Contact API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.
At SyncHub, we not only sync your Constant Contact API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
CampaignActivityID | guid | - | - |
CampaignID | guid | EmailCampaign → CampaignID | - |
Role | string | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
ContactRemoteID | string | Contact → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ContactID | guid | Contact → ContactID | - |
ContactListID | guid | ContactList → ListID | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
ContactRemoteID | string | Contact → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ContactID | guid | Contact → ContactID | - |
CustomFieldID | guid | - | - |
Value | string | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
BounceCode | string | - | - |
CurrentEmailAddress | string | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
DeviceType | string | - | - |
UrlID | string | - | - |
LinkUrl | string | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
OptOutReason | string | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
CampaignActivityRemoteID | string | CampaignActivity → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
DeviceType | string | - | - |
CampaignActivityID | guid | CampaignActivity → CampaignActivityID | - |
TrackingActivityType | string | - | - |
ContactID | guid | Contact → ContactID | - |
EmailAddress | string | - | - |
FirstName | string | - | - |
LastName | string | - | - |
CreatedTime | datetime | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
ContactRemoteID | string | Contact → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ContactID | guid | Contact → ContactID | - |
PhoneNumberID | guid | - | - |
PhoneNumber | string | - | - |
Kind | string | - | - |
CreatedAt | datetime | - | - |
UpdatedAt | datetime | - | - |
UpdateSource | string | - | - |
CreateSource | string | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
ContactRemoteID | string | Contact → RemoteID | - |
WhenUpsertedIntoDataStore | datetime | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ContactID | guid | Contact → ContactID | - |
StreetAddressID | guid | - | - |
Kind | string | - | - |
Street | string | - | - |
City | string | - | - |
State | string | - | - |
PostalCode | string | - | - |
Country | string | - | - |
CreatedAt | datetime | - | - |
UpdatedAt | datetime | - | - |
SyncHub lives and breathes APIs and data. Keep exploring using the links below.