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."); } } }