Spots
Create, update, delete, and query the saved spots.
Table Specific Information
Select
You can query the Spots table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM Spots WHERE Name = 'test'
Insert
Create a Spot by specifying any writable column.
INSERT INTO Spots (Id, Name) VALUES ('id', 'Energy')
Update
You can update any Spot column that is writable, by specifying the Id.
UPDATE Spots SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'
Delete
Remove a Spot by specifying the Id.
DELETE FROM Spots WHERE Id = 10003
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifier of the record. |
| Name | String | False |
The name of the spot. |
| DateEntered | Datetime | False |
The date the record was created. |
| DateModified | Datetime | False |
The date the record was last modified. |
| ModifiedUserId | String | False |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| CreatedBy | String | False |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| Description | String | False |
Full text of the note. |
| Deleted | Bool | False |
The record deletion indicator. |
| CreatedByLink | String | True |
Link to the record who created it |
| ModifiedUserLink | String | True |
Link to the record who modified it. |
| AssignedUserId | String | False |
The Id of the user assigned to the record. |
| AssignedUserName | String | True |
|
| AssignedUserLink | String | True |
Link to the user which the record has been assigned to |
| SecurityGroups | String | True |
The security group associated with the record. |
| Config | String | False |
The the configuration set of the spot. |
| Type | String | False |
The field this spot is targeting. |
| ConfigurationGUI | String | False |
|