CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

04 June, 2024

Issue while getting data from Ringba API using Google Apps Script

 Programing Coderfunda     June 04, 2024     No comments   

I am trying to get call logs data from Ringba platform using Ringba API. I use the following script to get the data in specific date range.
function fetchRecordingData(spreadsheet, specificBuyerName) {

var ringbaSheet = spreadsheet.getActiveSheet();
var dateValue = ringbaSheet.getRange("K1").getValue();

var targetDate = new Date(dateValue);
var startOfDay = new Date(targetDate.getFullYear(), targetDate.getMonth(), targetDate.getDate(), 0, 0, 0);
var endOfDay = new Date(targetDate.getFullYear(), targetDate.getMonth(), targetDate.getDate(), 23, 59, 59);
var reportStart = new Date(startOfDay.getTime());
var reportEnd = new Date(endOfDay.getTime());

var url = "
https://api.ringba.com/v2/{{account id}}/calllogs";
const apiToken = '###';

var extractedData = [];
var offset = 0;
var size = 1000;

while (true) {
var payload = {
"reportStart": reportStart, //Fri May 31 2024 00:00:00 GMT-0600 (Mountain Daylight Time)
"reportEnd": reportEnd, //Fri May 31 2024 23:59:59 GMT-0600 (Mountain Daylight Time)
"orderByColumns": [],
"filters": [],
"formatDateTime": true,
"formatPercentages": true,
"formatTimeZone": "America/Denver",
"formatTimespans": true,
"offset": offset,
"size": size,
"valueColumns": [
{ "column": "callDt" },
{ "column": "campaignName" },
{ "column": "publisherName" },
{ "column": "inboundPhoneNumber" },
{ "column": "buyer" }
]
};

var options = {
"method": "POST",
"headers": {
"Authorization": "Token " + apiToken,
"Accept": "application/json, text/plain, */*",
"Content-Type": "application/json;charset=UTF-8"
},
"payload": JSON.stringify(payload),
"muteHttpExceptions": true
};

var response = UrlFetchApp.fetch(url, options);
var jsonResponse = JSON.parse(response.getContentText());

var records = jsonResponse.report.records;
if (!records || records.length === 0) {
break;
}

var filteredData = records.filter(function(record) {
return record.buyer && record.buyer.toLowerCase().trim() === specificBuyerName.toLowerCase().trim();
}).map(function(record) {
return [
record.callDt,
record.campaignName,
record.buyer,
record.publisherName,
record.inboundPhoneNumber
];
});

extractedData = extractedData.concat(filteredData);
console.log(extractedData.length);

if (records.length < size) {
break;
}

offset += size;
}

if (extractedData.length > 0) {
var range = ringbaSheet.getRange("A2:E").clearContent();
ringbaSheet.getRange(ringbaSheet.getLastRow() + 1, 1, extractedData.length, extractedData[0].length).setValues(extractedData);
}



There are total of 831 records for that given date, when I run randomly it gives the correct number of records. However, when I run it 2-3 times in quick succession, the number of records in output keeps changing (825,837).


Then I wait for 5-10 minutes, run it, and it gives the correct output (831) again. I am unclear why doesn't it always give the same output. Any guidance to point out my mistake would be much appreciated.
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Sitaare Zameen Par Full Movie Review
     Here’s a  complete Vue.js tutorial for beginners to master level , structured in a progressive and simple way. It covers all essential topi...
  • Credit card validation in laravel
      Validation rules for credit card using laravel-validation-rules/credit-card package in laravel Install package laravel-validation-rules/cr...
  • C++ in Hindi Introduction
    C ++ का परिचय C ++ एक ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग लैंग्वेज है। C ++ को Bjarne Stroustrup द्वारा विकसित किया गया था। C ++ में आने से पह...
  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • iOS 17 Force Screen Rotation not working on iPAD only
    I have followed all the links on Google and StackOverFlow, unfortunately, I could not find any reliable solution Specifically for iPad devic...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (69)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • July (4)
  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

Loading...

Laravel News

Loading...

Copyright © CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda