Explore the Spotler CRM API data model

Pulling data from the Spotler CRM 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 Spotler 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.

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

Account

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Leadscore	int	-	-
Addressline	string	-	-
Addresscity	string	-	-
Addresscountry	string	-	-
AddressCountryAndState	string	-	-
AddressPostCodeAndZip	string	-	-
Ownerid	long	User → ID	-
Slaid	long	SLA → ID	-
Source	string	-	-
Notes	string	-	-
Phone	string	-	-
Website	string	-	-
Type	string	-	-
Sector	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

Activity

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Description	string	-	-
Accountid	long	Account → ID	-
Caseid	long	Case → ID	-
Contactid	long	Contact → ID	-
Date	datetime	-	-
Type	string	-	-
Priority	decimal	-	-
Status	string	-	-
Allday	boolean	-	-
Emailsubject	string	-	-
Emailfrom	string	-	-
Emailto	string	-	-
Emailcc	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

Campaign

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Ownerid	long	User → ID	-
Active	boolean	-	-
Startdate	datetime	-	-
Enddate	datetime	-	-
Type	string	-	-
Status	string	-	-
Budget	decimal	-	-
Actual	decimal	-	-
Notes	string	-	-
Dripfeed	boolean	-	-
Responserate	string	-	-
Costperlead	decimal	-	-
Costperopportunity	decimal	-	-
Costpersale	decimal	-	-
Pipeline	long	-	-
Members	int	-	-
Opportunities	int	-	-
Sales	int	-	-
Revenue	decimal	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

Case

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Accountid	long	Account → ID	-
Ownerid	long	User → ID	-
Caselevelid	long	-	-
Opened	datetime	-	-
Type	string	-	-
Customerdescription	string	-	-
Priority	decimal	-	-
Status	string	-	-
Subject	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

Contact

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Salutation	string	-	-
Accountid	long	Account → ID	-
First	string	-	-
Middle	string	-	-
Last	string	-	-
Email	string	-	-
Decisionmaker	boolean	-	-
Hold	boolean	-	-
Addressline	string	-	-
Addresscity	string	-	-
Addresscountry	string	-	-
Notes	string	-	-
Jobtitle	string	-	-
Manager	string	-	-
Department	string	-	-
Assistant	string	-	-
Phone	string	-	-
Home	string	-	-
Mobile	string	-	-
Other	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

List

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Type	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

ListMember

Column	Type	Relates to	Notes
RemoteID	string	-	-
ListRemoteID	string	List → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Listid	long	List → ID	-
Contactid	long	Contact → ID	-
Consentdate	datetime	-	-
Unitprice	decimal	-	-
Consentipaddress	string	-	-
Consentdescription	string	-	-

Opportunity

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Description	string	-	-
Accountid	long	Account → ID	-
Closedate	datetime	-	-
Status	string	-	-
Forecast	string	-	-
Probability	decimal	-	-
Source	string	-	-
Nextstep	string	-	-
Competitor	string	-	-
Repeat	string	-	-
Lossreason	string	-	-
Winlossreport	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

OpportunityLine

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
OpportunityRemoteID	string	Opportunity → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
UnitCost	decimal	-	-
Quantity	decimal	-	-
Unitprice	decimal	-	-
Opportunityid	long	Opportunity → ID	-
Product	string	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

SLA

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Name	string	-	-
Notes	string	-	-
Active	boolean	-	-
Ownerid	long	User → ID	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

Task

Documentation: https://support.reallysimplesystems.com/api-v4/

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
Description	string	-	-
Accountid	long	Account → ID	-
Caseid	long	Case → ID	-
Contactid	long	Contact → ID	-
Taskownerid	long	User → ID	-
Date	datetime	-	-
Type	string	-	-
Priority	decimal	-	-
Status	string	-	-
Allday	boolean	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-

User

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	long	-	-
First	string	-	-
Salutation	string	-	-
Middle	string	-	-
Last	string	-	-
Initials	string	-	-
Email	string	-	-
Usergroup	string	-	-
Userprofile	string	-	-
Phone	string	-	-
Mobile	string	-	-
Jobtitle	string	-	-
Department	string	-	-
Manager	string	-	-
Live	boolean	-	-
Admin	boolean	-	-
Reportownaccess	boolean	-	-
Reportgroupaccess	boolean	-	-
Reportglobalaccess	boolean	-	-
Remembersettings	boolean	-	-
Calendartype	long	-	-
Calendardomain	string	-	-
Ipaddress	string	-	-
Lastlogin	datetime	-	-
Createdby	long	User → ID	-
Modifiedby	long	User → ID	-
Createddate	datetime	-	-
Modifieddate	datetime	-	-