Forum Discussion

AlvaroGuerrero's avatar
AlvaroGuerrero
Qrew Member
9 years ago

API_DOQUERY Javascript is not working

Hi,

I'm testing the API_DoQuery with the following code and I'm not getting any result. Could you help me?

var promise = $.get(dbidcalendar, {

act: "API_DoQuery",

          query: "{3.EX.178}",

          clist: "3"

});

$.when(promise).then(function(xml){

var recordid = $("rid", xml).text();

});


I use something similar for API_AddRecord and API_EditRecord and it works very well. The APP does not have APPTOKEN

APIs and custom code
reports and charts
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    9 years ago
    Try this and note the areas where I highlighted the code:

    var promise = $.get(dbidcalendar, {
      act: "API_DoQuery",
      query: "{3.EX.178}",
      clist: "3"
    });

    $.when(promise).then(function(xml){
      console.dirxml(xml);
      var recordid = $("record_id_", xml).text();
      console.log(recordid);
    });

    or chained version:

    $.get(dbidcalendar, {
      act: "API_DoQuery",
      query: "{3.EX.178}",
      clist: "3"
    }).then(function(xml){
      console.dirxml(xml);
      var recordid = $("record_id_", xml).text();
      console.log(recordid);
    });
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    9 years ago
    This will make all requests synchronous including those QuickBase makes through their own use of jQuery:

    $.ajaxSetup({async: false});

    Everything on the internet is asynchronous so you should learn to use asynchronous methods.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    9 years ago
    Both of my versions are asynchronous. I have not written a synchronous script is a decade!
  • ShankarRavi's avatar
    ShankarRavi
    Qrew Cadet
    9 years ago
    If I just remove $.ajaxSetup({async: false}); from my script then will my code become asynchronous?
  • CarlosCarlos's avatar
    CarlosCarlos
    Qrew Assistant Captain
    7 years ago
    Hi,
    I'd really appreciate some help.. Trying to implement Dan's solution but the value I'm getting from the Do_Query is always 0..
    fid_109 is called f_montominimo, and it should be a numeric value. I?m trying to get it into a variable and display on an alert (to verify it) and I use it later on in the code for other calculations.
    var promise1 = $.get(gReqDBID, {
      act: "API_DoQuery",
      query: "{3.EX.QBU_key}",
      clist: "3.109"
    });
    $.when(promise1).then(function(xml){
      console.dirxml(xml);
      var montominimo = $("f_montominimo", xml).text();
    montomin = Number(montominimo);
      console.log(montominimo);
    });
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      7 years ago
      It is better to ask a new question with your specific details.

      The first thing I noticed is that you have QBU_key as a literal substing:
      query: "{3.EX.QBU_key}",
      You should be string concatenation like so:
      query: "{3.EX." + QBU_key+ "}",
      Or string interpolation:
      query: '{3.EX.${QBU_key}}',
      But in any case you don't say where the variable QBU_key is coming from.
    • CarlosCarlos's avatar
      CarlosCarlos
      Qrew Assistant Captain
      7 years ago
      The js code executes on a button click... But that first thing you noticed actually solved it! Thanks!
      "javascript:" &
              "var QBU_key = '" & [Record ID#] & "';" &
              "$.getScript(gReqAppDBID + '?a=dbpage&pagename=ADDBID.js');" &
              "void(0);"