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