// This script makes an API_DoQuery call to QuickBase

  var url = "https://accesshealth.quickbase.com";     // Remember to put in YOUR baseURL
  url    += "/db/";
  url    += "bqiugimvj";                                   // Remember to put in YOUR tableDBID
  url    += "?a=API_DoQuery";

  var request = "<qdbapi>";
  request    += "<apptoken>TOKEN_ENTERED_HERE</apptoken>";            // Remember to put in YOUR appToken
  request    += "<query>{'13'.EQ.'High'}AND{'86'.GT.'7'}</query>";			// Display all tasks that have Priority = 'high' and Budget Hours > 7 (hours)
  request    += "<clist>56.6.12.10</clist>";							// Return Project Name, Task Name, Status, Projected Finish Date
  request    += "<slist>10.56.6</slist>";								// Sort by: Projected Finish Date, Project Name, Task Name
  request    += "<options>sortorder-D</options>";						// Sort in Descending order
  request    += "</qdbapi>";


  $.ajax({
    type: "POST",
    contentType: "text/xml",
    async: false,
    url: url,
    dataType: "xml",
    processData: false,
    data: request,
    success: function (response) {

     var xml = $(response);
     if (xml.find('qdbapi').find('errcode').text() == "0") {

      processRecords(xml);
      
    }
    else 
    {
     console.log("Quickbase returned an error.");
     console.log(response);
   } 
 },
 error: function (response) {
  console.log("Quickbase returned an error.");
  console.log(response);
}
});


  function processRecords(xml)
  {

   xml.find('qdbapi').find('record').each(function(index){

    console.log("Project Name = " + $(this).find("project_name").text());
    console.log("Task Name = " + $(this).find("task_name").text());
    console.log("Status = " + $(this).find("status").text());
    console.log("Projected Finish Date = " + $(this).find("projected_finish_date").text());
    console.log("\n\n");

   // Do Something Useful With The Data Here....

 });
 }