Discussions

Back to discussions
Expand all | Collapse all

Quickbase API API_GenResultsTable HTTP POST as JSON examples

  • 1.  Quickbase API API_GenResultsTable HTTP POST as JSON examples

    Posted 11-13-2019 11:43
    I have a URL like this to access QuickBase's API. I am using an HTTP 'GET' approach. How can I reformat this as a 'POST?'

    https://abc.quickbase.com/db/babcd?a=API_GenResultsTable&qid=13&jsa=1&usertoken=abc123x

    I am using Postman and a browser to send these requests. GET works fine, I would like to rewrite this as a JSON POST.  This site provides some clues, but not enough examples, https://help.quickbase.com/api-guide/gen_results_table.html. 

    I need to post API_GenResultsTable, qid, jsa, and usertoken. I have tried doing this as JSON and as XML, no luck.

    Sample XML Request

    POST https://target_domain/db/target_dbid HTTP/1.0
    Content-Type: application/xml
    Content-Length:
    QUICKBASE-ACTION: API_GenResultsTable 

    <qdbapi>
       <ticket>auth_ticket</ticket>
       <apptoken>app_token</apptoken>
       <query>{'11'.CT.'Bob'}AND{'19'.GTE.'5'}</query>
       <clist>6.7.9.11.16</clist>
       <slist>11.6</slist>
       <fmt>structured</fmt>
       <options>num-4.sortorder-D</options>
    </qdbapi>

    Thanks for any help.

    ------------------------------
    Chad Cox
    ------------------------------


  • 2.  RE: Quickbase API API_GenResultsTable HTTP POST as JSON examples

    Posted 11-14-2019 16:02
    I will go ahead and answer my own question.

    var settings = {
    "async": true,
    "crossDomain": true,
    "url": "https://company.quickbase.com/db/aasdasd",
    "method": "POST",
    "headers": {
    "Content-Type": "application/xml",
    "QUICKBASE-ACTION": "API_GenResultsTable",
    },
    "data": "<qdbapi>\r\n <usertoken>alkjeoriuwe,kans,kjda,ksdjlks,a</usertoken>\r\n <qid>187</qid>\r\n <jsa>1</jsa>\r\n</qdbapi>"
    }

    $.ajax(settings).done(function (response) {
    console.log(response);
    });

    ------------------------------
    Chad Cox
    ------------------------------

    Original Message