Forum Discussion
- _anomDiebolt_Qrew EliteRetrieve 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.
- ArchiveUserQrew CaptainAre there specific function calls and variables that I need?
- _anomDiebolt_Qrew EliteYou question is too broad as I don't know what you want to acheive. The Vandelay Industries example was created using Google Visualization:
https://haversineconsulting.quickbase.com/db/bhf8pmjat
I had a writeup on this example on the posterous blog but twitter purchased posterous and shut it down. - ArchiveUserQrew CaptainThanks. 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;
} - _anomDiebolt_Qrew EliteYour 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. - TamaraBillingsQrew CadetDoes QB have step by step instructions or a video anywhere on this?