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. |
| 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. |