SSIS Components for Google Ad Manager

Build 24.0.9060

Contacts

Create, update, and query DoubleClick for Publishers Contacts.

Select

The following queries are processed server side.

Retrieve a list of Contacts. For example:

SELECT * FROM [Contacts]

Additionally, you can specify the Id or filter by any other column.

SELECT * FROM [Contacts] WHERE Id = '4940864'

Insert

To create a new Contact, the Name and CompanyId fields are required.

INSERT INTO [Contacts] (Name, CompanyId) VALUES ('Cont', '4415064655')

Update

You can update any field not marked as read-only by specifying the Id column.

UPDATE [Contacts] SET Name = 'New Contact', Email = '[email protected]' WHERE Id = '4944377'

Delete

The DELETE operation is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Long True

The unique ID of the Contact. This value is readonly and is assigned by Google.

Name String False

The name of the contact. This attribute is required and has a maximum length of 127 characters.

CompanyId Long False

The ID of the Company that this contact is associated with. This attribute is required and immutable.

Status String True

The status of the contact. This attribute is readonly and is assigned by Google.

The allowed values are UNINVITED, INVITE_PENDNG, INVITE_EXPIRED, INVITE_CANCELED, USER_ACTIVE, USER_DISABLED, UNKNOWN.

Address String False

The address of the contact. This attribute is optional and has a maximum length of 1024 characters.

CellPhone String False

The cell phone number where the contact can be reached. This attribute is optional.

Comment String False

A free-form text comment for the contact. This attribute is optional and has a maximum length of 1024 characters.

Email String False

The e-mail address where the contact can be reached. This attribute is optional.

FaxPhone String False

The fax number where the contact can be reached. This attribute is optional.

Title String False

The job title of the contact. This attribute is optional and has a maximum length of 1024 characters.

WorkPhone String False

The work phone number where the contact can be reached. This attribute is optional.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060