JDBC Driver for Marketo

Build 22.0.8462

NamedAccounts

Query Named Accounts for a Marketo organization.

Table Specific Information

Select

A filter must be specified when retrieving named accounts. Valid filters are any searchable columns which include MarketoGUID, Name, Industry, State, City, etc.

SELECT * FROM NamedAccounts WHERE Name='MyAccount'

Insert

To create a new NamedAccount record, specify the information about the named account to be entered into the database.

The following example demonstrates how to insert a new NamedAccount:

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

Update

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

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

Delete

Delete is used to remove named accounts from Marketo. To perform a delete, either the MarketoGUID field or the Name field is required.

DELETE FROM NamedAccounts WHERE Name=='MyAccount'

Columns

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462