Quick Base Discussions

Expand all | Collapse all

API_DoQuery vs a report

  • 1.  API_DoQuery vs a report

    Bronze
    Contributor
    Posted 07-07-2017 16:49
    I was reading the description of the API_DoQuery and its uses but can someone give me a use case for using it over a report? I feel like its functionality can be accomplished without having to write anything just by creating a report and using filters.


  • 2.  RE: API_DoQuery vs a report

    Posted 07-07-2017 17:00
    Typically it would be used in a website to query Quick Base or in some other interface to another software system.


  • 3.  RE: API_DoQuery vs a report

    Posted 07-07-2017 17:01
    Jordan, if you just need to retrieve and display information for end users, then in most cases a report works fine. The DoQuery call is used a lot to integrate an app with a third-party service or to process records and create, update, or delete records in other tables based on a record set.

    To give one example, I use API_DoQuery with clients who need a visual user interface (spatial, geographic) that isn't possible within the native Quick Base UI. API_DoQuery allows records to be retrieved and processed on the server and then displayed visually in the browser. Changes made using the custom UI result in records being created, updated, or deleted in the app.


  • 4.  RE: API_DoQuery vs a report

    Bronze
    Contributor
    Posted 07-07-2017 17:09
    Another use case is I recently built out a custom page that was a few tables of reports. However each cell was basically its own report so basically I created an object of queries and a function that runs all the queries and populates each cell.


  • 5.  RE: API_DoQuery vs a report

    Bronze
    Contributor
    Posted 07-07-2017 17:13
    So while working within Quickbase the use of reports is fine. Though, If I was to build a custom HTML page or want to do a POST request to third party software, then I would use the API_DoQuery?


  • 6.  RE: API_DoQuery vs a report

    Bronze
    Contributor
    Posted 07-07-2017 18:31
    That's what I would recommend. You could query for anything without having to be constrained by relationships then take that data and send a post to wherever as json, csv, or xml. Can reach out directly if you want help with this.


  • 7.  RE: API_DoQuery vs a report

    Bronze
    Contributor
    Posted 07-07-2017 18:55
    Reaching out directly would help a lot! Is there somewhere I can find your contact info?


  • 8.  RE: API_DoQuery vs a report

    Bronze
    Contributor
    Posted 07-07-2017 18:57
    21.co/chuck and will respond with email address.