Feed

Hi all, 

I have written a script in automation studio for a get API. It shows no errors. In postman i also seem to be connecting fine and seeing the variables. Is there anything i am missing out for the data not to come into marketing cloud? 

I also have the data extension setup correctly for which i want the contacts to come into 

<script runat="server">
  Platform.Load("Core", "1.1.1");
  try {
    // Data Extension external key
     var dataExtensionExternalKey = "XXXXXX"; // 
    // Initialize the Data Extension using the external key
    var dataExtension = DataExtension.Init(dataExtensionExternalKey);
    // 3rd-party API endpoint and credentials 
    var apiEndpoint = "https://sample.net/api/company/v1.7/venue/66327/visitors";
    var publicKey = "XXXX"; // 
    var privateKey = "ZZZZ"; //
    // Calculate the timeframe for the past 24 hours if not provided
    var now = new Date();
    var toDate = Request.GetQueryStringParameter("toDate") || now.toISOString().split('.')[0]; // Current date and time in ISO format without milliseconds
    var fromDate = Request.GetQueryStringParameter("fromDate") || new Date(now.getTime() - (24 * 60 * 60 * 1000)).toISOString().split('.')[0]; // 24 hours ago in ISO format without milliseconds
    // Convert dates to UTC and format as YYYYMMDD[HHMMSS]
    function formatDateToYYYYMMDDHHMMSS(date) {
      var yyyy = date.getUTCFullYear().toString();
      var MM = (date.getUTCMonth() + 1).toString().padStart(2, '0'); // Months are zero-based
      var dd = date.getUTCDate().toString().padStart(2, '0');
      var HH = date.getUTCHours().toString().padStart(2, '0');
      var mm = date.getUTCMinutes().toString().padStart(2, '0');
      var ss = date.getUTCSeconds().toString().padStart(2, '0');
      return yyyy + MM + dd + '[' + HH + mm + ss + ']';
    }
    var toDateUTC = formatDateToYYYYMMDDHHMMSS(new Date(toDate));
    var fromDateUTC = formatDateToYYYYMMDDHHMMSS(new Date(fromDate));
    // Construct the full API endpoint with query parameters
    var fullApiEndpoint = apiEndpoint + "?fromDate=" + encodeURIComponent(fromDateUTC) + "&toDate=" + encodeURIComponent(toDateUTC);
    // Set up the request headers with public and private keys
    var headers = [
      ["Authorization", "Bearer " + publicKey + ":" + privateKey]
    ];
    // Fetch contacts from the third-party API
    var response = HTTP.Get(fullApiEndpoint, headers);
    // Check if the API call was successful
    if (response.StatusCode == 200) {
      // Parse the JSON response
      var responseData = Platform.Function.ParseJSON(response.Response);
      // Check if visitors array is present in the response data
      if (responseData && responseData.data && responseData.data.visitors) {
        var visitorList = responseData.data.visitors;
        var importedCount = 0;
        // Loop through the contacts and insert them into the Data Extension
        for (var i = 0; i < visitorList.length; i++) {
          var contact = visitorList[i];
          // Only insert contacts with email_verified set to true
          if (contact.email_verified === true) {
            var row = {
              "Firstname": contact.first_name,  // Correctly accessing the fields and matching Data Extension field names
              "Lastname": contact.last_name,    // Correctly accessing the fields and matching Data Extension field names
              "Email": contact.email,
              "email_verified": contact.email_verified  // Using the field from the API response
            };
            // Insert the row into the Data Extension
            dataExtension.Rows.Add(row);
            importedCount++;
          }
        }
      }
    }
  } catch (e) {
    // Handle any errors that occur during the script execution
    // Error handling code can be added here if needed
  }
</script>