public static void runExample(
DfpServices dfpServices, DfpSession session, long customTargetingValueId) throws Exception {
// Get the CustomTargetingService.
CustomTargetingServiceInterface customTargetingService =
dfpServices.get(session, CustomTargetingServiceInterface.class);
// Create a statement to get custom targeting values.
StatementBuilder statementBuilder =
new StatementBuilder()
.where("WHERE id = :id")
.orderBy("id ASC")
.limit(StatementBuilder.SUGGESTED_PAGE_LIMIT)
.withBindVariableValue("id", customTargetingValueId);
// Default for total result set size.
int totalResultSetSize = 0;
do {
// Get custom targeting values by statement.
CustomTargetingValuePage page =
customTargetingService.getCustomTargetingValuesByStatement(
statementBuilder.toStatement());
if (page.getResults() != null) {
totalResultSetSize = page.getTotalResultSetSize();
CustomTargetingValue[] customTargetingValues = page.getResults();
// Update each local custom targeting value object by changing its display
// name.
for (CustomTargetingValue customTargetingValue : customTargetingValues) {
if (customTargetingValue.getDisplayName() == null) {
customTargetingValue.setDisplayName(customTargetingValue.getName());
}
customTargetingValue.setDisplayName(
customTargetingValue.getDisplayName() + " (Deprecated)");
}
// Update the custom targeting values on the server.
customTargetingValues =
customTargetingService.updateCustomTargetingValues(customTargetingValues);
for (CustomTargetingValue updatedCustomTargetingValue : customTargetingValues) {
System.out.printf(
"Custom targeting value with ID %d, name '%s', and display name "
+ "'%s' was updated.%n",
updatedCustomTargetingValue.getId(),
updatedCustomTargetingValue.getName(),
updatedCustomTargetingValue.getDisplayName());
}
}
statementBuilder.increaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
} while (statementBuilder.getOffset() < totalResultSetSize);
}
public static void runExample(DfpServices dfpServices, DfpSession session, long lineItemId)
throws Exception {
// Get the LineItemCreativeAssociationService.
LineItemCreativeAssociationServiceInterface licaService =
dfpServices.get(session, LineItemCreativeAssociationServiceInterface.class);
// Create a statement to select all LICAs for a line item.
StatementBuilder statementBuilder =
new StatementBuilder()
.where("WHERE lineItemId = :lineItemId")
.orderBy("lineItemId ASC, creativeId ASC")
.limit(StatementBuilder.SUGGESTED_PAGE_LIMIT)
.withBindVariableValue("lineItemId", lineItemId);
// Default for total result set size.
int totalResultSetSize = 0;
do {
// Get LICAs by statement.
LineItemCreativeAssociationPage page =
licaService.getLineItemCreativeAssociationsByStatement(statementBuilder.toStatement());
if (page.getResults() != null) {
totalResultSetSize = page.getTotalResultSetSize();
int i = page.getStartIndex();
for (LineItemCreativeAssociation lica : page.getResults()) {
if (lica.getCreativeSetId() != null) {
System.out.printf(
"%d) LICA with line item ID %d and creative " + "set ID %d will be deactivated.%n",
i++, lica.getLineItemId(), lica.getCreativeSetId());
} else {
System.out.printf(
"%d) LICA with line item ID %d and creative ID %d will be deactivated.%n",
i++, lica.getLineItemId(), lica.getCreativeId());
}
}
}
statementBuilder.increaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
} while (statementBuilder.getOffset() < totalResultSetSize);
System.out.printf("Number of LICAs to be deactivated: %d%n", totalResultSetSize);
if (totalResultSetSize > 0) {
// Remove limit and offset from statement.
statementBuilder.removeLimitAndOffset();
// Create action.
DeactivateLineItemCreativeAssociations action = new DeactivateLineItemCreativeAssociations();
// Perform action.
UpdateResult result =
licaService.performLineItemCreativeAssociationAction(
action, statementBuilder.toStatement());
if (result != null && result.getNumChanges() > 0) {
System.out.printf("Number of LICAs deactivated: %d%n", result.getNumChanges());
} else {
System.out.println("No LICAs were deactivated.");
}
}
}
