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 provider will use the SuiteCRM API to filter the results.

SELECT * FROM Spots WHERE Type = 'getMarketingSpotsData'

Insert

Create a Spot by specifying any writable column.

INSERT INTO Spots (Name, Type) VALUES ('Test Account', 'getServicesSpotsData')

Update

You can update any Spot column that is writable, by specifying the Id.

UPDATE Spots SET Description = 'Updated Spot' 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.
Assignedto	String	True	The user name of the user assigned to the record.
AssignedUser_Id	String	False	The Id of the user assigned to the record.
Config	String	False	The the configuration set of the spot.
Configuration	String	True	The GUI settings of the spot.
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Deleted	Bool	False	The record deletion indicator.
Description	String	False	Full text of the note.
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
Name	String	False	The name of the spot.
Type	String	False	The field this spot is targeting.

Pseudo-Columns

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.


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.

ADO.NET Provider for SuiteCRM