API_DoQuery vs a report

Typically it would be used in a website to query Quick Base or in some other interface to another software system.

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.

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.

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?