Reporting API

{
	"id": "<your@email.com>",
	"password": "<your_password>",
	"accountId": "<account_id>"
}

{
	"data": {
		"token": "adadSodsaoSTdzQZUYi5IMdvadsRNCqs4tdaAvDSWTfNrxAsfeg5wzikAbE6NktCiYntw1KmhQ2A2v dvaNasdkg-JCmdPauDaddsGddadaaasd4Mi6EUUKbb2SWYIa3BGXTjeQrQIn53k9e94EuMjqRQ68PLEv8VZY3ie aRds_az2y3adCSq7mUCHg== ",
		"accountId": "5678fa70181f46dc32812345"
	}
}

{
  “id”: 0
}

<?php

global $apiEp;
$apiEp = 'https://manage.aniview.com/api';

function login($id, $password, $accountId)
{
    global $apiEp;
    $tokenEp = $apiEp . '/token?format=json';
    $ch = curl_init($tokenEp);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");

    $data = array("id" => $id, "password" => $password, "accountId" => $accountId);
    $data_string = json_encode($data);

    curl_setopt($ch, CURLOPT_POSTFIELDS, $data_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    $headers = array();
    $headers[] = 'Content-Type: application/json';
    $headers[] = 'Cache-Control: no-cache';
    $headers[] = 'Content-Length: ' . strlen($data_string);
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_POST, 1);


    $result = curl_exec($ch);
    $result = json_decode($result);

    curl_close($ch);

    return $result;
}

function fetchReport($tokenString, $startDate, $endDate, $dimensions, $metrics, $filtersJsonString, $format = 'csv', $polling = false)
{
    global $apiEp;
    
    $reportEP = $apiEp . '/adserver/stats/report?format=' . $format;
    $queryParams = "&startDate=$startDate&endDate=$endDate"
        . "&dimensions=" . urlencode(implode(",", $dimensions))
        . "&metrics=" . urlencode(implode(",", $metrics))
        . "&query=" . $filtersJsonString;

    $url = $reportEP . $queryParams;
    var_dump($url);
    $ch = curl_init($url);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    $headers = array();
    if ($format == 'json') {
        $headers[] = 'Content-Type: application/json';
    }
    $headers[] = 'Cache-Control: no-cache';
    $headers[] = "X-Bamboo-Token: $tokenString";
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    $output = curl_exec($ch);
    $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

    var_dump($httpcode);
    if ($format == 'json') {
        $result = json_decode($output);
    } else {
        $result = $output;
    }

    curl_close($ch);

    return $result;
}

function getReportById($tokenString, $reportId)
{
    global $apiEp;

    $reportEP = $apiEp . "/adserver/report/$reportId?format=json";
    $url = $reportEP;
    var_dump($url);
    $ch = curl_init($url);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    $headers = array();
    $headers[] = 'Content-Type: application/json';
    $headers[] = 'Cache-Control: no-cache';
    $headers[] = "X-Bamboo-Token: $tokenString";
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    $output = curl_exec($ch);
    $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

    var_dump($httpcode);
    $result = json_decode($output);
    curl_close($ch);

    return $result;
}

function getReportObjectForPolling($tokenString, $startDate, $endDate, $dimensions, $metrics, $filtersJsonString)
{
    global $apiEp;

    $reportEP = $apiEp . '/adserver/stats/report?format=json&reportFormat=csv';
    $queryParams = "&startDate=$startDate&endDate=$endDate"
        . "&returnReport=true" // Will return the report object for polling
        . "&dimensions=" . urlencode(implode(",", $dimensions))
        . "&metrics=" . urlencode(implode(",", $metrics))
        . "&query=" . $filtersJsonString;

    $url = $reportEP . $queryParams;
    var_dump($url);
    $ch = curl_init($url);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

    $headers = array();
    $headers[] = 'Content-Type: application/json';
    $headers[] = 'Cache-Control: no-cache';
    $headers[] = "X-Bamboo-Token: $tokenString";
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    $output = curl_exec($ch);
    $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

    var_dump($httpcode);
    $result = json_decode($output);
    curl_close($ch);

    return $result;
}


/**
 * Example for getting report as JSON
 * 
 * @param string $id
 * @param string $password
 * @param string $accountId
 * @return string|null
 */
function csvReportDataExample($id, $password, $accountId) {
    $tokenData = login($id, $password, $accountId);
    var_dump($tokenData);

    $tokenString = $tokenData->data->token;

// Start - now
    $endDate = time();
// End - One day back
    $startDate = $endDate - 60*60*24;
// Dimensions - Date, Hour, Channel ID
    $dimensions = array('daily', 'hourly', 'ncid');
// Metrics - inventory, inventoryRequest, request, bid, impression
    $metrics = array('inventory', 'inventoryRequest', 'request', 'bid', 'impression');
// Filter of channel example..
    $filterJsonString = '{"ncid":{"$in":["56df1aba181f4ccccf8b45af"]}}';
    $filterJsonString = '';

    $reportData = fetchReport($tokenString, $startDate, $endDate, $dimensions, $metrics, $filterJsonString);

    return $reportData;
}

/**
 * Example for polling report and getting reportObject when ready.
 * 
 * @param string $id
 * @param string $password
 * @param string $accountId
 * @return object
 * @throws Exception
 */
function pollingReportExample($id, $password, $accountId) {
    $tokenData = login($id, $password, $accountId);
    var_dump($tokenData);

    $tokenString = $tokenData->data->token;

// Start - now
    $endDate = time();
// End - One day back
    $startDate = $endDate - 60*60*24;
// Dimensions - Date, Hour, Channel ID
    $dimensions = array('daily', 'hourly', 'ncid');
// Metrics - inventory, inventoryRequest, request, bid, impression
    $metrics = array('inventory', 'inventoryRequest', 'request', 'bid', 'impression');
// Filter of channel example..
    $filterJsonString = '{"ncid":{"$in":["56df1aba181f4ccccf8b45af"]}}';
    $filterJsonString = '';

    $reportData = getReportObjectForPolling($tokenString, $startDate, $endDate, $dimensions, $metrics, $filterJsonString);
    $reportObj = $reportData->data;

    $pollingCount = 0;
    $pollingInterval = 15;
    $maxPollingAmount = 50;
    while($reportObj->status !== 7 && $pollingCount < $maxPollingAmount) {
        $pollingCount++;
        sleep($pollingInterval);

        // Get Report Again
        $reportData = getReportById($tokenString, $reportObj->_id['$oid']);
        $reportObj = $reportData->data;
    }

    if ($reportObj->status !== 7 || $reportObj->reportUrl === null) {
        throw new Exception("Failed to poll report", 500);
    }


    return $reportObj;
}

$id = 'av_report_example@aniview.com';
$password ='abcdEFG2010';
$accountId = '561e599e181f46b1328b4568';


/**
 * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 * - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 */
$reportData = csvReportDataExample($id, $password, $accountId);
var_dump($reportData);

try {
    $reportObj = pollingReportExample($id, $password, $accountId);
    if ($reportObj->status === 7 && $reportObj->reportUrl) {
        // Report Ready.
        // Download Report and handle result

    }
} catch (Exception $e) {
    log("Failed to get report");
}