Explore the Less Annoying CRM API data model

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

Free trial Book a demo

Pulling data from the Less Annoying 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 Less Annoying 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.

What can you do with your Less Annoying CRM data?

Connect your AI chatbots & agentic workflows

Our Universal MCP Server lets you query your Less Annoying CRM data using Claude, ChatGPT or your favourite AI tool.

Empower your BI dashboards

Our Less Annoying CRM Connector connects your Less Annoying CRM data to favourite reporting tools.

Your business runs on more than just Less Annoying CRM

We connect to over over 70+ cloud services, letting you manage the data needs of your entire business in a single location.

Endpoints

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

Calendar

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Calendars

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CalendarID string - -
UserID string User → UserID -
IsPrimary boolean - -
Visibility string - -

Contact

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Contacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string - -
DateCreated datetime - -
LastUpdate datetime - -
AssignedTo string User → UserID -
IsCompany boolean - -
CompanyID string Contact → ContactID -
NameSalutation string - -
NameFirstName string - -
NameMiddleName string - -
NameLastName string - -
NameSuffix string - -

CustomField

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Custom_Fields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CustomFieldID string - -
DateArchived datetime - -
RecordType string - -
FieldIdentifier string - -
IsDefaultField boolean - -
Type string - -
IsRequired boolean - -
IsMultiField boolean - -
CompanyAutoComplete boolean - -
SectionID string - -
FormColumn int - -
UsesInternationalFormat boolean - -
FormatNumber boolean - -
IsTitle boolean - -
ShowOnActiveBadge boolean - -
ShowOnClosedBadge boolean - -
ShowOnReport boolean - -
ShowOnCalendar boolean - -
AnnualDate boolean - -
IsSingleLink boolean - -
DefaultValue string - -
PipelineID string Pipeline → PipelineID -
LabelsStreet string - -
LabelsCity string - -
LabelsState string - -
LabelsZip string - -
LabelsCountry string - -

Event

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Events

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
EventID string - -
DateCreated datetime - -
DateUpdated datetime - -
StartDate datetime - -
EndDate datetime - -
OriginalStartDate datetime - -
OriginalEndDate datetime - -
EndRecurrenceDate datetime - -
Status string - -
Location string - -
IsAllDay boolean - -
IsRecurring boolean - -
IsException boolean - -
RecurrenceRule string - -
SeriesNumber int - -
CalendarID string Calendar → CalendarID -

Group

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Groups

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
GroupID string - -
Sharing string - -
Color string - -

Note

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Notes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID string - -
DateCreated datetime - -
ContactID string Contact → ContactID -
UserID string User → UserID -
PipelineID string Pipeline → PipelineID -
PipelineItemID string PipelineItem → PipelineItemID -
DateDisplayedInHistory datetime - -
NoteText string - -
IsRichText boolean - -

Pipeline

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Pipelines

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PipelineID string - -
DateCreated datetime - -
DateArchived datetime - -
Image string - -
Color string - -
IsHidden boolean - -
Permissions string - -

PipelineItem

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Pipeline_Items

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PipelineItemID string - -
DateCreated datetime - -
LastUpdate datetime - -
PipelineID string Pipeline → PipelineID -
StatusID string PipelineStatus → StatusID -
ContactID string Contact → ContactID -
CreatedBy string User → UserID -
LastUpdatedBy string User → UserID -
NumberOfUpdates int - -
LastNote string - -

PipelineStatus

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Pipeline_Statuses

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
StatusID string - -
DateCreated datetime - -
PipelineID string Pipeline → PipelineID -
IsActive boolean - -
Color string - -

Task

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Tasks

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
TaskID string - -
DateCreated datetime - -
DueDate datetime - -
DateCompleted datetime - -
IsCompleted boolean - -
AssignedTo string User → UserID -
ContactID string Contact → ContactID -
CalendarID string Calendar → CalendarID -

Team

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
TeamID string - -
DateCreated datetime - -

User

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Settings_Functions/Users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserID string - -
FirstName string - -
LastName string - -
Timezone string - -

ContactEmail

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
LineNumber int - -
Text string - -
Type string - -

ContactAddress

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
LineNumber int - -
Street string - -
City string - -
State string - -
Zip string - -
Country string - -
Type string - -

ContactPhone

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
LineNumber int - -
Text string - -
Type string - -

ContactWebsite

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
LineNumber int - -
Text string - -

ContactFile

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Files

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
FileID string - -
DateCreated datetime - -
DateDeleted datetime - -
FileName string - -
CreatedBy string User → UserID -
FileType string - -
DisplayName string - -
FileSize int - -
ParentID string - -
IsPrimary boolean - -
NumVersions int - -
FileUrl string - -

ContactCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
FieldName string - -
LineNumber int - -
FieldValue string - -
ValueIdentifier string CustomField → FieldIdentifier -

ContactCustomFieldLinkedContact

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
FieldName string - -
LinkedContactID string Contact → ContactID -
ValueIdentifier string CustomField → FieldIdentifier -

ContactCustomFieldLinkedFile

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Files

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
FieldName string - -
ValueIdentifier string CustomField → FieldIdentifier -
FileID string - -
DateCreated datetime - -
DateDeleted datetime - -
FileName string - -
CreatedBy string User → UserID -
FileType string - -
DisplayName string - -
FileSize int - -
ParentID string - -
IsPrimary boolean - -
NumVersions int - -
FileUrl string - -

CustomFieldOption

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID string CustomField → CustomFieldID -
OptionID string - -
Option string - -

CustomFieldMultiFieldType

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomFieldID string CustomField → CustomFieldID -
TypeID string - -
Value string - -

EventAttendee

Column Type Relates to Notes
RemoteID string - -
EventRemoteID string Event → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EventID string Event → EventID -
ContactID string Contact → ContactID -
UserID string User → UserID -
AttendanceStatus string - -

GroupTeam

Column Type Relates to Notes
RemoteID string - -
GroupRemoteID string Group → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
GroupID string Group → GroupID -
TeamID string Team → TeamID -

PipelineSharedTeam

Column Type Relates to Notes
RemoteID string - -
PipelineRemoteID string Pipeline → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PipelineID string Pipeline → PipelineID -
TeamID string Team → TeamID -

PipelineItemCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
PipelineItemRemoteID string PipelineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PipelineItemID string PipelineItem → PipelineItemID -
FieldName string - -
LineNumber int - -
FieldValue string - -
ValueIdentifier string CustomField → FieldIdentifier -

PipelineItemCustomFieldLinkedContact

Column Type Relates to Notes
RemoteID string - -
PipelineItemRemoteID string PipelineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PipelineItemID string PipelineItem → PipelineItemID -
FieldName string - -
LinkedContactID string Contact → ContactID -
ValueIdentifier string CustomField → FieldIdentifier -

PipelineItemCustomFieldLinkedFile

Documentation: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Files

Column Type Relates to Notes
RemoteID string - -
PipelineItemRemoteID string PipelineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PipelineItemID string PipelineItem → PipelineItemID -
FieldName string - -
ValueIdentifier string CustomField → FieldIdentifier -
FileID string - -
DateCreated datetime - -
DateDeleted datetime - -
FileName string - -
CreatedBy string User → UserID -
FileType string - -
DisplayName string - -
FileSize int - -
ParentID string - -
IsPrimary boolean - -
NumVersions int - -
FileUrl string - -

TeamUser

Column Type Relates to Notes
RemoteID string - -
TeamRemoteID string Team → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TeamID string Team → TeamID -
UserID string User → UserID -

More from our Less Annoying CRM Data Accessibility blog

How big data became your data
The slow horror of compounding API calls
How to query and report on data from your cloud service
The Data Accessibility Checklist

Need more?

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

Connect your own Less Annoying CRM data Querying Less Annoying CRM using regular SQL