UseSQL
  • Introduction
  • Getting Started
    • Source Formats
    • Output Formats
    • Managing Keys
    • Sandbox
    • Saved Queries
  • Client Libraries
    • HTML Templating
    • JavaScript Web Client
  • Tutorials
    • Integrate With Your Static Site
    • Share Data In Slack
    • Show external query results in a Google Sheet
    • Query across a Google Sheet and a CSV file
    • Securing Your Key
    • Querying Airtable
    • Integrate With ProcFu
    • Integrate with a private Google Sheet
    • Updating Google Sheets
    • Retrieving data from tables on a web page
    • Displaying reports in Google Sheets from MySQL
    • Querying StackBy Tables
  • Resources
    • Demo Sandbox
    • OpenAPI Docs
    • Redoc API Docs
    • Roadmap
    • Changelog
Powered by GitBook
On this page

Was this helpful?

  1. Getting Started

Saved Queries

PreviousSandboxNextHTML Templating

Last updated 4 years ago

Was this helpful?

To retrieve the data faster and cache the response saved queries can be used. These can also be used to hide the sources of the query. In the example below we retrieve user submitted genres for Netflix which would be called using the endpoint returned when clicking on view. For this example the url would be the following:

To refresh the cached results one just needs to append the query parameter refresh=True as shown below:

https://usesql.com/query/Kxa1e2/netflix-genres
https://usesql.com/query/Kxa1e2/netflix-genres?refresh=True