CData Python Connector for Google Ad Manager

Build 24.0.9060

CustomFields

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

Select

The following queries are processed server side by the Google Ad Manager APIs.

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 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 field 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 a CustomFieldValue exists 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060