Explore the Spotler CRM API data model

See how the various Spotler CRM endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

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 CRM 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.

Endpoints

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 - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Spotler data Querying Spotler using regular SQL