SalesPersons

Query Sales Persons for a Marketo organization.

Table Specific Information

Note: This table is only available for Marketo subscriptions which do not have a native CRM sync enabled. If sync is enabled, an error will be returned when attempting to query the table stating that the API is disabled.

Select

A filter must be specified when retrieving companies. Valid filters are any searchable columns which include Id, ExternalSalesPersonId, or Email.

SELECT * FROM SalesPersons WHERE ExternalSalesPersonId='sales@cdata.com'

Insert

To create a new SalesPerson record, specify the information about the sales person to be entered into the database.

The following example demonstrates how to insert a new Opportunity:

INSERT INTO SalesPersons (ExternalSalesPersonId, Email, FirstName, LastName) VALUES ('sales@cdata.com', 'sales@cdata.com', 'Sales', 'Person')

Update

Any field that is not read-only can be updated.

UPDATE SalesPersons SET Phone='919-928-5214', Title='Technical Sales', Email='sales@cdata.com' WHERE ExternalSalesPersonId='sales@cdata.com'

Delete

Delete is used to remove a sales person from Marketo. To perform a delete, either the Id field or the ExternalSalesPersonId field is required.

DELETE FROM SalesPersons WHERE ExternalSalesPersonId=='sales@cdata.com'

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	The unique, Marketo-assigned identifier of the sales person.
ExternalSalesPersonId	String	False	True	The external Id of the sales person.
Email	String	False	True	The email address of the sales person.
Fax	String	False		The fax number of the sales person.
FirstName	String	False		The first name of the sales person.
LastName	String	False		The last name of the sales person.
MobilePhone	String	False		The mobile phone number of the sales person.
Phone	String	False		The phone number of the sales person.
Title	String	False		The sales person's title.
CreatedAt	Datetime	True		The date and time the sales person was created.
UpdatedAt	Datetime	True		The date and time the sales person was last updated.