Returns data from the Speakers table.

Table Specific Information

SELECT

The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:

• Id supports =,!=
• FirstName supports =,!=,like
• LastName supports =,!=,like
• Code supports =,!=,like
• Email supports =,!=,like
• Company supports =,!=,like
• Title supports =,!=,like
• Visibility supports =,!=
• Featured supports =,!=
• LastModified supports =,!=,>,<,>=,<=

All other filters are handled client-side.

The following is an example of a SELECT statement:

SELECT * FROM Speakers WHERE FirstName='cvent'

INSERT

The following is an example of an INSERT statement:

INSERT INTO Speakers (FirstName, LastName, EventId) VALUES('Bob', 'Smith', 'e12ff613-966f-4fb9-bc91-8bd32c84f130')

UPDATE

The following is an example of an UPDATE statement:

UPDATE Speakers SET FirstName='Sam', LastName='Jackson', EventId='e12ff613-966f-4fb9-bc91-8bd32c84f130' WHERE Id='fc6d8759-2331-4ac7-8868-d9aed5b638c7'

DELETE

The following is an example of a DELETE statement:

DELETE FROM Speakers WHERE Id='fc6d8759-2331-4ac7-8868-d9aed5b638c7'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Id of the Speakers table.
Order	String	False		The Order of the Speakers table.
FirstName	String	False		The FirstName of the Speakers table.
LastName	String	False		The LastName of the Speakers table.
Code	String	False		The Code of the Speakers table.
Email	String	False		The Email of the Speakers table.
Prefix	String	False		The Prefix of the Speakers table.
Designation	String	False		The Designation of the Speakers table.
Company	String	False		The Company of the Speakers table.
Title	String	False		The Title of the Speakers table.
Visibility	Boolean	False		The Visibility of the Speakers table.
Biography	String	False		The Biography of the Speakers table.
InternalNote	String	False		The InternalNote of the Speakers table.
Featured	Boolean	False		The Featured of the Speakers table.
Created	Datetime	False		The Created of the Speakers table.
CreatedBy	String	False		The CreatedBy of the Speakers table.
LastModified	Datetime	False		The LastModified of the Speakers table.
LastModifiedBy	String	False		The LastModifiedBy of the Speakers table.
ContactId	String	False		The ContactId of the Speakers table.
EventId	String	False		The EventId of the Speakers table.
CategoryId	String	False		The CategoryId of the Speakers table.
CategoryName	String	False		The CategoryName of the Speakers table.