SSIS Components for Google Ad Manager

Build 24.0.9060

Users

Create, update, delete, and query DoubleClick for Publishers Users.

Select

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

Retrieve a list of Users. For example:

SELECT * FROM [Users]

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

SELECT * FROM [Users] WHERE Id = '244555723'

Insert

To create a new User, the Name, Email, and RoleId fields are required.

INSERT INTO [Users] (Name, Email, RoleId ) VALUES ('murat', '[email protected]', '-1')

Update

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

UPDATE [Users] SET Name = 'New User' WHERE Id = '244555723'

Delete

You can delete a User row by specifying the Id column.

DELETE FROM [Users] WHERE Id = '244555723'

Columns

Name Type ReadOnly Description
Id [KEY] Long True

The unique ID of the User. This attribute is readonly and is assigned by Google.

Name String False

The name of the User. It has a maximum length of 128 characters.

Email String False

The email or login of the User. In order to create a new user, you must already have a Google Account.

RoleId Long False

The unique role ID of the User. Roles that are created by Google will have negative IDs.

RoleName String True

The name of the role assigned to the User. This attribute is readonly.

IsActive Boolean True

Specifies whether or not the User is active. An inactive user cannot log in to the system or perform any operations. This attribute is read-only.

IsEmailNotificationAllowed Boolean False

Specifies whether or not the User wants to permit the Publisher Display Ads system to send email notifications to their email address. This attribute is optional and defaults to true.

ExternalId String False

An identifier for the User that is meaningful to the publisher. This attribute is optional and has a maximum length of 255 characters.

IsServiceAccount Boolean True

Whether the user is an OAuth2 service account user. This attribute is read-only. Service account users can only be added through the UI.

OrdersUiLocalTimeZoneId String False

The long format timezone id (e.g. 'America/Los_Angeles') used in the orders and line items UI for this User. Set this to null to indicate that no such value is defined for the User - UI then defaults to using the Network's timezone. This setting only affects the UI for this user and does not in particular affect the timezone of any dates and times returned in API responses.

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