Query Companies 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 Companies WHERE [Id]=10
	SELECT * FROM Companies WHERE [Id] IN (10, 11, 22)
	SELECT * FROM Companies WHERE [ExternalCompanyId]='CData'
	SELECT * FROM Companies WHERE [ExternalCompanyId] IN ('CData', 'Marketo')
	SELECT * FROM Companies WHERE [Company]='CData'
	SELECT * FROM Companies WHERE [Company] IN ('CData', 'Marketo')
	SELECT * FROM Companies WHERE [ExternalSalesPersonId]='CDataSales'
	SELECT * FROM Companies WHERE [ExternalSalesPersonId] IN ('CDataSales', 'MarketoSales')

Insert

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

	INSERT INTO Companies (ExternalCompanyId, Company, Industry, Website) VALUES ('cdata', 'CData', 'Tech', 'cdata.com'), ('marketo', 'Marketo', 'Tech', 'marketo.com')

Update

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

	UPDATE Companies SET Company='test_UPDATE_Companies', MainPhone='800-555-1234', AnnualRevenue='10000000.00' WHERE ExternalCompanyId='cdata'
	UPDATE Companies SET Company='CData', MainPhone='800-555-1234', AnnualRevenue='10000000.00' WHERE WHERE Id IN (2523781, 2523782, 2523783, 2523784)

Upsert

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

	UPSERT INTO Companies (ExternalCompanyId, Company, Industry, Website) VALUES ('testUpsert', 'Google', 'Tech', 'google.com')

Delete

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

	DELETE FROM Companies WHERE externalCompanyId='cdata'
	DELETE FROM Companies WHERE Id IN (2521059, 2521060, 123, 2521058)
	DELETE FROM Companies WHERE Company='testName'

Columns