Companies

Create, update, delete, and query Highrise Companies. This table is dynamic.

Table Specific Information

For datetime columns only the '>' and '>=' operators are supported.

SELECT * FROM Companies WHERE UpdatedAt > '2012-01-12'

To insert a new Company, provide at least a Company Name and a Background for the Company.

INSERT INTO Companies (Name, Background) VALUES ('Company name', 'The description')


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Id column for the table Companies.
Name	String	False		The Name column for the table Companies.
Background	String	False		The Background column for the table Companies.
EmailAddressAggregate	String	False		The EmailAddressAggregate column for the table Companies.
PhoneNumberAggregate	String	False		The PhoneNumberAggregate column for the table Companies.
AddressAggregate	String	False		The AddressAggregate column for the table Companies.
InstantMessengerAggregate	String	False		The InstantMessengerAggregate column for the table Companies.
TwitterAccountAggregate	String	False		The TwitterAccountAggregate column for the table Companies.
WebAddressAggregate	String	False		The WebAddressAggregate column for the table Companies.
AvatarURL	String	False		The AvatarURL column for the table Companies.
VisibleTo	String	False		The VisibleTo column for the table Companies.
OwnerId	String	False		The OwnerId column for the table Companies.
GroupId	String	False		The GroupId column for the table Companies.
AuthorId	String	True		The AuthorId column for the table Companies.
CreatedAt	String	True		The CreatedAt column for the table Companies.
UpdatedAt	String	True		The UpdatedAt column for the table Companies.
PartyCustomField1	String	False		A CustomField of type party.
PartyCustomField2	String	False		A CustomField of type party.
SubjectData	String	False		A Subject Dat for the table Companies.