[Beta] Retrieve a Data Lab Report

curl 'https://api.impact.com/Advertisers/<AccountSID>/DataLab/v1/query?uuid=de2ba4a8-b14f-4087-9357-03781e67c1al&dimensionFilter=full_date=bt=(%222025-03-19%22,
%222025-04-01%22) ;program=in=(%2212345%22); channel=in=(%22Affiliate/CPA%20Network%22)' \
-X GET \
-H "Accept: application/x-ndjson" \
--user '<SID>: <TOKEN>'

full_date=bt=("2025-03-19","2025-04-01");
program=in=("12345");
channel=in=("Affiliate/CPA Network")

import java.io.IOException;
import java.net.URI;
import java.net.URLEncoder;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.util.Map;
import java.util.stream.Collectors;


class ApiClient {
   public static void main(String[] args) throws IOException, InterruptedException {


       // Replace with your actual username and password. This is found in the 3 dots > Settings > API for a logged in account
       String username = "<Impact Account SID>";
       String password = "<Impact Auth Token>";


       // Account ID
       Long accountId = 12345L; // Replace with the correct Account ID


       // Parameters
       Map<String, String> parameters = Map.of(
               // Unique API identifier
               "uuid", "d90bbf0f-c767-4649-87eb-72e43c329712", // Replace with uuid from the generated CURL
               // Filter params - Replace with dimensionFilter from the generated CURL (This was URI decoded)
               "dimensionFilter", "full_date=bt=(\"2024-02-13\",\"2024-02-26\");program=in=(\"1234\");channel=in=(\"Affiliate/CPA Network\")"
       );


       String url = String.format("https://api.impact.com/Advertisers/%s/DataLab/v1/query", accountId);
       HttpClient httpClient = HttpClient.newHttpClient();
       HttpRequest request = HttpRequest.newBuilder()
               .uri(URI.create(appendParameters(url, parameters)))
               .header("Content-Type", "application/x-ndjson") // or text/event-stream 
               .header("Authorization", getBasicAuthHeader(username, password))
               .GET()
               .build();


       HttpResponse<String> response = httpClient.send(request, HttpResponse.BodyHandlers.ofString());


       // Check if the request was successful (status code 200) - Consider wrapping in a loop for retries
       if (response.statusCode() == 200) {
           // Output the results - This can be replaced as needed
           System.out.println(response.body());
       } else {
           // Print the error message if the request was not successful
           System.out.println("Error: " + response.statusCode() + " - " + response.body());
       }
   }


   /**
    * Build the credentials for basic authentication and base64 encode them
    */
   private static String getBasicAuthHeader(String username, String password) {
       String credentials = username + ":" + password;
       return "Basic " + java.util.Base64.getEncoder().encodeToString(credentials.getBytes());
   }


   /**
    * Append parameters to the URL and URL-encode them
    */
   private static String appendParameters(String url, Map<String, String> parameters) {
       String params = parameters.entrySet().stream()
               .map(entry -> entry.getKey() + "=" + URLEncoder.encode(entry.getValue(), java.nio.charset.StandardCharsets.UTF_8))
               .collect(Collectors.joining("&"));
       return url + "?" + params;
   }
}

import base64
import urllib.parse
from urllib.request import Request, urlopen


def main():
   # Replace with your actual username and password
   username = "<Impact Account SID>"
   password = "<Impact Auth Token>"


   # Account ID
   account_id = 12345  # Replace with the correct Account ID


   # Parameters
   parameters = {
       # Unique API identifier
       "uuid": "d90bbf0f-c767-4649-87eb-73343c369721",  # Replace with uuid from the generated CURL
       # Filter params - Replace with dimensionFilter from the generated CURL (This was URI decoded)
       "dimensionFilter": "full_date=bt=(\"2024-02-13\",\"2024-02-26\");program=in=(\"1234\");channel=in=(\"Affiliate/CPA Network\")"
   }


   url = f"https://api.impact.net/Advertisers/{account_id}/DataLab/v1/query"
   headers = {
       "Content-Type": "application/x-ndjson", // or text/event-stream
       "Authorization": get_basic_auth_header(username, password)
   }


   # Build the URL with parameters
   url_with_params = append_parameters(url, parameters)
  
   # Make the HTTP request
   request = Request(url_with_params, headers=headers, method="GET")
   with urlopen(request) as response:
       # Check if the request was successful (status code 200) - Consider wrapping in a loop for retries
       if response.getcode() == 200:
           # Output the results - This can be replaced as needed
           print(response.read().decode("utf-8"))
       else:
           # Print the error message if the request was not successful
           print(f"Error: {response.getcode()} - {response.read().decode('utf-8')}")


def get_basic_auth_header(username, password):
   credentials = f"{username}:{password}"
   return "Basic " + base64.b64encode(credentials.encode("utf-8")).decode("utf-8")

def append_parameters(url, parameters):
   # Append parameters to the URL and URL-encode them
   params = urllib.parse.urlencode(parameters)
   return f"{url}?{params}"


if __name__ == "__main__":
   main()

const axios = require('axios');


async function fetchData() {
   const username = '<Impact Account SID>';
   const password = '<Impact Auth Token>';
   const accountId = 12345;


   const parameters = {
       uuid: 'd90bbf0f-c767-4649-87eb-73e43c369711',
       dimensionFilter: 'full_date=bt=("2024-02-13","2024-02-26");program=in=("1234");channel=in=("Affiliate/CPA Network")',
   };


   const url = `https://api.impact.com/Advertisers/${accountId}/DataLab/v1/query`;
   const urlWithParams = appendParameters(url, parameters);


   try {
       const response = await axios.get(urlWithParams, {
           headers: {
               'Content-Type': 'application/x-ndjson',
               'Authorization': getBasicAuthHeader(username, password),
           },
       });


       console.log(response.data);
   } catch (error) {
       console.error(`Error: ${error.response.status} - ${error.response.data}`);

   }
}


function getBasicAuthHeader(username, password) {
   const credentials = `${username}:${password}`;
   return 'Basic ' + Buffer.from(credentials).toString('base64');
}


function appendParameters(url, parameters) {
   const params = new URLSearchParams(parameters).toString();
   return `${url}?${params}`;
}


fetchData();