Create, update, and query DoubleClick for Publishers Custom Fields.
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'
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')
You can update any field not marked as read-only by specifying the Id column.
UPDATE [CustomFields] SET Description = 'New Description' WHERE Id = '1238676'
The delete operation is not supported for this table.
Unique ID of the CustomField. This value is readonly and is assigned by Google.
Name of the CustomField. This is value is required to create a custom field. The max length is 127 characters.
A description of the custom field. This value is optional. The maximum length is 511 characters
Specifies whether or not the custom fields is active. This attribute is read-only.
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.
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.
How visible/accessible this field is in the UI.
The allowed values are API_ONLY, READ_ONLY, FULL.