Query Sales Persons in Marketo.

Note: This table is only available for Marketo subscriptions which do not have a native CRM sync enabled.

Select

Note: A server-side filter must be specified to query this table. Queries with the 'OR' operator are not supported.

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

Tip: This table uses server-side projection. Performance can be improved by minimizing the number of columns in projection.

	SELECT * FROM SalesPersons WHERE ExternalSalesPersonId='test SalesPerson'
	SELECT * FROM SalesPersons WHERE Id=2520998
	SELECT * FROM SalesPersons WHERE Email='[email protected]'
	SELECT * FROM SalesPersons WHERE Email IN ('[email protected]', '[email protected]')

Insert

This table supports BATCH INSERT when UseBulkAPI is set to false.

	INSERT INTO SalesPersons (ExternalSalesPersonId, Email, FirstName, LastName) VALUES ('testInsertSalesPersons001', '[email protected]', 'Sales', 'Person')

Update

This table supports BATCH UPDATE when UseBulkAPI is set to false.

	UPDATE SalesPersons SET Phone='800-123-4567', Title='Technical Sales', Email='[email protected]' WHERE ExternalSalesPersonId='testInsertSalesPersons001'

Upsert

This table supports BATCH UPSERT when UseBulkAPI is set to false.

	UPSERT INTO SalesPersons (ExternalSalesPersonId, Email, FirstName, LastName) VALUES ('testInsertSalesPersons123', '[email protected]', 'Sales', 'Person')

Delete

This table supports BATCH DELETE when UseBulkAPI is set to false.

	DELETE FROM SalesPersons WHERE ExternalSalesPersonId='[email protected]'
	DELETE FROM SalesPersons WHERE ID='2521702'
	DELETE FROM SalesPersons WHERE ID IN (2521703, 2521704)
	DELETE FROM SalesPersons WHERE Email='[email protected]'
	DELETE FROM SalesPersons WHERE Email IN ('[email protected]', '[email protected]')

Columns