$user = new DfpUser(); // Log SOAP XML request and response. $user->LogDefaults(); // Get the ContentService. $contentService = $user->GetService('ContentService', 'v201408'); // Create a statement to select all content. $statementBuilder = new StatementBuilder(); $statementBuilder->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT); // Default for total result set size. $totalResultSetSize = 0; do { // Get content by statement. $page = $contentService->getContentByStatement($statementBuilder->ToStatement()); // Display results. if (isset($page->results)) { $totalResultSetSize = $page->totalResultSetSize; $i = $page->startIndex; foreach ($page->results as $content) { printf("%d) Content with ID %d, name '%s', and status %s was found.\n", $i++, $content->id, $content->name, $content->status); } } $statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT); } while ($statementBuilder->GetOffset() < $totalResultSetSize); printf("Number of results found: %d\n", $totalResultSetSize); } catch (OAuth2Exception $e) { ExampleUtils::CheckForOAuth2Errors($e); } catch (ValidationException $e) { ExampleUtils::CheckForOAuth2Errors($e); } catch (Exception $e) { printf("%s\n", $e->getMessage()); }
// Log SOAP XML request and response. $user->LogDefaults(); $pqlService = $user->GetService('PublisherQueryLanguageService', 'v201608'); // Create statement to select all programmatic buyers. $statementBuilder = new StatementBuilder(); $statementBuilder->Select('BuyerAccountId, Name')->From('Programmatic_Buyer')->OrderBy('BuyerAccountId ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT); // Retrieve a small amount of rows at a time, paging through until all rows // have been retrieved. $resultSet = null; $combinedResultSet = null; $i = 0; do { $resultSet = $pqlService->select($statementBuilder->ToStatement()); // Combine result sets with previous ones. $combinedResultSet = $combinedResultSet !== null ? $resultSet : Pql::CombineResultSets($combinedResultSet, $resultSet); printf("%d) %d programmatic buyers beginning at offset %d were found.\n", $i++, $resultSet->rows !== null ? count($resultSet->rows) : 0, $statementBuilder->GetOffset()); $statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT); } while ($resultSet->rows !== null && count($resultSet->rows) > 0); // Change to another file location if desired. $filePath = sprintf("%s/programmatic-buyers-%s.csv", sys_get_temp_dir(), uniqid()); $fp = fopen($filePath, 'w'); // Write the result set to a CSV. fputcsv($fp, Pql::GetColumnLabels($combinedResultSet)); foreach ($combinedResultSet->rows as $row) { fputcsv($fp, Pql::GetRowStringValues($row)); } fclose($fp); printf("Programmatic buyers saved to %s\n", $filePath); } catch (OAuth2Exception $e) { ExampleUtils::CheckForOAuth2Errors($e); } catch (ValidationException $e) {
$user->LogDefaults(); // Get the PublisherQueryLanguageService. $pqlService = $user->GetService('PublisherQueryLanguageService', 'v201508'); // Create statement to select all line items. $statementBuilder = new StatementBuilder(); $statementBuilder->Select('Id, BrowserName, MajorVersion, MinorVersion')->From('Browser')->OrderBy('BrowserName ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT); // Default for result sets. $resultSet = null; $combinedResultSet = null; $i = 0; do { // Get all browsers. $resultSet = $pqlService->select($statementBuilder->ToStatement()); // Combine result sets with previous ones. $combinedResultSet = !isset($combinedResultSet) ? $resultSet : Pql::CombineResultSets($combinedResultSet, $resultSet); printf("%d) %d browsers beginning at offset %d were found.\n", $i++, isset($resultSet->rows) ? count($resultSet->rows) : 0, $statementBuilder->GetOffset()); $statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT); } while (isset($resultSet->rows) && count($resultSet->rows) > 0); // Change to your file location. $filePath = sprintf("%s/Browsers-%s.csv", sys_get_temp_dir(), uniqid()); $fp = fopen($filePath, 'w'); // Write the result set to a CSV. fputcsv($fp, Pql::GetColumnLabels($combinedResultSet)); foreach ($combinedResultSet->rows as $row) { fputcsv($fp, Pql::GetRowStringValues($row)); } fclose($fp); printf("Browsers saved to %s\n", $filePath); } catch (OAuth2Exception $e) { ExampleUtils::CheckForOAuth2Errors($e); } catch (ValidationException $e) {
/** * Gets predefined custom targeting key IDs. */ function getPredefinedCustomTargetingKeyIds($user) { $customTargetingKeyIds = array(); // Get the CustomTargetingService. $customTargetingService = $user->GetService('CustomTargetingService', 'v201508'); // Create a statement to get predefined custom targeting keys. $statementBuilder = new StatementBuilder(); $statementBuilder->Where('type = :type')->OrderBy('id ASC')->Limit(StatementBuilder::SUGGESTED_PAGE_LIMIT)->WithBindVariableValue('type', 'PREDEFINED'); // Default for total result set size. $totalResultSetSize = 0; do { // Get custom targeting keys by statement. $page = $customTargetingService->getCustomTargetingKeysByStatement($statementBuilder->ToStatement()); // Display results. if (isset($page->results)) { $totalResultSetSize = $page->totalResultSetSize; $i = $page->startIndex; foreach ($page->results as $customTargetingKey) { printf("%d) Custom targeting key with ID %d, name '%s', and display " . "name '%s' was found.\n", $i++, $customTargetingKey->id, $customTargetingKey->name, $customTargetingKey->displayName); $customTargetingKeyIds[] = $customTargetingKey->id; } } $statementBuilder->IncreaseOffsetBy(StatementBuilder::SUGGESTED_PAGE_LIMIT); } while ($statementBuilder->GetOffset() < $totalResultSetSize); return $customTargetingKeyIds; }