JDBC Driver for Google Ad Manager

Build 22.0.8462

CustomFields

Create, update, and query DoubleClick for Publishers Custom Fields.

Select

The following queries are processed server side by the Google Ad Manager APIs. The driver processes other SELECT queries client-side in memory .

Retrieve a list of CustomFields. For example:

SELECT * FROM [CustomFields]

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

SELECT * FROM [CustomFields] WHERE Id = '1238676'

Insert

To create a new CustomField, the Name, EntityType, DataType, and Visibility fields are required.

INSERT INTO [CustomFields] (Name, EntityType, DataType, Visibility) VALUES ('ASEF', 'LINE_ITEM', 'STRING', 'FULL')

Update

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

UPDATE [CustomFields] SET Description = 'New Description' WHERE Id = '1238676'

Delete

The delete operation is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Unique ID of the CustomField. This value is readonly and is assigned by Google.

Name String False

Name of the CustomField. This is value is required to create a custom field. The max length is 127 characters.

Description String False

A description of the custom field. This value is optional. The maximum length is 511 characters

IsActive Boolean True

Specifies whether or not the custom fields is active. This attribute is read-only.

EntityType String False

The type of entity that this custom field is associated with. This attribute is read-only if there exists a CustomFieldValue for this field.

The allowed values are LINE_ITEM, ORDER, CREATIVE, PRODUCT_TEMPLATE, PRODUCT, PROPOSAL, PROPOSAL_LINE_ITEM, USER, UNKNOWN.

DataType String False

The type of data this custom field contains. This attribute is read-only if there exists a CustomFieldValue for this field.

The allowed values are STRING, NUMBER, TOGGLE, DROP_DOWN, UNKNOWN.

Visibility String False

How visible/accessible this field is in the UI.

The allowed values are API_ONLY, READ_ONLY, FULL.

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