NamedAccounts

Query Named Accounts for a Marketo organization.

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 NamedAccounts WHERE Name='MyNamedAccount1'

Insert

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

	INSERT INTO NamedAccounts (Name, City, Country, DomainName, Industry) VALUES ('testNamedAccountInsert002', 'Chapel Hill', 'USA', 'MyDomain', 'Tech')

Update

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

	UPDATE NamedAccounts SET NumberOfEmployees=100, State='NC', AnnualRevenue='10000000.00' WHERE Name='testNamedAccountInsert002'
	UPDATE NamedAccounts SET NumberOfEmployees=999 WHERE MarketoGUID='197d0ecd-4264-4826-a44a-58a6df1f9ae5'

Upsert

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

	UPSERT INTO NamedAccounts (Name, City, Country, DomainName, Industry) VALUES ('testUpsert', 'Chapel Hill', 'USA', 'MyDomain', 'Tech')

Delete

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

	DELETE FROM NamedAccounts WHERE Name IN ('MyAccount2', 'MyAccount')
	DELETE FROM NamedAccounts WHERE marketoGUID IN ('04da404b-c4e9-40c8-867f-d9fae0062343', 'fd422222-a37f-4c2b-86df-3ed4c22e9c79')

Columns


Name	Type	ReadOnly	Operators	Description
MarketoGUID [KEY]	String	True	=,IN
Id	Int	True	=,IN
ApproximateNumOfPeople	Int	True	=,IN
ParentAccountId	Int	True	=,IN
AccountOwnerId	Int	False	=,IN
AccountPhoneNumber	String	False	=,IN
AddressPostalCode	String	False	=,IN
AddressRegion	String	False	=,IN
AnnualRevenue	Decimal	False	=,IN
City	String	False	=,IN
Country	String	False	=,IN
CreatedAt	Datetime	True
CrmGuid	String	False	=,IN
CrmOrgId	Int	False	=,IN
DomainName	String	False	=,IN
ExternalSourceId	String	False	=,IN
ExternalSourceInstanceId	String	False	=,IN
ExternalSourceKey	String	False	=,IN
ExternalSourceType	String	False	=,IN
Industry	String	False	=,IN
LogoUrl	String	False	=,IN
MembershipCount	Int	True	=,IN
Name	String	False	=,IN
NumberOfEmployees	Int	False	=,IN
OpptyAmount	Decimal	True	=,IN
OpptyCount	Int	True	=,IN
SicCode	String	False	=,IN
SourceType	String	False	=,IN
State	String	False	=,IN
Street1	String	False	=,IN
UpdatedAt	Datetime	True