NamedAccounts

Query Named Accounts for a Marketo organization.

テーブル固有の情報

名前付きアカウントを取得するには、フィルターを指定する必要があります。Valid filters are any searchable columns which include MarketoGUID, Name, Industry, State, City, etc.

SELECT * FROM NamedAccounts WHERE Name = 'MyAccount'

新しいNamedAccount レコードを作成するには、名前付きアカウントに関するデータベースに入力する情報を指定します。

次の例では、新しいNamedAccount を挿入する方法を説明します。

INSERT INTO NamedAccounts (Name, City, Country, Industry) VALUES ('MyAccount', 'MyCity', 'USA', 'Tech')

読み取り専用以外のフィールドは、すべて更新可能です。

UPDATE NamedAccounts SET NumberOfEmployees = 100, State = 'NC', AnnualRevenue = '10000000.00' WHERE Name = 'MyAccount'

Marketo から名前付きアカウントを削除するために使用します。削除を実行するには、MarketoGUID フィールドかName フィールドのどちらかが必須です。

DELETE FROM NamedAccounts WHERE Name = 'MyAccount'


Name	Type	ReadOnly	Filterable	Description
MarketoGUID [KEY]	String	True	True	The unique, Marketo-assigned identifier of the named account.
Name	String	False	True	The name of the account.
AccountOwnerId	Integer	False	True	The owner id of the account.
AnnualRevenue	Double	False	True	The annual revenue for the account.
City	String	False	True	The city for the account.
Country	String	False	True	The country for the account.
DomainName	String	False	True	The name of the domain for the account.
Industry	String	False	True	The industry for the account.
LogoURL	String	False	True	The URL to the logo for the account.
MembershipCount	Integer	True	True	The number of members for the account.
NumberOfEmployees	Integer	False	True	The number of employees for the account.
OpptyAmount	Double	True	True	The total amount of opportunities for the account.
OpptyCount	Integer	True	True	The total number of opportunities for the account.
SICCode	String	False	True	The SIC Code for the account.
State	String	False	True	The state for the account.
CreatedAt	Datetime	True		The date and time the named account was created.
UpdatedAt	Datetime	True		The date and time the named account was last updated.