Having trouble getting an API call to fire.
Hello I am a new Quickbase user having a bit of trouble writing a script to return a small sample of data. Below is my code, var url = "domain"; url += "/db/"; url += "bm9rx6w83"; url += "?a...
Forum Discussion
Try this by pasting into the console (don't waste your time pasting into a code page):
(function() {
var dbid = "<your application dbid>";
var dbidTable = "bm9rx6w83";
var apptoken = "tvy5zcdaqafyfxp43vhd78gyys";
$.ajaxSetup({data: {apptoken: apptoken}});
$.post(dbidTable, {
act: "API_DoQuery",
query: "{20.GT.1000}",
clist: "a",
options: "sortorder-D"
}).then(function(xml) {
console.dirxml(xml);
var name, tuition, major;
$("record", xml).each(function() {
name = $("name", this).text();
tuition = $("tuition", this).text();
major = $("major", this).text();
console.log(name, tuition, major);
});
});
})();