Forum Discussion

  • Retrieve your data using ?act=API_GenResultsTable&jsa=1 and your data will be in an array named qdb_data. You can then reduce the data using Underscore. This general procedure will produce data in the array format Goolgle Visualization requires.
  • Thanks.  My question is basically how to implement the API call.  Would I create the report first in QuickBase and then grab the URL from that report; then incorporate that URL in the result below?

    function doGet(){
      var result = UrlFetchApp.fetch('?act=API_GenResultsTable&jsa=1');
      var json = Utilities.jsonParse(result.getContentText());
      var top_users = json.top_users;
    }
  • Your code appears to be using some Google libraries to make the HTTP request for the QuickBase data. Just use jQuery instead. This code fragment queries table dbid for the query with qid=17 and returns the results as an array named qdb_data:

    var dbid="????????";$.getScript(dbid + "?act=API_GenResultsTable&qid=17&jsa=1",function(){ console.log(qdb_data);});

    You would manipulate the array qdb_data into the datatable required by Google Visualization.