Create, update, delete, and query accounts created in SuiteCRM
Table Specific Information
You can query the Accounts table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM Accounts WHERE Name LIKE '%test%' AND [Date Created]>'2017-10-09'
Create a SuiteCRM Account by specifying any writable column.
INSERT INTO Accounts(Name,[Email Address],Industry) VALUES('Test Account','firstname.lastname@example.org','Energy')
You can update any Account column that is writable, by specifying the Id.
UPDATE Accounts SET Description='Updated' , Employees='20-50' where id='Test123'
Remove an Account by specifying the Account's Id.
DELETE FROM Accounts WHERE Id='account21'
Address from Google Maps of the account address.
An alternate phone number.
Annual revenue for this account.
The email address for the account.
The Id of the user assigned to the record.
The user name of the user assigned to the record.
The city used for the billing address.
The country used for the billing address.
The postal code used for the billing address.
The state used for the billing address.
The second line of the billing address.
The third line of the billing address.
The fourth line of the billing address.
The street address used for the billing address.
The campaign that generated the account.
The first campaign name for the account.
The Id of the user who created the record.
The name of the user who created the record.
The date the record was created.
The date the record was last modified.
The record deletion indicator.
The full text of the alert.
The alternate email address for the account.
Whether the account has opted out of emails.
Number of employees. Can be a number (100) or range (50-100)
The fax phone number of this account.
Geocode from Google Maps of the account address.
The industry that the account belongs in.
Whether the email address of the account has been marked as invalid.
Latitude from Google Maps of the account address.
Longitude from Google Maps of the account address.
The name of the parent of this account.
The Id of the user who last modified the record.
The name of the user who last modified the record.
The name of the account.
The nonprimary email addresses of the account.
The office phone number.
The ownership of the account.
The Id of the parent of this account.
An arbitrary rating for this account for use in comparisons with others.
The city used for the shipping address.
The country used for the shipping address.
The ZIP code used for the shipping address.
The state used for the shipping address.
The second line of the shipping address.
The third line of the shipping address.
The fourth line of the shipping address.
The street address used for for shipping purposes.
SIC code of the account.
The stock trading (ticker) symbol for the account.
The type of the account.
The URL of the website for the account.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Identifier for the next page of results. Do not set this value manually.